[cx-oracle-users] pick one Oracle client and access databases of any current version
Brought to you by:
atuining
Menu
▾
▴
[cx-oracle-users] pick one Oracle client and access databases of any current version
|
From: Robert L. <rlu...@pi...> - 2012-07-11 08:35:30
|
>pick one client >and access databases of any current version I would be careful w/ the above statement. There is a certification matrix of which Oracle clients work w/ which Oracle servers. The phrase "current version" is not specific enough. -----Original Message----- From: cx-...@li... [mailto:cx-...@li...] Sent: Tuesday, July 10, 2012 11:52 PM To: cx-...@li... Subject: cx-oracle-users Digest, Vol 72, Issue 3 Send cx-oracle-users mailing list submissions to cx-...@li... To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/cx-oracle-users or, via email, send a message with subject or body 'help' to cx-...@li... You can reach the person managing the list at cx-...@li... When replying, please edit your Subject line so it is more specific than "Re: Contents of cx-oracle-users digest..." Today's Topics: 1. cx_Oracle 5.1.2 (Anthony Tuininga) 2. Re: Next Release? (Anthony Tuininga) 3. Re: Next Release? (ba...@pl...) 4. Windows packaging problem? (David Roe) 5. Re: Windows packaging problem? (Anthony Tuininga) 6. Re: cx_Oracle 5.1.2 (James C. McPherson) 7. Re: cx_Oracle 5.1.2 (Anthony Tuininga) 8. Re: cx_Oracle 5.1.2 (James C. McPherson) ---------------------------------------------------------------------- Message: 1 Date: Fri, 6 Jul 2012 21:30:47 -0600 From: Anthony Tuininga <ant...@gm...> Subject: [cx-oracle-users] cx_Oracle 5.1.2 To: cx-...@li..., pyt...@py..., DB...@py... Message-ID: <CAE...@ma...> Content-Type: text/plain; charset=ISO-8859-1 What is cx_Oracle? cx_Oracle is a Python extension module that allows access to Oracle and conforms to the Python database API 2.0 specifications with a few exceptions. Where do I get it? http://cx-oracle.sourceforge.net What's new? 1) Added support for LONG_UNICODE which is a type used to handle long unicode strings. These are not explicitly supported in Oracle but can be used to bind to NCLOB, for example, without getting the error "unimplemented or unreasonable conversion requested". 2) Set the row number in a cursor when executing PL/SQL blocks as requested by Robert Ritchie. 3) Added support for setting the module, action and client_info attributes during connection so that logon triggers will see the supplied values, as requested by Rodney Barnett. In addition, binaries are now being built for Python 3.3. ------------------------------ Message: 2 Date: Fri, 6 Jul 2012 21:51:34 -0600 From: Anthony Tuininga <ant...@gm...> Subject: Re: [cx-oracle-users] Next Release? To: cx-...@li... Message-ID: <CAE...@ma...> Content-Type: text/plain; charset=ISO-8859-1 On Mon, Jul 2, 2012 at 6:34 AM, <ba...@pl...> wrote: >> Hi Rodney, >> >> I have run into some difficulties with my virtual machines due to some >> upgrades and the fact that I haven't used them for some time! So >> things have been delayed longer than expected.... :-( Should have them >> resolved shortly, though. Depending on which Python version and OS you >> require, though, I can focus on resolving the difficulties with that >> one first instead of the others. >> >> Anthony > > Looks like this version would be most useful: "CentOS 5 x86_64 RPM (Oracle > 11g, Python 2.7)". Well, I managed to resolve all of the problems I was having with my virtual machines....so the release has been made as you may have noticed already. Anthony ------------------------------ Message: 3 Date: Sat, 7 Jul 2012 09:24:43 -0400 (EDT) From: ba...@pl... Subject: Re: [cx-oracle-users] Next Release? To: cx-...@li... Message-ID: <472...@ma...> Content-Type: text/plain;charset=iso-8859-1 On Fri, July 6, 2012 11:51 pm, Anthony Tuininga wrote: > On Mon, Jul 2, 2012 at 6:34 AM, <ba...@pl...> wrote: >>> Hi Rodney, >>> >>> I have run into some difficulties with my virtual machines due to some >>> upgrades and the fact that I haven't used them for some time! So >>> things have been delayed longer than expected.... :-( Should have them >>> resolved shortly, though. Depending on which Python version and OS you >>> require, though, I can focus on resolving the difficulties with that >>> one first instead of the others. >>> >>> Anthony >> >> Looks like this version would be most useful: "CentOS 5 x86_64 RPM >> (Oracle >> 11g, Python 2.7)". > > Well, I managed to resolve all of the problems I was having with my > virtual machines....so the release has been made as you may have > noticed already. > > Anthony Thanks much, Anthony. This will be quite useful. Rodney ------------------------------ Message: 4 Date: Tue, 10 Jul 2012 09:44:01 +0100 From: David Roe <di...@gm...> Subject: [cx-oracle-users] Windows packaging problem? To: cx-...@li... Message-ID: <CAGHq334ULZY11XVYy05O_GsLADxwVp73SNjsdhcr=nce...@ma...> Content-Type: text/plain; charset="iso-8859-1" I just tried to install the latest 5.1.2 build for Windows and it doesn't seem to work. Looking in the site-packages folder, the cx_Oracle.pyd file seems to be missing. Installing 5.1.1 worked fine. I tried Python 2.7 and 3.2 versions for both 32bit and 64bit. Is there a problem with the current build of the Windows installers? -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 5 Date: Tue, 10 Jul 2012 22:24:32 -0600 From: Anthony Tuininga <ant...@gm...> Subject: Re: [cx-oracle-users] Windows packaging problem? To: cx-...@li... Message-ID: <CAE...@ma...> Content-Type: text/plain; charset=ISO-8859-1 Hi everyone, Yes, the Windows packages were done incorrectly. Some code in distutils overrides my build directory so I have to turn off that code every time I install a new version of Python -- and I forgot again. :-( New packages have been uploaded and you should be good to go. Apologies for the inconvenience. Anthony On Tue, Jul 10, 2012 at 2:44 AM, David Roe <di...@gm...> wrote: > I just tried to install the latest 5.1.2 build for Windows and it doesn't > seem to work. Looking in the site-packages folder, the cx_Oracle.pyd file > seems to be missing. Installing 5.1.1 worked fine. > > I tried Python 2.7 and 3.2 versions for both 32bit and 64bit. Is there a > problem with the current build of the Windows installers? > > -------------------------------------------------------------------------- ---- > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > ------------------------------ Message: 6 Date: Wed, 11 Jul 2012 14:43:10 +1000 From: "James C. McPherson" <Jam...@or...> Subject: Re: [cx-oracle-users] cx_Oracle 5.1.2 To: cx-...@li... Cc: DB...@py..., pyt...@py..., Anthony Tuininga <ant...@gm...> Message-ID: <4FF...@or...> Content-Type: text/plain; charset=UTF-8; format=flowed On 7/07/12 01:30 PM, Anthony Tuininga wrote: > What is cx_Oracle? > > cx_Oracle is a Python extension module that allows access to Oracle and > conforms to the Python database API 2.0 specifications with a few > exceptions. Hi Anthony, Could I clarify with you please, is it possible to build cx_Oracle so that I can support several different versions of the rdbms from the one cx_Oracle installation? ie, do I need a separate build for each 10g/11i/... version that I want to support, or can one build support them all (assuming a certain minimum rdbms version)? thanks in advance, James C. McPherson -- Oracle http://www.jmcpdotcom.com/blog ------------------------------ Message: 7 Date: Tue, 10 Jul 2012 22:50:29 -0600 From: Anthony Tuininga <ant...@gm...> Subject: Re: [cx-oracle-users] cx_Oracle 5.1.2 To: Jam...@or... Cc: cx-...@li..., DB...@py... Message-ID: <CAE1XR-5UbcLghnFN_N=cVw0vrAFbLVLyRgSuO9NUQHJFGev=EA...@ma...> Content-Type: text/plain; charset=ISO-8859-1 On Tue, Jul 10, 2012 at 10:43 PM, James C. McPherson <Jam...@or...> wrote: > On 7/07/12 01:30 PM, Anthony Tuininga wrote: >> >> What is cx_Oracle? >> >> cx_Oracle is a Python extension module that allows access to Oracle and >> conforms to the Python database API 2.0 specifications with a few >> exceptions. > > > Hi Anthony, > Could I clarify with you please, is it possible to build cx_Oracle > so that I can support several different versions of the rdbms from > the one cx_Oracle installation? > > ie, do I need a separate build for each 10g/11i/... version that I > want to support, or can one build support them all (assuming a certain > minimum rdbms version)? The client you use is what matters. There are some situations where the client won't work correctly with the server but they are few and far between. You should be able to pick one client and access databases of any current version (10i and 11g whether 32-bit or 64-bit) and use them with one cx_Oracle install. Hope that helps. Anthony ------------------------------ Message: 8 Date: Wed, 11 Jul 2012 14:52:14 +1000 From: "James C. McPherson" <Jam...@or...> Subject: Re: [cx-oracle-users] cx_Oracle 5.1.2 To: Anthony Tuininga <ant...@gm...> Cc: cx-...@li..., DB...@py... Message-ID: <4FF...@or...> Content-Type: text/plain; charset=UTF-8; format=flowed On 11/07/12 02:50 PM, Anthony Tuininga wrote: > On Tue, Jul 10, 2012 at 10:43 PM, James C. McPherson > <Jam...@or...> wrote: >> On 7/07/12 01:30 PM, Anthony Tuininga wrote: >>> >>> What is cx_Oracle? >>> >>> cx_Oracle is a Python extension module that allows access to Oracle and >>> conforms to the Python database API 2.0 specifications with a few >>> exceptions. >> >> >> Hi Anthony, >> Could I clarify with you please, is it possible to build cx_Oracle >> so that I can support several different versions of the rdbms from >> the one cx_Oracle installation? >> >> ie, do I need a separate build for each 10g/11i/... version that I >> want to support, or can one build support them all (assuming a certain >> minimum rdbms version)? > > The client you use is what matters. There are some situations where > the client won't work correctly with the server but they are few and > far between. You should be able to pick one client and access > databases of any current version (10i and 11g whether 32-bit or > 64-bit) and use them with one cx_Oracle install. Hope that helps. That helps quite a lot, thankyou. James C. McPherson -- Oracle http://www.jmcpdotcom.com/blog ------------------------------ ---------------------------------------------------------------------------- -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ------------------------------ _______________________________________________ cx-oracle-users mailing list cx-...@li... https://lists.sourceforge.net/lists/listinfo/cx-oracle-users End of cx-oracle-users Digest, Vol 72, Issue 3 ********************************************** |
