cx-oracle-users Mailing List for cx_Oracle (Page 35)
Brought to you by:
atuining
Menu
▾
▴
cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(5) |
Aug
(9) |
Sep
(8) |
Oct
(12) |
Nov
(4) |
Dec
(8) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(15) |
Feb
(12) |
Mar
(11) |
Apr
(5) |
May
(7) |
Jun
(8) |
Jul
(12) |
Aug
(2) |
Sep
(14) |
Oct
(17) |
Nov
(20) |
Dec
(3) |
| 2005 |
Jan
(16) |
Feb
(9) |
Mar
(22) |
Apr
(21) |
May
(73) |
Jun
(16) |
Jul
(15) |
Aug
(10) |
Sep
(32) |
Oct
(35) |
Nov
(22) |
Dec
(13) |
| 2006 |
Jan
(42) |
Feb
(36) |
Mar
(13) |
Apr
(18) |
May
(8) |
Jun
(17) |
Jul
(24) |
Aug
(30) |
Sep
(35) |
Oct
(33) |
Nov
(33) |
Dec
(11) |
| 2007 |
Jan
(35) |
Feb
(31) |
Mar
(35) |
Apr
(64) |
May
(38) |
Jun
(12) |
Jul
(18) |
Aug
(34) |
Sep
(75) |
Oct
(29) |
Nov
(51) |
Dec
(11) |
| 2008 |
Jan
(27) |
Feb
(46) |
Mar
(48) |
Apr
(36) |
May
(59) |
Jun
(42) |
Jul
(25) |
Aug
(34) |
Sep
(57) |
Oct
(97) |
Nov
(59) |
Dec
(57) |
| 2009 |
Jan
(48) |
Feb
(48) |
Mar
(45) |
Apr
(24) |
May
(46) |
Jun
(52) |
Jul
(52) |
Aug
(37) |
Sep
(27) |
Oct
(40) |
Nov
(37) |
Dec
(13) |
| 2010 |
Jan
(16) |
Feb
(9) |
Mar
(24) |
Apr
(6) |
May
(27) |
Jun
(28) |
Jul
(60) |
Aug
(16) |
Sep
(33) |
Oct
(20) |
Nov
(39) |
Dec
(30) |
| 2011 |
Jan
(23) |
Feb
(43) |
Mar
(16) |
Apr
(29) |
May
(23) |
Jun
(16) |
Jul
(10) |
Aug
(8) |
Sep
(18) |
Oct
(42) |
Nov
(26) |
Dec
(20) |
| 2012 |
Jan
(17) |
Feb
(27) |
Mar
|
Apr
(20) |
May
(18) |
Jun
(7) |
Jul
(24) |
Aug
(21) |
Sep
(23) |
Oct
(18) |
Nov
(12) |
Dec
(5) |
| 2013 |
Jan
(14) |
Feb
(10) |
Mar
(20) |
Apr
(65) |
May
(3) |
Jun
(8) |
Jul
(6) |
Aug
(3) |
Sep
|
Oct
(3) |
Nov
(28) |
Dec
(3) |
| 2014 |
Jan
(3) |
Feb
(9) |
Mar
(4) |
Apr
(7) |
May
(20) |
Jun
(2) |
Jul
(20) |
Aug
(7) |
Sep
(11) |
Oct
(8) |
Nov
(6) |
Dec
(12) |
| 2015 |
Jan
(16) |
Feb
(10) |
Mar
(14) |
Apr
(8) |
May
|
Jun
(8) |
Jul
(15) |
Aug
(7) |
Sep
(1) |
Oct
(33) |
Nov
(8) |
Dec
(5) |
| 2016 |
Jan
(18) |
Feb
(12) |
Mar
(6) |
Apr
(14) |
May
(5) |
Jun
(3) |
Jul
|
Aug
(21) |
Sep
|
Oct
(15) |
Nov
(8) |
Dec
|
| 2017 |
Jan
|
Feb
(14) |
Mar
(21) |
Apr
(9) |
May
(6) |
Jun
(11) |
Jul
(23) |
Aug
(6) |
Sep
(5) |
Oct
(7) |
Nov
(1) |
Dec
(1) |
| 2018 |
Jan
|
Feb
|
Mar
(16) |
Apr
(2) |
May
(1) |
Jun
|
Jul
(2) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
(2) |
Feb
(3) |
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
(2) |
Aug
(1) |
Sep
(2) |
Oct
|
Nov
|
Dec
(1) |
| 2020 |
Jan
|
Feb
(4) |
Mar
|
Apr
|
May
(2) |
Jun
(1) |
Jul
(4) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
(3) |
| 2021 |
Jan
|
Feb
(5) |
Mar
|
Apr
(7) |
May
(6) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Ran M. <ran...@or...> - 2012-01-09 19:45:04
|
Hi Anthony, great! will do ;-) and once I want to upgrade to the latest cx_Oracle that shouldn't be a problem right? Thanks, Ran On Jan 9, 2012, at 7:17 PM, Anthony Tuininga wrote: > Hi Ran, > > Just use an older version of cx_Oracle (4.4.1) that still supports > Python 2.3, that's all. :-) > > Anthony > > On Mon, Jan 9, 2012 at 11:00 AM, Ran Mozes <ran...@or...> wrote: >> Hi Anthony, >> >> using RH5.7 with newer python (2.4 or higher probably 2.7) is actually my plan >> but our application still uses 2.3 so as an intermediate step I want to make sure it can also run with 2.3. >> Any recommendation on how to do that? I forgot to mention we plan to work with 11g. >> >> Thanks for your help once again! >> Ran >> >> On Jan 9, 2012, at 6:00 PM, Anthony Tuininga wrote: >> >>> Hi Ran, >>> >>> Doesn't RH5.7 come with Python 2.4 as the default? Why wouldn't you >>> use that? That is currently supported by the latest version of >>> cx_Oracle as I build with CentOS 5.x. >>> >>> Anthony >>> >>> On Mon, Jan 9, 2012 at 8:47 AM, Ran Mozes <ran...@or...> wrote: >>>> Hi Anthony, >>>> >>>> thanks for your help. >>>> >>>> changing my Q: >>>> Considering using python2.3 with cx_oracle on RH5.7, any comments for this option? >>>> >>>> Regards, >>>> Ran >>>> >>>> On Jan 9, 2012, at 4:16 PM, Anthony Tuininga wrote: >>>> >>>>> Hi, I should be able to answer your questions. :) >>>>> >>>>> 1) The last official version of cx_Oracle that supported Python 2.3 >>>>> was 4.4.1. You can find a copy here >>>>> >>>>> http://sourceforge.net/projects/cx-oracle/files/ >>>>> >>>>> 2) Download the source and compile. You can attempt the precompiled >>>>> version but may run into difficulties as I did not use RHEL/CentOS >>>>> with version 4.x. >>>>> >>>>> 3) I used it myself at the time without any known difficulties. After >>>>> 4.4.1 you will have to patch the source to make it work with Python >>>>> 2.3 so I wouldn't recommend that. If anything, I'd recommend upgrading >>>>> your OS. :-) >>>>> >>>>> Anthony >>>>> >>>>> On Mon, Jan 9, 2012 at 2:01 AM, Ran Mozes <ran...@or...> wrote: >>>>>> Hi cx-oracle-users, >>>>>> >>>>>> I am new to this list so sorry if I am reposting something old. I remember to have used cx_oracle >>>>>> with pyhton 2.3 in the past but haven't found any pros/cons or compatibility documentation about it. >>>>>> >>>>>> So my questions are: >>>>>> 1. Can I use cx_oracle with python2.3 (on RHEL4.6 OS)? >>>>>> 2. If yes what is needed to be done? (just use the source and compile it?) >>>>>> 3. Are there any known major drawbacks using it with python2.3? (in case the above is doable) >>>>>> >>>>>> Many thanks for your help and sorry again if I'm reposting something old. >>>>>> >>>>>> Regards, >>>>>> Ran >>>>>> ------------------------------------------------------------------------------ >>>>>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>>>>> infrastructure or vast IT resources to deliver seamless, secure access to >>>>>> virtual desktops. With this all-in-one solution, easily deploy virtual >>>>>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>>>>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>>>>> _______________________________________________ >>>>>> cx-oracle-users mailing list >>>>>> cx-...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>>>> infrastructure or vast IT resources to deliver seamless, secure access to >>>>> virtual desktops. With this all-in-one solution, easily deploy virtual >>>>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>>>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>>>> _______________________________________________ >>>>> cx-oracle-users mailing list >>>>> cx-...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>>> infrastructure or vast IT resources to deliver seamless, secure access to >>>> virtual desktops. With this all-in-one solution, easily deploy virtual >>>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> ------------------------------------------------------------------------------ >>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>> infrastructure or vast IT resources to deliver seamless, secure access to >>> virtual desktops. With this all-in-one solution, easily deploy virtual >>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> >> ------------------------------------------------------------------------------ >> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >> infrastructure or vast IT resources to deliver seamless, secure access to >> virtual desktops. With this all-in-one solution, easily deploy virtual >> desktops for less than the cost of PCs and save 60% on VDI infrastructure >> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > ------------------------------------------------------------------------------ > Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex > infrastructure or vast IT resources to deliver seamless, secure access to > virtual desktops. With this all-in-one solution, easily deploy virtual > desktops for less than the cost of PCs and save 60% on VDI infrastructure > costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
|
From: Anthony T. <ant...@gm...> - 2012-01-09 18:18:06
|
Hi Ran, Just use an older version of cx_Oracle (4.4.1) that still supports Python 2.3, that's all. :-) Anthony On Mon, Jan 9, 2012 at 11:00 AM, Ran Mozes <ran...@or...> wrote: > Hi Anthony, > > using RH5.7 with newer python (2.4 or higher probably 2.7) is actually my plan > but our application still uses 2.3 so as an intermediate step I want to make sure it can also run with 2.3. > Any recommendation on how to do that? I forgot to mention we plan to work with 11g. > > Thanks for your help once again! > Ran > > On Jan 9, 2012, at 6:00 PM, Anthony Tuininga wrote: > >> Hi Ran, >> >> Doesn't RH5.7 come with Python 2.4 as the default? Why wouldn't you >> use that? That is currently supported by the latest version of >> cx_Oracle as I build with CentOS 5.x. >> >> Anthony >> >> On Mon, Jan 9, 2012 at 8:47 AM, Ran Mozes <ran...@or...> wrote: >>> Hi Anthony, >>> >>> thanks for your help. >>> >>> changing my Q: >>> Considering using python2.3 with cx_oracle on RH5.7, any comments for this option? >>> >>> Regards, >>> Ran >>> >>> On Jan 9, 2012, at 4:16 PM, Anthony Tuininga wrote: >>> >>>> Hi, I should be able to answer your questions. :) >>>> >>>> 1) The last official version of cx_Oracle that supported Python 2.3 >>>> was 4.4.1. You can find a copy here >>>> >>>> http://sourceforge.net/projects/cx-oracle/files/ >>>> >>>> 2) Download the source and compile. You can attempt the precompiled >>>> version but may run into difficulties as I did not use RHEL/CentOS >>>> with version 4.x. >>>> >>>> 3) I used it myself at the time without any known difficulties. After >>>> 4.4.1 you will have to patch the source to make it work with Python >>>> 2.3 so I wouldn't recommend that. If anything, I'd recommend upgrading >>>> your OS. :-) >>>> >>>> Anthony >>>> >>>> On Mon, Jan 9, 2012 at 2:01 AM, Ran Mozes <ran...@or...> wrote: >>>>> Hi cx-oracle-users, >>>>> >>>>> I am new to this list so sorry if I am reposting something old. I remember to have used cx_oracle >>>>> with pyhton 2.3 in the past but haven't found any pros/cons or compatibility documentation about it. >>>>> >>>>> So my questions are: >>>>> 1. Can I use cx_oracle with python2.3 (on RHEL4.6 OS)? >>>>> 2. If yes what is needed to be done? (just use the source and compile it?) >>>>> 3. Are there any known major drawbacks using it with python2.3? (in case the above is doable) >>>>> >>>>> Many thanks for your help and sorry again if I'm reposting something old. >>>>> >>>>> Regards, >>>>> Ran >>>>> ------------------------------------------------------------------------------ >>>>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>>>> infrastructure or vast IT resources to deliver seamless, secure access to >>>>> virtual desktops. With this all-in-one solution, easily deploy virtual >>>>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>>>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>>>> _______________________________________________ >>>>> cx-oracle-users mailing list >>>>> cx-...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>> >>>> ------------------------------------------------------------------------------ >>>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>>> infrastructure or vast IT resources to deliver seamless, secure access to >>>> virtual desktops. With this all-in-one solution, easily deploy virtual >>>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> >>> ------------------------------------------------------------------------------ >>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>> infrastructure or vast IT resources to deliver seamless, secure access to >>> virtual desktops. With this all-in-one solution, easily deploy virtual >>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> ------------------------------------------------------------------------------ >> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >> infrastructure or vast IT resources to deliver seamless, secure access to >> virtual desktops. With this all-in-one solution, easily deploy virtual >> desktops for less than the cost of PCs and save 60% on VDI infrastructure >> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > ------------------------------------------------------------------------------ > Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex > infrastructure or vast IT resources to deliver seamless, secure access to > virtual desktops. With this all-in-one solution, easily deploy virtual > desktops for less than the cost of PCs and save 60% on VDI infrastructure > costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
|
From: Ran M. <ran...@or...> - 2012-01-09 18:00:55
|
Hi Anthony, using RH5.7 with newer python (2.4 or higher probably 2.7) is actually my plan but our application still uses 2.3 so as an intermediate step I want to make sure it can also run with 2.3. Any recommendation on how to do that? I forgot to mention we plan to work with 11g. Thanks for your help once again! Ran On Jan 9, 2012, at 6:00 PM, Anthony Tuininga wrote: > Hi Ran, > > Doesn't RH5.7 come with Python 2.4 as the default? Why wouldn't you > use that? That is currently supported by the latest version of > cx_Oracle as I build with CentOS 5.x. > > Anthony > > On Mon, Jan 9, 2012 at 8:47 AM, Ran Mozes <ran...@or...> wrote: >> Hi Anthony, >> >> thanks for your help. >> >> changing my Q: >> Considering using python2.3 with cx_oracle on RH5.7, any comments for this option? >> >> Regards, >> Ran >> >> On Jan 9, 2012, at 4:16 PM, Anthony Tuininga wrote: >> >>> Hi, I should be able to answer your questions. :) >>> >>> 1) The last official version of cx_Oracle that supported Python 2.3 >>> was 4.4.1. You can find a copy here >>> >>> http://sourceforge.net/projects/cx-oracle/files/ >>> >>> 2) Download the source and compile. You can attempt the precompiled >>> version but may run into difficulties as I did not use RHEL/CentOS >>> with version 4.x. >>> >>> 3) I used it myself at the time without any known difficulties. After >>> 4.4.1 you will have to patch the source to make it work with Python >>> 2.3 so I wouldn't recommend that. If anything, I'd recommend upgrading >>> your OS. :-) >>> >>> Anthony >>> >>> On Mon, Jan 9, 2012 at 2:01 AM, Ran Mozes <ran...@or...> wrote: >>>> Hi cx-oracle-users, >>>> >>>> I am new to this list so sorry if I am reposting something old. I remember to have used cx_oracle >>>> with pyhton 2.3 in the past but haven't found any pros/cons or compatibility documentation about it. >>>> >>>> So my questions are: >>>> 1. Can I use cx_oracle with python2.3 (on RHEL4.6 OS)? >>>> 2. If yes what is needed to be done? (just use the source and compile it?) >>>> 3. Are there any known major drawbacks using it with python2.3? (in case the above is doable) >>>> >>>> Many thanks for your help and sorry again if I'm reposting something old. >>>> >>>> Regards, >>>> Ran >>>> ------------------------------------------------------------------------------ >>>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>>> infrastructure or vast IT resources to deliver seamless, secure access to >>>> virtual desktops. With this all-in-one solution, easily deploy virtual >>>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> ------------------------------------------------------------------------------ >>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>> infrastructure or vast IT resources to deliver seamless, secure access to >>> virtual desktops. With this all-in-one solution, easily deploy virtual >>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> >> ------------------------------------------------------------------------------ >> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >> infrastructure or vast IT resources to deliver seamless, secure access to >> virtual desktops. With this all-in-one solution, easily deploy virtual >> desktops for less than the cost of PCs and save 60% on VDI infrastructure >> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > ------------------------------------------------------------------------------ > Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex > infrastructure or vast IT resources to deliver seamless, secure access to > virtual desktops. With this all-in-one solution, easily deploy virtual > desktops for less than the cost of PCs and save 60% on VDI infrastructure > costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
|
From: Anthony T. <ant...@gm...> - 2012-01-09 17:00:11
|
Hi Ran, Doesn't RH5.7 come with Python 2.4 as the default? Why wouldn't you use that? That is currently supported by the latest version of cx_Oracle as I build with CentOS 5.x. Anthony On Mon, Jan 9, 2012 at 8:47 AM, Ran Mozes <ran...@or...> wrote: > Hi Anthony, > > thanks for your help. > > changing my Q: > Considering using python2.3 with cx_oracle on RH5.7, any comments for this option? > > Regards, > Ran > > On Jan 9, 2012, at 4:16 PM, Anthony Tuininga wrote: > >> Hi, I should be able to answer your questions. :) >> >> 1) The last official version of cx_Oracle that supported Python 2.3 >> was 4.4.1. You can find a copy here >> >> http://sourceforge.net/projects/cx-oracle/files/ >> >> 2) Download the source and compile. You can attempt the precompiled >> version but may run into difficulties as I did not use RHEL/CentOS >> with version 4.x. >> >> 3) I used it myself at the time without any known difficulties. After >> 4.4.1 you will have to patch the source to make it work with Python >> 2.3 so I wouldn't recommend that. If anything, I'd recommend upgrading >> your OS. :-) >> >> Anthony >> >> On Mon, Jan 9, 2012 at 2:01 AM, Ran Mozes <ran...@or...> wrote: >>> Hi cx-oracle-users, >>> >>> I am new to this list so sorry if I am reposting something old. I remember to have used cx_oracle >>> with pyhton 2.3 in the past but haven't found any pros/cons or compatibility documentation about it. >>> >>> So my questions are: >>> 1. Can I use cx_oracle with python2.3 (on RHEL4.6 OS)? >>> 2. If yes what is needed to be done? (just use the source and compile it?) >>> 3. Are there any known major drawbacks using it with python2.3? (in case the above is doable) >>> >>> Many thanks for your help and sorry again if I'm reposting something old. >>> >>> Regards, >>> Ran >>> ------------------------------------------------------------------------------ >>> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >>> infrastructure or vast IT resources to deliver seamless, secure access to >>> virtual desktops. With this all-in-one solution, easily deploy virtual >>> desktops for less than the cost of PCs and save 60% on VDI infrastructure >>> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> ------------------------------------------------------------------------------ >> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >> infrastructure or vast IT resources to deliver seamless, secure access to >> virtual desktops. With this all-in-one solution, easily deploy virtual >> desktops for less than the cost of PCs and save 60% on VDI infrastructure >> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > ------------------------------------------------------------------------------ > Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex > infrastructure or vast IT resources to deliver seamless, secure access to > virtual desktops. With this all-in-one solution, easily deploy virtual > desktops for less than the cost of PCs and save 60% on VDI infrastructure > costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
|
From: Ran M. <ran...@or...> - 2012-01-09 15:47:44
|
Hi Anthony, thanks for your help. changing my Q: Considering using python2.3 with cx_oracle on RH5.7, any comments for this option? Regards, Ran On Jan 9, 2012, at 4:16 PM, Anthony Tuininga wrote: > Hi, I should be able to answer your questions. :) > > 1) The last official version of cx_Oracle that supported Python 2.3 > was 4.4.1. You can find a copy here > > http://sourceforge.net/projects/cx-oracle/files/ > > 2) Download the source and compile. You can attempt the precompiled > version but may run into difficulties as I did not use RHEL/CentOS > with version 4.x. > > 3) I used it myself at the time without any known difficulties. After > 4.4.1 you will have to patch the source to make it work with Python > 2.3 so I wouldn't recommend that. If anything, I'd recommend upgrading > your OS. :-) > > Anthony > > On Mon, Jan 9, 2012 at 2:01 AM, Ran Mozes <ran...@or...> wrote: >> Hi cx-oracle-users, >> >> I am new to this list so sorry if I am reposting something old. I remember to have used cx_oracle >> with pyhton 2.3 in the past but haven't found any pros/cons or compatibility documentation about it. >> >> So my questions are: >> 1. Can I use cx_oracle with python2.3 (on RHEL4.6 OS)? >> 2. If yes what is needed to be done? (just use the source and compile it?) >> 3. Are there any known major drawbacks using it with python2.3? (in case the above is doable) >> >> Many thanks for your help and sorry again if I'm reposting something old. >> >> Regards, >> Ran >> ------------------------------------------------------------------------------ >> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex >> infrastructure or vast IT resources to deliver seamless, secure access to >> virtual desktops. With this all-in-one solution, easily deploy virtual >> desktops for less than the cost of PCs and save 60% on VDI infrastructure >> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > ------------------------------------------------------------------------------ > Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex > infrastructure or vast IT resources to deliver seamless, secure access to > virtual desktops. With this all-in-one solution, easily deploy virtual > desktops for less than the cost of PCs and save 60% on VDI infrastructure > costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
|
From: Anthony T. <ant...@gm...> - 2012-01-09 15:16:57
|
Hi, I should be able to answer your questions. :) 1) The last official version of cx_Oracle that supported Python 2.3 was 4.4.1. You can find a copy here http://sourceforge.net/projects/cx-oracle/files/ 2) Download the source and compile. You can attempt the precompiled version but may run into difficulties as I did not use RHEL/CentOS with version 4.x. 3) I used it myself at the time without any known difficulties. After 4.4.1 you will have to patch the source to make it work with Python 2.3 so I wouldn't recommend that. If anything, I'd recommend upgrading your OS. :-) Anthony On Mon, Jan 9, 2012 at 2:01 AM, Ran Mozes <ran...@or...> wrote: > Hi cx-oracle-users, > > I am new to this list so sorry if I am reposting something old. I remember to have used cx_oracle > with pyhton 2.3 in the past but haven't found any pros/cons or compatibility documentation about it. > > So my questions are: > 1. Can I use cx_oracle with python2.3 (on RHEL4.6 OS)? > 2. If yes what is needed to be done? (just use the source and compile it?) > 3. Are there any known major drawbacks using it with python2.3? (in case the above is doable) > > Many thanks for your help and sorry again if I'm reposting something old. > > Regards, > Ran > ------------------------------------------------------------------------------ > Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex > infrastructure or vast IT resources to deliver seamless, secure access to > virtual desktops. With this all-in-one solution, easily deploy virtual > desktops for less than the cost of PCs and save 60% on VDI infrastructure > costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
|
From: Ran M. <ran...@or...> - 2012-01-09 09:01:16
|
Hi cx-oracle-users, I am new to this list so sorry if I am reposting something old. I remember to have used cx_oracle with pyhton 2.3 in the past but haven't found any pros/cons or compatibility documentation about it. So my questions are: 1. Can I use cx_oracle with python2.3 (on RHEL4.6 OS)? 2. If yes what is needed to be done? (just use the source and compile it?) 3. Are there any known major drawbacks using it with python2.3? (in case the above is doable) Many thanks for your help and sorry again if I'm reposting something old. Regards, Ran |
|
From: jo <jos...@sf...> - 2011-12-17 07:33:45
|
Great! thanks a lot, Anthony.
j
Anthony Tuininga wrote:
> Yes, the latest version adds service_name as an optional parameter.
>
> makedsn('myhost', '1521', service_name = 'mydb')
>
> or if you prefer to use all keywords
>
> makedsn(host = 'myhost', port = 1521, service_name = 'mydb')
>
> Hope that helps!
>
> Anthony
>
> On Fri, Dec 16, 2011 at 9:24 AM, jo <jos...@sf...> wrote:
>
>> Hi all,
>>
>> I'm trying to access to an oracle service name but makedsn compile the
>> dsn string with a SID, like this:
>>
>>
>> dsn = cx_Oracle.makedsn('myhost',1521,'mydb')
>> print dsn
>> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SID=mydb)))
>>
>>
>>
>> I'm using this ugly workaround by replacing 'SID' with 'SERVICE_NAME':
>>
>>
>> dsn = cx.makedsn('myhost',1521,'mydb').replace('SID','SERVICE_NAME')
>> print dsn
>> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mydb)))
>>
>>
>>
>> It works but I don't like it. Is there another way to do that?
>> Thanks for any help.
>>
>> j
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Learn Windows Azure Live! Tuesday, Dec 13, 2011
>> Microsoft is holding a special Learn Windows Azure training event for
>> developers. It will provide a great way to learn Windows Azure and what it
>> provides. You can attend the event by watching it streamed LIVE online.
>> Learn more at http://p.sf.net/sfu/ms-windowsazure
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>
> ------------------------------------------------------------------------------
> Learn Windows Azure Live! Tuesday, Dec 13, 2011
> Microsoft is holding a special Learn Windows Azure training event for
> developers. It will provide a great way to learn Windows Azure and what it
> provides. You can attend the event by watching it streamed LIVE online.
> Learn more at http://p.sf.net/sfu/ms-windowsazure
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
--
Jose Soares
Sferacarta Net
Via Bazzanese 69
40033 Casalecchio di Reno
Bologna - Italy
Ph +39051591054
fax +390516131537
web:www.sferacarta.com
Le informazioni contenute nella presente mail ed in ogni eventuale file allegato sono riservate e, comunque, destinate esclusivamente alla persona o ente sopraindicati, ai sensi del decreto legislativo 30 giugno 2003, n. 196. La diffusione, distribuzione e/o copiatura della mail trasmessa, da parte di qualsiasi soggetto diverso dal destinatario, sono vietate. La correttezza, l’integrità e la sicurezza della presente mail non possono essere garantite. Se avete ricevuto questa mail per errore, Vi preghiamo di contattarci immediatamente e di eliminarla. Grazie.
This communication is intended only for use by the addressee, pursuant to legislative decree 30 June 2003, n. 196. It may contain confidential or privileged information. You should not copy or use it to disclose its contents to any other person. Transmission cannot be guaranteed to be error-free, complete and secure. If you are not the intended recipient and receive this communication unintentionally, please inform us immediately and then delete this message from your system. Thank you.
|
|
From: Anthony T. <ant...@gm...> - 2011-12-16 17:39:42
|
Yes, the latest version adds service_name as an optional parameter.
makedsn('myhost', '1521', service_name = 'mydb')
or if you prefer to use all keywords
makedsn(host = 'myhost', port = 1521, service_name = 'mydb')
Hope that helps!
Anthony
On Fri, Dec 16, 2011 at 9:24 AM, jo <jos...@sf...> wrote:
>
> Hi all,
>
> I'm trying to access to an oracle service name but makedsn compile the
> dsn string with a SID, like this:
>
>
> dsn = cx_Oracle.makedsn('myhost',1521,'mydb')
> print dsn
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SID=mydb)))
>
>
>
> I'm using this ugly workaround by replacing 'SID' with 'SERVICE_NAME':
>
>
> dsn = cx.makedsn('myhost',1521,'mydb').replace('SID','SERVICE_NAME')
> print dsn
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mydb)))
>
>
>
> It works but I don't like it. Is there another way to do that?
> Thanks for any help.
>
> j
>
>
>
> ------------------------------------------------------------------------------
> Learn Windows Azure Live! Tuesday, Dec 13, 2011
> Microsoft is holding a special Learn Windows Azure training event for
> developers. It will provide a great way to learn Windows Azure and what it
> provides. You can attend the event by watching it streamed LIVE online.
> Learn more at http://p.sf.net/sfu/ms-windowsazure
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
|
|
From: jo <jos...@sf...> - 2011-12-16 16:24:44
|
Hi all,
I'm trying to access to an oracle service name but makedsn compile the
dsn string with a SID, like this:
dsn = cx_Oracle.makedsn('myhost',1521,'mydb')
print dsn
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SID=mydb)))
I'm using this ugly workaround by replacing 'SID' with 'SERVICE_NAME':
dsn = cx.makedsn('myhost',1521,'mydb').replace('SID','SERVICE_NAME')
print dsn
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mydb)))
It works but I don't like it. Is there another way to do that?
Thanks for any help.
j
|
|
From: Lassi T. <la...@ce...> - 2011-12-12 06:02:34
|
Hi, The attached patch releases the python interpreter lock during an OCIPing() and OCIBreak() calls. We have a client app which uses connection caching, and we've found that if a TCP connection to the database server was already established, but then goes sour, the call to connection.ping() will freeze the entire python interpreter until OCIPing() returns. That in turn appears to take very long to happen, even in presence of TCP keep-alive settings and ENABLE=BROKEN. Other threads in our application need to be able to run while the oracle client library ponders about the bad connection. From looking at the code it seems OCIBreak() may also need similar wrapper, but we don't use connection.cancel() so I am uncertain if it's prone to hanging. I added the wrapper as it seems unlikely to cause much overhead. Tested with cx_oracle 5.1, instant client 11.2.0.1.0 (linux) and 10.2.0.4.0 (os x) connected to server 10.2.0.5.0, with different sorts of induced network outages. Regards, Lassi |
|
From: Wong W. Meng-R. <r3...@fr...> - 2011-12-09 02:08:13
|
Hi Amaury, This is the conclusion from my testing. Yes indeed the None *is* well supported in cx_Oracle. It is a bug that is introduced when I was trying to reorder the position of bind variables in the argument to SQL so that we support backward compatibility with oracledb. Thanks again for your earlier reply. Regards, Wah Meng From: Wong Wah Meng-R32813 Sent: Thursday, December 08, 2011 10:08 AM To: cx-...@li... Subject: RE: [cx-oracle-users] Passing None as values of bind variables in cx_Oracle's cursor.execute() command Thanks for your reply. Based on your None as bind variable's value *is* supported, I would like to redo my testing to reaffirm the case before updating you my test script. Maybe something was introduced in my inputtypehandler of the cursor object. I will revert with my findings later. From: Amaury Forgeot d'Arc [mailto:ama...@gm...] Sent: Wednesday, December 07, 2011 6:28 PM To: cx-...@li... Subject: Re: [cx-oracle-users] Passing None as values of bind variables in cx_Oracle's cursor.execute() command Hi, 2011/12/7 Wong Wah Meng-R32813 <r3...@fr...<mailto:r3...@fr...>> Hello there, I am converting my application from python 1.5.2 and oracledb to python 2.7.1 and cx_Oracle.. I noticed one issue here whenever the bind variable's value is None, it exhibits some strange behavior. First observation: When it is the first time I pass in a bind variable as None, it gives an EOL file. However, subsequent passing of None value to the same SQL seems to be working fine. This is surprising. But what do you mean by "EOL file"? Second observation: When there is more than one bind variables contain None value, the value that actually got received at Oracle level seems to be messed up. (We turn on the highest debug level at Oracle level in order to see the bind variable value that are received). Those defined as None are received as some arbitrary value, some are the values from one or a few of the total bind variables. When None is passed, cx_Oracle sets the "NULL indicator" of the bind variable. But this changes only one bit of the memory, so if you look at the raw memory, it will indeed contain random data except for the "NULL indicator" bit. I read something about passing None is not supported in cx_Oracle, is it true and is there a workaround? I think the second observation could be due to the buffer is not flushed from a previous usage and still being used in the subsequent call. Is there anyway we can get rid of both observation? Must we remove any bind variables that we know carrying None as value in the SQL statement? This looks like some extensive change if our application needs to verify the value first before it being used in the SQL. The None value *is* supported. There used to be an issue when cursor.executemany() determines the type of a variable, when the first value for this variable is a None and following values are numbers. But this caused an explicit conversion error, and it has been fixed some releases ago anyway. Could you show us a test script that reproduces your problem? -- Amaury Forgeot d'Arc |
|
From: Kuassi M. <kua...@gm...> - 2011-12-08 12:58:27
|
On Wed, Dec 7, 2011 at 6:08 PM, < cx-...@li...> wrote: > 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. SessionPool and DRCP (Arshavir Grigorian) > 2. Passing None as values of bind variables in cx_Oracle's > cursor.execute() command (Wong Wah Meng-R32813) > 3. Re: Passing None as values of bind variables in cx_Oracle's > cursor.execute() command (Amaury Forgeot d'Arc) > 4. Re: Passing None as values of bind variables in cx_Oracle's > cursor.execute() command (Wong Wah Meng-R32813) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 6 Dec 2011 19:53:43 -0800 > From: Arshavir Grigorian <gri...@gm...> > Subject: [cx-oracle-users] SessionPool and DRCP > To: cx-...@li... > Message-ID: > <CACdn6enT8--t2SPwbqMJTtHJRriYC-0bD2SZugk+E=vOf...@ma... > > > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, can someone please explain the relationship between SessionPool > and DRCP? Do they work together or is DRCP supposed to replace > SessionPool? Thanks. > > > As indicated in the OCI doc, http://docs.oracle.com/cd/E11882_01/appdev.112/e10646.pdf Session pooling can be instructed to allocate sessions from DRCP. Kuassi Mensah http://db360.blogspot.com > ------------------------------ > > Message: 2 > Date: Wed, 7 Dec 2011 10:15:27 +0000 > From: Wong Wah Meng-R32813 <r3...@fr...> > Subject: [cx-oracle-users] Passing None as values of bind variables in > cx_Oracle's cursor.execute() command > To: "cx-...@li..." > <cx-...@li...> > Message-ID: > < > 02E...@03...> > > Content-Type: text/plain; charset="us-ascii" > > Hello there, > > I am converting my application from python 1.5.2 and oracledb to python > 2.7.1 and cx_Oracle.. > > I noticed one issue here whenever the bind variable's value is None, it > exhibits some strange behavior. > > First observation: When it is the first time I pass in a bind variable as > None, it gives an EOL file. However, subsequent passing of None value to > the same SQL seems to be working fine. > > Second observation: When there is more than one bind variables contain > None value, the value that actually got received at Oracle level seems to > be messed up. (We turn on the highest debug level at Oracle level in order > to see the bind variable value that are received). Those defined as None > are received as some arbitrary value, some are the values from one or a few > of the total bind variables. > > I read something about passing None is not supported in cx_Oracle, is it > true and is there a workaround? I think the second observation could be due > to the buffer is not flushed from a previous usage and still being used in > the subsequent call. > > Is there anyway we can get rid of both observation? Must we remove any > bind variables that we know carrying None as value in the SQL statement? > This looks like some extensive change if our application needs to verify > the value first before it being used in the SQL. > > > > Regards, > Wah Meng > Goto http://cimhelp.freescale.net to create a Genesis Wafermap Ticket. > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 3 > Date: Wed, 7 Dec 2011 11:27:36 +0100 > From: "Amaury Forgeot d'Arc" <ama...@gm...> > Subject: Re: [cx-oracle-users] Passing None as values of bind > variables in cx_Oracle's cursor.execute() command > To: cx-...@li... > Message-ID: > <CAGmFidbhf7WazwtfKq9g26Yx2xk7HAmhG2zvry=VXX...@ma... > > > Content-Type: text/plain; charset="windows-1252" > > Hi, > > 2011/12/7 Wong Wah Meng-R32813 <r3...@fr...> > > > Hello there,**** > > > > ** ** > > > > I am converting my application from python 1.5.2 and oracledb to python > > 2.7.1 and cx_Oracle.. **** > > > > ** ** > > > > I noticed one issue here whenever the bind variable?s value is None, it > > exhibits some strange behavior.**** > > > > ** ** > > > > First observation: When it is the first time I pass in a bind variable as > > None, it gives an EOL file. However, subsequent passing of None value to > > the same SQL seems to be working fine. > > > > This is surprising. But what do you mean by "EOL file"? > > > > Second observation: When there is more than one bind variables contain > > None value, the value that actually got received at Oracle level seems to > > be messed up. (We turn on the highest debug level at Oracle level in > order > > to see the bind variable value that are received). Those defined as None > > are received as some arbitrary value, some are the values from one or a > few > > of the total bind variables. > > > > When None is passed, cx_Oracle sets the "NULL indicator" of the bind > variable. But this changes only one bit of the memory, so if you look at > the raw memory, it will indeed contain random data except for the "NULL > indicator" bit. > > > > I read something about passing None is not supported in cx_Oracle, is it > > true and is there a workaround? I think the second observation could be > due > > to the buffer is not flushed from a previous usage and still being used > in > > the subsequent call. **** > > > > ** ** > > > > Is there anyway we can get rid of both observation? Must we remove any > > bind variables that we know carrying None as value in the SQL statement? > > This looks like some extensive change if our application needs to verify > > the value first before it being used in the SQL. > > > > The None value *is* supported. There used to be an issue when > cursor.executemany() determines the type of a variable, when the first > value for this variable is a None and following values are numbers. > But this caused an explicit conversion error, and it has been fixed some > releases ago anyway. > > Could you show us a test script that reproduces your problem? > > -- > Amaury Forgeot d'Arc > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 4 > Date: Thu, 8 Dec 2011 02:08:00 +0000 > From: Wong Wah Meng-R32813 <r3...@fr...> > Subject: Re: [cx-oracle-users] Passing None as values of bind > variables in cx_Oracle's cursor.execute() command > To: "cx-...@li..." > <cx-...@li...> > Message-ID: > < > 78E...@03...> > > Content-Type: text/plain; charset="us-ascii" > > Thanks for your reply. Based on your None as bind variable's value *is* > supported, I would like to redo my testing to reaffirm the case before > updating you my test script. Maybe something was introduced in my > inputtypehandler of the cursor object. I will revert with my findings later. > > From: Amaury Forgeot d'Arc [mailto:ama...@gm...] > Sent: Wednesday, December 07, 2011 6:28 PM > To: cx-...@li... > Subject: Re: [cx-oracle-users] Passing None as values of bind variables in > cx_Oracle's cursor.execute() command > > Hi, > 2011/12/7 Wong Wah Meng-R32813 <r3...@fr...<mailto: > r3...@fr...>> > Hello there, > > I am converting my application from python 1.5.2 and oracledb to python > 2.7.1 and cx_Oracle.. > > I noticed one issue here whenever the bind variable's value is None, it > exhibits some strange behavior. > > First observation: When it is the first time I pass in a bind variable as > None, it gives an EOL file. However, subsequent passing of None value to > the same SQL seems to be working fine. > > This is surprising. But what do you mean by "EOL file"? > > Second observation: When there is more than one bind variables contain > None value, the value that actually got received at Oracle level seems to > be messed up. (We turn on the highest debug level at Oracle level in order > to see the bind variable value that are received). Those defined as None > are received as some arbitrary value, some are the values from one or a few > of the total bind variables. > > When None is passed, cx_Oracle sets the "NULL indicator" of the bind > variable. But this changes only one bit of the memory, so if you look at > the raw memory, it will indeed contain random data except for the "NULL > indicator" bit. > > I read something about passing None is not supported in cx_Oracle, is it > true and is there a workaround? I think the second observation could be due > to the buffer is not flushed from a previous usage and still being used in > the subsequent call. > > Is there anyway we can get rid of both observation? Must we remove any > bind variables that we know carrying None as value in the SQL statement? > This looks like some extensive change if our application needs to verify > the value first before it being used in the SQL. > > The None value *is* supported. There used to be an issue when > cursor.executemany() determines the type of a variable, when the first > value for this variable is a None and following values are numbers. > But this caused an explicit conversion error, and it has been fixed some > releases ago anyway. > > Could you show us a test script that reproduces your problem? > > -- > Amaury Forgeot d'Arc > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > > ------------------------------------------------------------------------------ > Cloud Services Checklist: Pricing and Packaging Optimization > This white paper is intended to serve as a reference, checklist and point > of > discussion for anyone considering optimizing the pricing and packaging > model > of a cloud services business. Read Now! > http://www.accelacomm.com/jaw/sfnl/114/51491232/ > > ------------------------------ > > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > End of cx-oracle-users Digest, Vol 66, Issue 4 > ********************************************** > -- Kuassi - book http://www.amazon.com/exec/obidos/ASIN/1555583296 |
|
From: Wong W. Meng-R. <r3...@fr...> - 2011-12-08 02:08:11
|
Thanks for your reply. Based on your None as bind variable's value *is* supported, I would like to redo my testing to reaffirm the case before updating you my test script. Maybe something was introduced in my inputtypehandler of the cursor object. I will revert with my findings later. From: Amaury Forgeot d'Arc [mailto:ama...@gm...] Sent: Wednesday, December 07, 2011 6:28 PM To: cx-...@li... Subject: Re: [cx-oracle-users] Passing None as values of bind variables in cx_Oracle's cursor.execute() command Hi, 2011/12/7 Wong Wah Meng-R32813 <r3...@fr...<mailto:r3...@fr...>> Hello there, I am converting my application from python 1.5.2 and oracledb to python 2.7.1 and cx_Oracle.. I noticed one issue here whenever the bind variable's value is None, it exhibits some strange behavior. First observation: When it is the first time I pass in a bind variable as None, it gives an EOL file. However, subsequent passing of None value to the same SQL seems to be working fine. This is surprising. But what do you mean by "EOL file"? Second observation: When there is more than one bind variables contain None value, the value that actually got received at Oracle level seems to be messed up. (We turn on the highest debug level at Oracle level in order to see the bind variable value that are received). Those defined as None are received as some arbitrary value, some are the values from one or a few of the total bind variables. When None is passed, cx_Oracle sets the "NULL indicator" of the bind variable. But this changes only one bit of the memory, so if you look at the raw memory, it will indeed contain random data except for the "NULL indicator" bit. I read something about passing None is not supported in cx_Oracle, is it true and is there a workaround? I think the second observation could be due to the buffer is not flushed from a previous usage and still being used in the subsequent call. Is there anyway we can get rid of both observation? Must we remove any bind variables that we know carrying None as value in the SQL statement? This looks like some extensive change if our application needs to verify the value first before it being used in the SQL. The None value *is* supported. There used to be an issue when cursor.executemany() determines the type of a variable, when the first value for this variable is a None and following values are numbers. But this caused an explicit conversion error, and it has been fixed some releases ago anyway. Could you show us a test script that reproduces your problem? -- Amaury Forgeot d'Arc |
|
From: Amaury F. d'A. <ama...@gm...> - 2011-12-07 10:27:45
|
Hi, 2011/12/7 Wong Wah Meng-R32813 <r3...@fr...> > Hello there,**** > > ** ** > > I am converting my application from python 1.5.2 and oracledb to python > 2.7.1 and cx_Oracle.. **** > > ** ** > > I noticed one issue here whenever the bind variable’s value is None, it > exhibits some strange behavior.**** > > ** ** > > First observation: When it is the first time I pass in a bind variable as > None, it gives an EOL file. However, subsequent passing of None value to > the same SQL seems to be working fine. > This is surprising. But what do you mean by "EOL file"? > Second observation: When there is more than one bind variables contain > None value, the value that actually got received at Oracle level seems to > be messed up. (We turn on the highest debug level at Oracle level in order > to see the bind variable value that are received). Those defined as None > are received as some arbitrary value, some are the values from one or a few > of the total bind variables. > When None is passed, cx_Oracle sets the "NULL indicator" of the bind variable. But this changes only one bit of the memory, so if you look at the raw memory, it will indeed contain random data except for the "NULL indicator" bit. > I read something about passing None is not supported in cx_Oracle, is it > true and is there a workaround? I think the second observation could be due > to the buffer is not flushed from a previous usage and still being used in > the subsequent call. **** > > ** ** > > Is there anyway we can get rid of both observation? Must we remove any > bind variables that we know carrying None as value in the SQL statement? > This looks like some extensive change if our application needs to verify > the value first before it being used in the SQL. > The None value *is* supported. There used to be an issue when cursor.executemany() determines the type of a variable, when the first value for this variable is a None and following values are numbers. But this caused an explicit conversion error, and it has been fixed some releases ago anyway. Could you show us a test script that reproduces your problem? -- Amaury Forgeot d'Arc |
|
From: Wong W. Meng-R. <r3...@fr...> - 2011-12-07 10:15:39
|
Hello there, I am converting my application from python 1.5.2 and oracledb to python 2.7.1 and cx_Oracle.. I noticed one issue here whenever the bind variable's value is None, it exhibits some strange behavior. First observation: When it is the first time I pass in a bind variable as None, it gives an EOL file. However, subsequent passing of None value to the same SQL seems to be working fine. Second observation: When there is more than one bind variables contain None value, the value that actually got received at Oracle level seems to be messed up. (We turn on the highest debug level at Oracle level in order to see the bind variable value that are received). Those defined as None are received as some arbitrary value, some are the values from one or a few of the total bind variables. I read something about passing None is not supported in cx_Oracle, is it true and is there a workaround? I think the second observation could be due to the buffer is not flushed from a previous usage and still being used in the subsequent call. Is there anyway we can get rid of both observation? Must we remove any bind variables that we know carrying None as value in the SQL statement? This looks like some extensive change if our application needs to verify the value first before it being used in the SQL. Regards, Wah Meng Goto http://cimhelp.freescale.net to create a Genesis Wafermap Ticket. |
|
From: Arshavir G. <gri...@gm...> - 2011-12-07 03:53:50
|
Hi, can someone please explain the relationship between SessionPool and DRCP? Do they work together or is DRCP supposed to replace SessionPool? Thanks. |
|
From: Brian W. <bw...@ma...> - 2011-12-06 20:52:49
|
Hello everyone, I'm referencing bug 3442096: https://sourceforge.net/tracker/index.php?func=detail&aid=3442096&group_id=84168&atid=571972 We just updated a webapp from SQLAlchemy 0.4 to 0.7.3. Once we went live, the server slowed to a crawl. We put them back on their old server while we diagnosed. I hadn't noticed before, but the new orm emits unicode parameters. The unicode version is much slower: 2011-12-06 14:12:24,439 INFO sqlalchemy.engine.base.Engine SELECT [......CUT......] FROM demp_inventory WHERE demp_inventory.inventory_snsn = :inventory_snsn_1 AND demp_inventory.inventory_slocation = :inventory_slocation_1 AND demp_inventory.inventory_sentityid = :inventory_sentityid_1 AND demp_inventory.inventory_scc = :inventory_scc_1 AND (demp_inventory.inventory_sshelflifeid IS NULL OR demp_inventory.inventory_sshelflifeid = :inventory_sshelflifeid_1) AND (demp_inventory.inventory_sserialno IS NULL OR demp_inventory.inventory_sserialno = :inventory_sserialno_1)) WHERE ROWNUM <= :ROWNUM_1 2011-12-06 14:12:24,439 INFO sqlalchemy.engine.base.Engine {'inventory_snsn_1': u'0000LLCQA7546', 'inventory_slocation_1': u'JNK1234114', 'inventory_sserialno_1': '', 'ROWNUM_1': 1, 'inventory_sentityid_1': u'bae9b856-d874-11df-89f4-0022191e6cbe', 'inventory_sshelflifeid_1': '', 'inventory_scc_1': u'A'} 0.419656 seconds to execute 2011-12-06 13:59:15,882 INFO sqlalchemy.engine.base.Engine SELECT [......CUT......] FROM demp_inventory WHERE demp_inventory.inventory_snsn = :inventory_snsn_1 AND demp_inventory.inventory_slocation = :inventory_slocation_1 AND demp_inventory.inventory_sentityid = :inventory_sentityid_1 AND demp_inventory.inventory_scc = :inventory_scc_1 AND (demp_inventory.inventory_sshelflifeid IS NULL OR demp_inventory.inventory_sshelflifeid = :inventory_sshelflifeid_1) AND (demp_inventory.inventory_sserialno IS NULL OR demp_inventory.inventory_sserialno = :inventory_sserialno_1)) WHERE ROWNUM <= :ROWNUM_1 2011-12-06 13:59:15,882 INFO sqlalchemy.engine.base.Engine {'inventory_snsn_1': '0000LLCQA7546', 'inventory_slocation_1': 'JNK1234114', 'inventory_sserialno_1': '', 'ROWNUM_1': 1, 'inventory_sentityid_1': 'bae9b856-d874-11df-89f4-0022191e6cbe', 'inventory_sshelflifeid_1': '', 'inventory_scc_1': 'A'} 0.014337 seconds to execute I've tested on cx_Oracle 5.0.3, 5.0.4, and 5.1.1 with identical results. I've learned my lesson on deployment, and I'll never do another rollout without performance testing first. I've tried various fixes so far with no luck. I've downloaded the source to try and diagnose my own problem, but thats easier said than done. I'm trying to get sqla to nix unicode params. If anyone has any suggestions or things to try, PLEASE let me know. We use cx in production and would buy support or donate to solve our issue. Many thanks, Brian Watson |
|
From: Darin W. <wil...@ya...> - 2011-12-05 21:54:50
|
Hi- I'm fairly new to Python and Linux and could use some clarification on what version of cx_Oracle I need to support Oracle 11gR2 XE. As I've found, 11g XE only supports unicode. I had issues with the installation of cx_Oracle 5.1.1 (ImportError: /usr/lib/python2.7/dist-packages/cx_Oracle.so: undefined symbol: PyUnicodeUCS2_AsEncodedString). However, I was able to successfully install xc_Oracle 5.0.4 Unicode. Does this mean that I can only use cx_Oracle 5.0.4 Unicode? I tried building from the source files of 5.1.1 and still wasn't able to resolve the unicode issue. My environment: Ubuntu Oracle 11gR2 XE Oracle InstantClient Python 2.7 Thanks!! Darin |
|
From: Wong W. Meng-R. <r3...@fr...> - 2011-12-04 12:03:14
|
Hello there,
I am revisiting the build of cx_Oracle, as my colleague pointed out that my ORACLE_HOME setting was pointing to R1 folder when I did the previous build. So this time I changed its value to R2 folder. Here is the dependency of cx_Oracle.so that I build (HP Itanium 64-bit).
I looked at setup.py file, I noticed the version it expects on 11g is R1. Is it safe now that I build my cx_Oracle on a R2 ORACLE_HOME directory?
Regards,
Wah Meng
$ ldd cx_Oracle.so
cx_Oracle.so:
libxnet.so.1 => /usr/lib/hpux64/libxnet.so.1
libclntsh.so.11.1 => /opt/oracle/product/11.2.0/lib/libclntsh.so.11.1
libttsh11.so => /opt/oracle/product/11.2.0/lib/libttsh11.so
libpython2.7.so => /home/r32813/genesis/GEN_DEV_271/Product/Lib/libpython2.7.so
libxti.so.1 => /usr/lib/hpux64/libxti.so.1
libnnz11.so => /opt/oracle/product/11.2.0/lib/libnnz11.so
librt.so.1 => /usr/lib/hpux64/librt.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1
libm.so.1 => /usr/lib/hpux64/libm.so.1
libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1
libnsl.so.1 => /usr/lib/hpux64/libnsl.so.1
libunwind.so.1 => /usr/lib/hpux64/libunwind.so.1
libdiskown.so => /usr/lib/hpux64/libdiskown.so
libc.so.1 => /usr/lib/hpux64/libc.so.1
libnsl.so.1 => /usr/lib/hpux64/libnsl.so.1
librt.so.1 => /usr/lib/hpux64/librt.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1
libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1
libm.so.1 => /usr/lib/hpux64/libm.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1
libc.so.1 => /usr/lib/hpux64/libc.so.1
libxti.so.1 => /usr/lib/hpux64/libxti.so.1
libuca.so.1 => /usr/lib/hpux64/libuca.so.1
Regards,
Wah Meng
|
|
From: Christopher J. <chr...@or...> - 2011-12-02 19:39:47
|
On 12/01/2011 02:43 AM, Wong Wah Meng-R32813 wrote: > It looks like we have no other way except to change our SQL not to use statements like "in (:1)"? Correct, as others have said. The bind variable is only ever treated as a single piece of anonymous data by the Oracle DB. Tom Kyte has some discussions on "Varying IN Lists" in an old article http://www.oracle.com/technetwork/issue-archive/2007/07-mar/o27asktom-084983.html I cover the same topic a bit from from the binding perspective in PHP on page p146 of http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html -- Email: chr...@or... Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ |
|
From: Amaury F. d'A. <ama...@gm...> - 2011-12-01 12:19:12
|
2011/12/1 Wong Wah Meng-R32813 <r3...@fr...> > It looks like we have no other way except to change our SQL not to use > statements like "in (:1)"? Exactly. Oracle (the SQL server, not cx_Oracle) does not allow list of values in bind variables. Use something like: "... where x in (%s) ..." % ', '.join(list_of_values) If it worked with oracledb, it's probably because oracledb does not really use bind variables, but internally format the query with %s or something similar. cx_Oracle really passes the sql string to the Oracle server unmodified, so you are subject to the limitations of the Oracle server. -- Amaury Forgeot d'Arc |
|
From: Wong W. Meng-R. <r3...@fr...> - 2011-12-01 10:58:35
|
Hello Anthony,
I tried to simulate and I think the result is what you meant. If the simulation is working, I can override inputtypehandler to convert a list to string. However the result shows that it is not working. The string output that is passed to Oracle doesn't seem to be recognized, though ORA-01484 is not thrown. It looks like we have no other way except to change our SQL not to use statements like "in (:1)"? This seems like an extensive change. Any other option I can take?
>>> cmd
'select user_id, user_first_name from users where user_id in (:1)'
>>> arg=('ftcs',)
>>> a.execute(cmd, arg)
[('ftcs', 'YYYY')]
>>> arg=("'ftcs'", )
>>> a.execute(cmd, arg)
[]
>>> arg=("'ftcs','R32813'",)
>>> a.execute(cmd, arg)
[]
>>>
Regards,
Wah Meng
-----Original Message-----
From: Wong Wah Meng-R32813
Sent: Thursday, December 01, 2011 1:00 PM
To: 'cx-...@li...'
Subject: RE: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be bound to PL/SQL statements
Hi Anthony,
Thanks, and agreed with you on simply converting lists to string in arbitrary fashion is not the best way to handle this. I will feedback this to the application development team. Thanks a lot!
Regards,
Wah Meng
-----Original Message-----
From: Anthony Tuininga [mailto:ant...@gm...]
Sent: Thursday, December 01, 2011 12:29 PM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be bound to PL/SQL statements
Oracle does not allow passing arrays to SQL statements, only PL/SQL
statements and this has been that way since as long as I have known
Oracle. The driver you were using before may have simply converted the
result to a string. cx_Oracle takes lists and converts them to PL/SQL
arrays -- which are not possible to be used in straight SQL
statements. So you will have to modify how you are using the driver.
In my opinion, converting lists to strings in some arbitrary fashion
is not the best way to handle such things!
Anthony
On Wed, Nov 30, 2011 at 7:07 PM, Wong Wah Meng-R32813
<r3...@fr...> wrote:
> Yes worst case is we will have to modify this SQL statement.
>
>
>
> However, is it a long standing issue with Oracle or cx_Oracle? This is an
> old code and the passing of parameters in such way has been working fine on
> oracledb. So is this something the cx_Oracle does not support? IF it is
> oracle issue I wonder whey it did not give the error when we use oracledb.
>
>
>
> Regards,
>
> Wah Meng
>
> ________________________________
>
> From: Amaury Forgeot d'Arc [mailto:ama...@gm...]
> Sent: Wednesday, November 30, 2011 9:06 PM
>
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be
> bound to PL/SQL statements
>
>
>
> 2011/11/30 Wong Wah Meng-R32813 <r3...@fr...>
>
>>> cmd = "select ........ from FUTURE_HOLD_CONDITIONS where STEP_NAME not in
>>> (:1) and LOT_ID = :2 and ......."
>
> This cannot work with Oracle. A placeholder can only replace one value.
>
> (Think of the IN operator as a sequence of OR conditions)
>
> Yes, this is a long standing issue with Oracle.
>
> I suggest to try with %s formatting.
>
>
>
> --
> Amaury Forgeot d'Arc
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
|
|
From: Wong W. Meng-R. <r3...@fr...> - 2011-12-01 05:13:43
|
Hi Anthony, Thanks, and agreed with you on simply converting lists to string in arbitrary fashion is not the best way to handle this. I will feedback this to the application development team. Thanks a lot! Regards, Wah Meng -----Original Message----- From: Anthony Tuininga [mailto:ant...@gm...] Sent: Thursday, December 01, 2011 12:29 PM To: cx-...@li... Subject: Re: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be bound to PL/SQL statements Oracle does not allow passing arrays to SQL statements, only PL/SQL statements and this has been that way since as long as I have known Oracle. The driver you were using before may have simply converted the result to a string. cx_Oracle takes lists and converts them to PL/SQL arrays -- which are not possible to be used in straight SQL statements. So you will have to modify how you are using the driver. In my opinion, converting lists to strings in some arbitrary fashion is not the best way to handle such things! Anthony On Wed, Nov 30, 2011 at 7:07 PM, Wong Wah Meng-R32813 <r3...@fr...> wrote: > Yes worst case is we will have to modify this SQL statement. > > > > However, is it a long standing issue with Oracle or cx_Oracle? This is an > old code and the passing of parameters in such way has been working fine on > oracledb. So is this something the cx_Oracle does not support? IF it is > oracle issue I wonder whey it did not give the error when we use oracledb. > > > > Regards, > > Wah Meng > > ________________________________ > > From: Amaury Forgeot d'Arc [mailto:ama...@gm...] > Sent: Wednesday, November 30, 2011 9:06 PM > > To: cx-...@li... > Subject: Re: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be > bound to PL/SQL statements > > > > 2011/11/30 Wong Wah Meng-R32813 <r3...@fr...> > >>> cmd = "select ........ from FUTURE_HOLD_CONDITIONS where STEP_NAME not in >>> (:1) and LOT_ID = :2 and ......." > > This cannot work with Oracle. A placeholder can only replace one value. > > (Think of the IN operator as a sequence of OR conditions) > > Yes, this is a long standing issue with Oracle. > > I suggest to try with %s formatting. > > > > -- > Amaury Forgeot d'Arc > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure > contains a definitive record of customers, application performance, > security threats, fraudulent activity, and more. Splunk takes this > data and makes sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-novd2d > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ cx-oracle-users mailing list cx-...@li... https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
|
From: Anthony T. <ant...@gm...> - 2011-12-01 04:28:57
|
Oracle does not allow passing arrays to SQL statements, only PL/SQL statements and this has been that way since as long as I have known Oracle. The driver you were using before may have simply converted the result to a string. cx_Oracle takes lists and converts them to PL/SQL arrays -- which are not possible to be used in straight SQL statements. So you will have to modify how you are using the driver. In my opinion, converting lists to strings in some arbitrary fashion is not the best way to handle such things! Anthony On Wed, Nov 30, 2011 at 7:07 PM, Wong Wah Meng-R32813 <r3...@fr...> wrote: > Yes worst case is we will have to modify this SQL statement. > > > > However, is it a long standing issue with Oracle or cx_Oracle? This is an > old code and the passing of parameters in such way has been working fine on > oracledb. So is this something the cx_Oracle does not support? IF it is > oracle issue I wonder whey it did not give the error when we use oracledb. > > > > Regards, > > Wah Meng > > ________________________________ > > From: Amaury Forgeot d'Arc [mailto:ama...@gm...] > Sent: Wednesday, November 30, 2011 9:06 PM > > To: cx-...@li... > Subject: Re: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be > bound to PL/SQL statements > > > > 2011/11/30 Wong Wah Meng-R32813 <r3...@fr...> > >>> cmd = “select …….. from FUTURE_HOLD_CONDITIONS where STEP_NAME not in >>> (:1) and LOT_ID = :2 and …….” > > This cannot work with Oracle. A placeholder can only replace one value. > > (Think of the IN operator as a sequence of OR conditions) > > Yes, this is a long standing issue with Oracle. > > I suggest to try with %s formatting. > > > > -- > Amaury Forgeot d'Arc > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure > contains a definitive record of customers, application performance, > security threats, fraudulent activity, and more. Splunk takes this > data and makes sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-novd2d > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
31 messages has been excluded from this view by a project administrator.
