cx-oracle-users

[cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Robert, A. <AR...@MF...>]

Hi Everyone,


In an effort to learn Python better as well as tie it in to my everyday
work, I would like to find a suitable Python module for Oracle v9
databases that works under both Linux and AIX.

The cx_Oracle module has a Windows installer that works well but the
RPM's available are only for RH9.

I tried building a new rpm for Fedora Core 3 but ran into problems with
the SPEC file and the setup.py included in the source.

The SPEC file is hard-coded to reference Python v2.2 and the setup.py
=66ile does not have code in place to handle a sys.platform value of
linux2.

Does anyone know of a way to get cx_Oracle functioning on Fedora Core 3
and AIX=3F

Any help you can provide on this would be greatly appreciated.

Thank you,
Andrew Robert
Systems Architect
Information Technology=20
Massachusetts Financial Services
Phone:  617-954-5882
Pager:   781-764-7321
E-mail:  ar...@mf...
Linux User Number: #201204


"MFS Relay Service" made the following
 annotations on 11/29/2004 11:29:16 AM
---------------------------------------------------------------------------=
---
This email communication and any attachments may contain proprietary, =
confidential, or privileged information.  If you are not the intended =
recipient, you are hereby notified that you have received this email in =
error and that any review, disclosure, dissemination, distribution or =
copying of it or its contents is prohibited.  The sender does not waive =
confidentiality or any privilege by mistransmission.  If you have received =
this email in error, please notify the sender immediately, delete this =
email, and destroy all copies and any attachments.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Re: [cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Mihai I. <mi...@re...>]

On Mon, Nov 29, 2004 at 11:23:39AM -0500, Robert, Andrew wrote:
> Hi Everyone,
> 
> 
> In an effort to learn Python better as well as tie it in to my everyday
> work, I would like to find a suitable Python module for Oracle v9
> databases that works under both Linux and AIX.
> 
> The cx_Oracle module has a Windows installer that works well but the
> RPM's available are only for RH9.
> 
> I tried building a new rpm for Fedora Core 3 but ran into problems with
> the SPEC file and the setup.py included in the source.
> 
> The SPEC file is hard-coded to reference Python v2.2 and the setup.py
> file does not have code in place to handle a sys.platform value of
> linux2.
> 
> Does anyone know of a way to get cx_Oracle functioning on Fedora Core 3
> and AIX?
> 
> Any help you can provide on this would be greatly appreciated.

ftp://people.redhat.com/misa/cx_Oracle/

I am not sure about AIX; this rpm works for me on FC3 (on an amd64 box too!).
As long as you have ORACLE_HOME set, it should build.

Let me know if it doesn't work for you.

Cheers,
Misa

Re: [cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Anthony T. <an...@co...>]

First, let me tell you that I am no expert on creating RPMs. I have 
simply been using "python setup.py bdist_rpm" and posting the results. 
They work but are fairly limited, as you already noted. :-) Misa, can 
you indicate what is different in your RPMs? If I can use a specific 
SPEC file which is more intelligent rather than the default one 
generated by distutils, I'd be quite happy to do so.

BTW, you should be able to build the cx_Oracle module from source 
yourself directly using setup.py.

Mihai Ibanescu wrote:
> On Mon, Nov 29, 2004 at 11:23:39AM -0500, Robert, Andrew wrote:
> 
>>Hi Everyone,
>>
>>
>>In an effort to learn Python better as well as tie it in to my everyday
>>work, I would like to find a suitable Python module for Oracle v9
>>databases that works under both Linux and AIX.
>>
>>The cx_Oracle module has a Windows installer that works well but the
>>RPM's available are only for RH9.
>>
>>I tried building a new rpm for Fedora Core 3 but ran into problems with
>>the SPEC file and the setup.py included in the source.
>>
>>The SPEC file is hard-coded to reference Python v2.2 and the setup.py
>>file does not have code in place to handle a sys.platform value of
>>linux2.
>>
>>Does anyone know of a way to get cx_Oracle functioning on Fedora Core 3
>>and AIX?
>>
>>Any help you can provide on this would be greatly appreciated.
> 
> 
> ftp://people.redhat.com/misa/cx_Oracle/
> 
> I am not sure about AIX; this rpm works for me on FC3 (on an amd64 box too!).
> As long as you have ORACLE_HOME set, it should build.
> 
> Let me know if it doesn't work for you.
> 
> Cheers,
> Misa
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Mihai I. <mi...@re...>]

On Mon, Nov 29, 2004 at 10:15:36AM -0700, Anthony Tuininga wrote:
> First, let me tell you that I am no expert on creating RPMs. I have 
> simply been using "python setup.py bdist_rpm" and posting the results. 
> They work but are fairly limited, as you already noted. :-) Misa, can 
> you indicate what is different in your RPMs? If I can use a specific 
> SPEC file which is more intelligent rather than the default one 
> generated by distutils, I'd be quite happy to do so.

I have started from python setup.py bdist_rpm  and then tailored the spec file
for my needs:

- patched cx_Oracle heavily (but the packages have been accepted for the beta
  1; the only outstanding one is the rpath one which I didn't bother to submit
  upstream because I thought it's too specific to the way I use cx_Oracle).
  Adding patches with distutils is a pain, if even possible.
- Changelog entries are nice. rpm's changelog entries should be packaging
  specific while HISTORY.txt is specific to the software that is packaged - at
  least that's how I see it.
- I have the habit of not trying to invoke python directly, but using the
  rpm macro %{__python} - just because I used to have both python 1.5 and
  python 2.2 on the same system and I was sometimes building with the
  interpreter being python2. That's not useful anymore, but I still have the
  habit :-)

I just diffed my spec file vs. a bdist_rpm one, and they only seem to be
different by the two above-mentioned ones.

I have attached the rpath patch in case anybody else is interested. This will
allow one to call cx_Oracle without having to set LD_LIBRARY_PATH in order for
the linker to find libclntsh.so

Misa