cx-oracle-users Mailing List for cx_Oracle (Page 135)
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: Anthony T. <ant...@gm...> - 2005-06-16 18:48:08
|
On 6/16/05, Bernard Delm=E9e <bd...@ad...> wrote: > > Apologies for the delay in responding. I just got back from holidays. >=20 > Hi Anthony, no need to apologise; I hope you had nice, relaxing holidays! Yes, I did. Thanks. > I'm not convinced anymore building statically would help at all, > as I've since discovered (see my main HP-UX thread) that the > problems all seem related to one Oracle library (libnnz10) > not being able to resolve some symbols. >=20 > Anyone with an idea or HP-UX expertise, please chime in! > What is frustrating is that my choice of python for writing > this system that has worked well for the last 18 months, > might be questioned in retrospect. How I wish they had > chosen linux or Solaris instead of Hocus Pocus! Don't get me started on HP-UX. Of the Unix OSes that I have used (HP-UX, Solaris, Tru64, Linux) HP has been the absolute worst. Linking problems are frequent and unfortunately HP-UX has its own special way of doing everything -- until recently even reading an ISO 9660 filesystem on a CD required a kernel patch! Ugh! Good luck. You'll need it. :-) > Bernard. >=20 >=20 >=20 > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies > from IBM. Find simple to follow Roadmaps, straightforward articles, > informative Webcasts and more! Get everything you need to get up to > speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclic= k > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: <bd...@ad...> - 2005-06-16 18:39:46
|
> Apologies for the delay in responding. I just got back from holidays. Hi Anthony, no need to apologise; I hope you had nice, relaxing holidays! I'm not convinced anymore building statically would help at all, as I've since discovered (see my main HP-UX thread) that the problems all seem related to one Oracle library (libnnz10) not being able to resolve some symbols. Anyone with an idea or HP-UX expertise, please chime in! What is frustrating is that my choice of python for writing this system that has worked well for the last 18 months, might be questioned in retrospect. How I wish they had chosen linux or Solaris instead of Hocus Pocus! Bernard. |
|
From: Anthony T. <ant...@gm...> - 2005-06-15 16:56:41
|
Apologies for the delay in responding. I just got back from holidays. From your question I am assuming that you want to build a special Python interpreter that has cx_Oracle built into it? Yes, that is possible but I only know about it from reading about it, not from actual experience. On 6/1/05, Bernard Delm=E9e <bd...@ad...> wrote: > Hello list, >=20 > I still haven't succeeded in getting cx_oracle to > work on Itanium HP-UX. I thought perhaps it could be > build statically and directly linked to the python > interpreter? Is this possible or supported, and how > would one go about it ? >=20 > Thanks, >=20 > Bernard. >=20 >=20 > ------------------------------------------------------- > This SF.Net email is sponsored by Yahoo. > Introducing Yahoo! Search Developer Network - Create apps using Yahoo! > Search APIs Find out how you can build Yahoo! directly into your own > Applications - visit http://developer.yahoo.net/?fr=3Doffad-ysdn-ostg-q22= 005 > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: <bd...@ad...> - 2005-06-08 20:59:46
|
Hello, I am embarrassed to admit I had not thought of that earlier, but when I start python with its '-v' flag, I am seeing (lots of) messages that seem to show that the oracle libs I am linking against need some code (probably HP-UX shared libraries) that cannot be resolved. AFAICT, cx_oracle pulls the correct libraries under $ORACLE_HOME, but these in turn meet unresolved symbols... Not sure if it is oracle or system related. Any suggestion, please? Bernard. >>>>>> /usr/lib/hpux64/dld.so: Unsatisfied data symbol 'nltrc_entry' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied data symbol 'nltrc_exit' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied data symbol 'nzdacvalue' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_ANSIPRNG_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_SSLV3_SERVERSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_SSLV3_V2_SERVERSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_TLSV1_SSLV3_V2_SERVERSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_SSLV3_CLIENTSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_SSLV3_V2_CLIENTSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_TLSV1_SSLV3_V2_CLIENTSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_TLSV1_CLIENTSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_SSLV2_CLIENTSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_TLSV1_SSLV3_CLIENTSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_TLSV1_SERVERSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_SSLV2_SERVERSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_PROTOCOL_TLSV1_SSLV3_SERVERSIDE' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ENC_DER' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_PRV_KEY_DECRYPT_NULL' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_CERT_FMT_X509' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_WITH_RC4_128_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_WITH_RC4_128_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_RC4_128_MD5_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_RC4_128_MD5_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_RC4_128_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_RC4_128_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_3DES_EDE_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_3DES_EDE_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_EXPORT_WITH_RC4_40_MD5_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_EXPORT_WITH_RC4_40_MD5_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_EXPORT_WITH_DES40_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_EXPORT_WITH_DES40_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_DES_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_DES_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DH_ANON_WITH_RC4_128_MD5_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DH_ANON_WITH_RC4_128_MD5_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DH_ANON_WITH_DES_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DH_ANON_WITH_DES_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DH_ANON_WITH_3DES_EDE_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DH_ANON_WITH_3DES_EDE_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_EXPORT_WITH_DES40_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_EXPORT_WITH_DES40_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_WITH_DES_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_WITH_DES_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_WITH_3DES_EDE_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_WITH_3DES_EDE_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_RSA_EXPORT_WITH_DES40_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_RSA_EXPORT_WITH_DES40_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_RSA_WITH_DES_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_RSA_WITH_DES_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_RSA_WITH_3DES_EDE_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_RSA_WITH_3DES_EDE_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_EXPORT1024_WITH_DES_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_EXPORT1024_WITH_DES_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_EXPORT1024_WITH_RC4_56_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_DHE_DSS_EXPORT1024_WITH_RC4_56_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_AES_128_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_AES_128_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_AES_256_CBC_SHA_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CIPHER_RSA_WITH_AES_256_CBC_SHA_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CLIENT_AUTH_MODE_RSA_SIGN_SERVERSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'SSL_ALG_CLIENT_AUTH_MODE_RSA_SIGN_CLIENTSIDE_BS' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetPRNG' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_GetPrivateKeyRef' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldxstd' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldxsti' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_CreateConnectionContext' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_get_values_len' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_GetNegotiatedCipher' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_DestroyConnectionContext' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'lpmexitprog' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'lxsCmpStr' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_unbind_s' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_ExtractRawCertData' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlemgmz' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetDecryptFunc' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_GetNegotiatedProtocolVersion' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_AddCertificate' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_first_entry' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltspcbroadcast' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltspcsignal' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_DestroyCertList' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_Read' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'lstprintf' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlfncons' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetPrivateKeyRef' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_free_urldesc' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetValidateRef' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_url_parse' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetProtocol' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlfidst' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlfiini' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltskydestroy' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_CreateGlobalContext' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltspcdestroy' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_GetReadPendingSize' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_search' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snlfrd' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetIOFuncs' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_set_option' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_memfree' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_count_entries' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'slzgetevar' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltspcwait' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlemfireg' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetPeerID' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_init' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_next_attribute' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_DestroyGlobalContext' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetCheckCertificateChainFunc' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlnvdeb' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlnvcrb' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlnvfbp' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlnvgap' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ber_free' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nltrcwrite' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetServerDHParams' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_RequestRenegotiation' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_result' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_get_option' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_open' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'slgtd' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_unbind' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetCipherSuites' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltln' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_AddTrustedCerts' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_next_entry' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_Close' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltspcinit' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_get_lderrno' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlpagbp' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlpagip' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlpagsp' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_AddIdentity' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snlpcgun' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_value_free_len' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlstdgg' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'lstclo' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlepeget' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetVerifyFunc' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlstdstp' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetEncryptFunc' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sldxgd' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snlfacc' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snlfchd' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'nlfiwr' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snlfohd' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snlfprt' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snlfsek' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snlftel' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_bind_s' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snlfwrt' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetClientAuthModes' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetSessionRef' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_Write' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'snldlgln' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'lstmclo' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_msgfree' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_url_search_s' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetSessionFuncs' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetSignFunc' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_first_attribute' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'lstup' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltsini' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltskyc' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltskyg' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltskys' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltsmnr' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltsmna' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltsmxd' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltsmxi' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltspin' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'sltster' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldap_is_ldap_url' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_CreateCertList' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_SetValidateFunc' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_ServiceWriteQueue' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_Handshake' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldxcmp' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ssl_DecodeRecord' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldxdtd' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldxdts' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. /usr/lib/hpux64/dld.so: Unsatisfied code symbol 'ldxini' in load module '/app/oracle/product/10.1.0.2/lib/libnnz10.so'. |
|
From: Caleb G. <ca...@NA...> - 2005-06-03 15:54:42
|
*sigh* Please disregard. Works like a champ. The failure was in another area. Thanks for your reply. |
|
From: Caleb G. <ca...@NA...> - 2005-06-03 14:30:09
|
ama...@ub... wrote:
> It seems to work without any problem.
> I tried this:
>
> >>> from cx_Oracle import *
> >>> cnx = connect(user,password)
> >>> cur = cnx.cursor()
> >>> cur.execute("ALTER TABLE myTable ADD newCol NUMBER")
> (ok)
> >>> cur.execute("ALTER TABLE myTable ADD newCol NUMBER")
> Traceback (most recent call last):
> File "<stdin>", line 1, in ?
> cx_Oracle.DatabaseError: ORA-01430: column being added already exists in
> table
>
> So I guess that the first ALTER TABLE did its job...
> If something goes wrong, you get an exception!
>
> What kind of ALTER did you try?
Thanks for your example. I'm doing the same thing, except my query is:
alter table mytable truncate partition Y2005_D150_S4
|
|
From: <ama...@ub...> - 2005-06-03 07:05:56
|
Caleb Groom wrote:
> Should cx-oracle be able to handle sending 'alter table' statements to
> Oracle?
>
> I'm replacing a SQL*Plus session that is truncating table partitions and
> it seems to have no effect. I'm using the same username and password as
> the SQL*Plus session. No exceptions are raised, no errors.
It seems to work without any problem.
I tried this:
>>> from cx_Oracle import *
>>> cnx = connect(user,password)
>>> cur = cnx.cursor()
>>> cur.execute("ALTER TABLE myTable ADD newCol NUMBER")
(ok)
>>> cur.execute("ALTER TABLE myTable ADD newCol NUMBER")
Traceback (most recent call last):
File "<stdin>", line 1, in ?
cx_Oracle.DatabaseError: ORA-01430: column being added already exists in
table
So I guess that the first ALTER TABLE did its job...
If something goes wrong, you get an exception!
What kind of ALTER did you try?
--
Amaury Forgeot d'Arc
Ubix Development
www.ubitrade.com
|
|
From: Caleb G. <ca...@NA...> - 2005-06-02 18:36:02
|
Should cx-oracle be able to handle sending 'alter table' statements to Oracle? I'm replacing a SQL*Plus session that is truncating table partitions and it seems to have no effect. I'm using the same username and password as the SQL*Plus session. No exceptions are raised, no errors. |
|
From: <bd...@ad...> - 2005-06-01 20:41:35
|
Hello list, I still haven't succeeded in getting cx_oracle to work on Itanium HP-UX. I thought perhaps it could be build statically and directly linked to the python interpreter? Is this possible or supported, and how would one go about it ? Thanks, Bernard. |
|
From: Chris D. <cdu...@ya...> - 2005-05-26 10:59:18
|
My results based on selecting 100k rows (via a join with another table) from a 13 col table into
an identical table are (CPU figures only, elapsed times have too much "noise" due to disk
performance etc):
1. Original using fetchmany()
Python CPU: 12.1 secs
Oracle CPU: 6.8 secs
2. New approach using fetchraw() [special restricted fast method (see below) that happens to be
what I need - YES!]
Python CPU: 1.8 secs
Oracle CPU: 7.0 secs
So as you can see fetchraw() is vastly superior.
Test environment:
Athlon AMD XP2200+
Suse 8.2 with 2.4.22 kernel
Oracle 9.2
Python 2.3.4
cx_Oracle 4.1
Thanks very much for your help Anthony and the examples, they really helped
Chris
--- Chris Dunscombe <cdu...@ya...> wrote:
> > > > --- Anthony Tuininga <ant...@gm...> wrote:
> > > > > 1) You should be able to do something like this without the need to
> > > > > descend into fetchraw().
> > > > >
> > > > > import cx_Oracle
> > > > >
> > > > > fromConnection = cx_Oracle.Connection("user/pw@tns")
> > > > > toConnection = cx_Oracle.Connection("user/pw@tns")
> > > > > fromCursor = fromConnection.cursor()
> > > > > fromCursor.arraysize = 250 # set as desired
> > > > > toCursor = toConnection.cursor()
> > > > > toCursor.arraysize = 250 # set as desired, same as fromCursor
> > > > >
> > > > > fromCursor.execute("some query")
> > > > > toCursor.setinputsizes() # set things up if nulls are allowed
> > > > > while True:
> > > > > data = fromCursor.fetchmany()
> > > > > if not data:
> > > > > break
> > > > > toCursor.executemany("some insert statement", data)
> > > > > toConnection.commit() # if desired
> > > > >
> > > > > That should do it and should perform quite well. The fetchraw(),
> > > > > bindvar.copy() and executemanyprepared() trio were created solely to
> > > > > avoid the overhead of creating Python objects for the data. Its more
> > > > > complicated than the above code but I can give that as an example as
> > > > > well if you really want it.
> > > > >
> > > >
> > > > I've done essentially the same as you've got above and yes it works fine with pretty good
> > > > performance. I'm just trying to improve it further as there are cases when the app will be
> > running
> > > > a number of parallel streams each selecting and inserting millions of rows in a fixed
> window
> > so
> > > > saving 5% - 15% of the Python CPU time within this loop is definately worth doing. I'd
> like
> > a
> > > > fetchraw example so I can benchmark it against my current approach. I'll then post the
> > results so
> > > > everyone can see the general sort of performance differences between the two.
> > >
> > > Another method which also works but only when the exact data is being
> > > replicated from one cursor to another is the following. It is faster
> > > than both methods but limited in usefulness of course.
> > >
> > > import cx_Oracle
> > >
> > > sourceConnection = cx_Oracle.Connection("user/pw@tns")
> > > sourceCursor = sourceConnection.cursor()
> > > sourceCursor.arraysize = 250
> > > sourceVars = sourceCursor.execute("select * from testdata_source")
> > >
> > > targetConnection = cx_Oracle.Connection("user/pw@tns")
> > > targetCursor = targetConnection.cursor()
> > > targetCursor.execute("truncate table testdata_copy")
> > > targetCursor.arraysize = 250
> > > targetVars = targetCursor.setinputsizes(*sourceVars)
> > > targetCursor.prepare("insert into testdata_copy values (:1, :2, :3, :4)")
> > >
> > > while True:
> > > rowsFetched = sourceCursor.fetchraw()
> > > print "fetched", rowsFetched, "rows"
> > > if not rowsFetched:
> > > break
> > > targetCursor.executemanyprepared(rowsFetched)
> > > targetConnection.commit()
> > >
> > > Hope this helps,
> > >
> > > Anthony
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > > Want to be the first software developer in space?
> > > Enter now for the Oracle Space Sweepstakes!
> > > http://ads.osdn.com/?ad_idt12&alloc_id344&opclick
> > > _______________________________________________
> > > cx-oracle-users mailing list
> > > cx-...@li...
> > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> > >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > Want to be the first software developer in space?
> > Enter now for the Oracle Space Sweepstakes!
> > http://ads.osdn.com/?ad_idt12&alloc_id344&op=click
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
>
>
>
> __________________________________
> Yahoo! Mail Mobile
> Take Yahoo! Mail with you! Check email on your mobile phone.
> http://mobile.yahoo.com/learn/mail
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|
|
From: <bd...@ad...> - 2005-05-25 17:52:47
|
Thanks Anthony and Harri,
yes I had found out about -mlp64. I am building my own python
(with just readline and zlib as additional libraries) and setup.py
correctly picks the same CFLAGS for compiling cx_oracle.
Provided I edit libPath to point to either lib32 or lib under
ORACLE_HOME, the linker can produce a .sl module that looks
consistent to me (see file and ldd output below); yet python
flat-out refuses to load said module. No other message than:
$ python
Python 2.3.5 (#14, May 24 2005, 08:04:34)
[GCC 3.4.3] on hp-ux11
Type "help", "copyright", "credits" or "license" for more information.
>>>>>> import cx_Oracle
Traceback (most recent call last):
File "<stdin>", line 1, in ?
ImportError: Failed to load
/usr/local/lib/python2.3/site-packages/cx_Oracle.sl
>>>>>>
$ file /usr/local/bin/python
/usr/local/bin/python: ELF-32 executable object file - IA64
$ file /usr/local/lib/python2.3/site-packages/cx_Oracle.sl
/usr/local/lib/python2.3/site-packages/cx_Oracle.sl:
ELF-32 shared object file - IA64
$ ldd /usr/local/bin/python
libc.so.1 => /usr/lib/hpux32/libc.so.1
libpthread.so.1 => /usr/lib/hpux32/libpthread.so.1
libcl.so.1 => /usr/lib/hpux32/libcl.so.1
libnsl.so.1 => /usr/lib/hpux32/libnsl.so.1
librt.so.1 => /usr/lib/hpux32/librt.so.1
libdl.so.1 => /usr/lib/hpux32/libdl.so.1
libm.so.1 => /usr/lib/hpux32/libm.so.1
libdl.so.1 => /usr/lib/hpux32/libdl.so.1
libIO77.so.1 => /usr/lib/hpux32/libIO77.so.1
libunwind.so.1 => /usr/lib/hpux32/libunwind.so.1
libxti.so.1 => /usr/lib/hpux32/libxti.so.1
libdl.so.1 => /usr/lib/hpux32/libdl.so.1
libuca.so.1 => /usr/lib/hpux32/libuca.so.1
$ ldd /usr/local/lib/python2.3/site-packages/cx_Oracle.sl
libclntsh.so.10.1
=>/app/oracle/product/10.1.0.2/lib32/libclntsh.so.10.1
libnnz10.so => /app/oracle/product/10.1.0.2/lib32/libnnz10.so
librt.so.1 => /usr/lib/hpux32/librt.so.1
libnss_dns.so.1 => /usr/lib/hpux32/libnss_dns.so.1
libdl.so.1 => /usr/lib/hpux32/libdl.so.1
libm.so.1 => /usr/lib/hpux32/libm.so.1
libpthread.so.1 => /usr/lib/hpux32/libpthread.so.1
libunwind.so.1 => /usr/lib/hpux32/libunwind.so.1
libdl.so.1 => /usr/lib/hpux32/libdl.so.1
libdl.so.1 => /usr/lib/hpux32/libdl.so.1
libuca.so.1 => /usr/lib/hpux32/libuca.so.1
Harri, have you successfully built on HP-UX 11.23 using gcc
in 64-bit mode? Could you perhaps send me your Makefile in order
to try and spot differences? (bdelmee@advalvas._REMOVEME_.be)
I may also ask the admins if they have another box with an HP
compiler. Maybe I am missing something or this is plain broken
on this platform as I am seeing essentially the same problem
with DCOracle2...
Cheers,
Bernard.
|
|
From: Harri P. <har...@tr...> - 2005-05-25 06:47:18
|
On Tuesday 24 May 2005 20:29, Anthony Tuininga wrote: > > > > I am puzzled; could it be that gcc by default generates 32-bit > > code on Itanium? I wouldn't mind actually, but then why won't > > the module built against the 32-bit oracle libraries load? > > Yes, on HP-UX Itanium gcc defaults to generating 32 bit binaries. I believe on Linux Itanium it is 64 bit. Some tips: On HP-UX, the flag for 64 bits is -mlp64 Remember that HP-UX Itanium is ELF, so it behaves like Linux and rest of the world in may respects. (unlike HP-UX PA-RISC). Use ldd to check what is loaded. Did you build your own python? -bash-3.00$ file /usr/local/bin/python /usr/local/bin/python: ELF-64 executable object file - IA64 Hopefully you'll get this sorted out. -Harri This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code. |
|
From: Anthony T. <ant...@gm...> - 2005-05-24 18:32:45
|
This is best done by using an external class which manipulates the tuples (and there are several modules that do this) or by subclassing cx_Oracle.Cursor to do it yourself. I believe this is best left for such modules since there is no clear consensus on the matter and the performance penalty is not insigificant. Whether or not it might be helpful to have a hook is another question -- anyone care to comment? On 5/22/05, Jani Tiainen <re...@lu...> wrote: > Jani Tiainen kirjoitti: > > Hi again, > > > > Is there possibility to return row values in dictionary instead simple > > tuple? >=20 > Well let's clarify this a bit. >=20 > I've seen two ways to implement this. First is custom class that can > respond to both, column names or indices (pypgsql and pysqlite does this)= . >=20 > Second is hook to enable usage of custom classes in generation of rows, > this is done at least in pysqlite2. >=20 > I just wondered could one (maybe latter is better one) be implemented in > cx_Oracle directly. Of course this could be done by inheriting > cx_Oracle's cursor-class. >=20 > -- >=20 > Jani Tiainen >=20 >=20 >=20 > ------------------------------------------------------- > This SF.Net email is sponsored by Oracle Space Sweepstakes > Want to be the first software developer in space? > Enter now for the Oracle Space Sweepstakes! > http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: Anthony T. <ant...@gm...> - 2005-05-24 18:30:08
|
I have no access to a HP-UX Itanium box so I can't try this for myself. I know that on other platforms you can specify -m64 to indicate you want a 64-bit build when there is an option. You could try that, I suppose. Does the import give you no other errors? Usually there is a system error message that is displayed. You can also try the "type <filename>" command to determine whether the types of the files are compatible (on Solaris at least this displays whether or not the files are 32-bit or 64-bit). You can also try the ldd command to see if that generates additional errors that might help you track down the problem. Hope some of these help anyway! On 5/20/05, Bernard Delm=E9e <bd...@ad...> wrote: >=20 > I had no (serious ;-) trouble building python 2.3.5 > using gcc 3.4.3. Cx_oracle 4.1 compiles alright, but > then I get the following at link stage: >=20 > $ ld -b build/temp.hp-ux-B.11.23-ia64-2.3/cx_Oracle.o > -L/app/oracle/product/10.1.0.2/lib -lclntsh > -o build/lib.hp-ux-B.11.23-ia64-2.3/cx_Oracle.sl -s >=20 > ld: Can't find library or mismatched ABI for -lclntsh > Fatal error. > error: command 'ld' failed with exit status 1 >=20 >=20 > Under $ORACLE_HOME, i am seeing both a lib and a lib32 > directory. If I substitute lib32 to lib, the above ld > invocation works; but then python fails to load the > resulting shared lib: >=20 > [acars@prisme20] cx_Oracle-4.1 $ python > Python 2.3.5 (#8, May 20 2005, 20:55:11) > [GCC 3.4.3] on hp-ux11 > Type "help", "copyright", "credits" or "license" for more information. >=20 > >>>>>> import cx_Oracle >=20 > Traceback (most recent call last): > File "<stdin>", line 1, in ? > ImportError: Failed to load > /usr/local/lib/python2.3/site-packages/cx_Oracle.sl >=20 > >>>>>> >=20 > I am puzzled; could it be that gcc by default generates 32-bit > code on Itanium? I wouldn't mind actually, but then why won't > the module built against the 32-bit oracle libraries load? >=20 > Any suggestion welcome, >=20 > Cheers, >=20 > Bernard. >=20 >=20 >=20 > ------------------------------------------------------- > This SF.Net email is sponsored by Oracle Space Sweepstakes > Want to be the first software developer in space? > Enter now for the Oracle Space Sweepstakes! > http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: Anthony T. <ant...@gm...> - 2005-05-24 18:26:14
|
See inline. On 5/20/05, Henning von Bargen <H.v...@t-...> wrote: > Hello list users, >=20 > first of all: cx_Oracle is great! >=20 > Now I'm trying to use DBMS_AQ. > With DBMS_AQ, you can define an "object type" > for your messages. > The output from DBMS_AQ.DEQUEUE is then > your object type togehter with some additional info, > i.e. >=20 >=20 > create or replace > type AQTEST_MESSAGE_T as object > ( id number(8) -- wird =FCberlaufen > , prioritaet number(2) -- je h=F6her desto wichtiger > , inhalt varchar2(256) -- 256 Bytes sollten erstmal reichen > ); > / >=20 > grant execute on AQTEST_MESSAGE_T to public; >=20 > REM Anlegen einer Queuetabelle f=FCr die LRS-Instanzen > begin > dbms_aqadm.create_queue_table > ( queue_table =3D> 'QT_AQTEST_LRS' > , queue_payload_type =3D> 'AQTEST_MESSAGE_T' > , sort_list =3D> null > , multiple_consumers =3D> false > , auto_commit =3D> false > , compatible =3D> '8.1' > , comment =3D> 'Reporting Queue Table f=FCr LRS' > ); > end; > / >=20 > REM Anlegen einer Queue f=FCr die LRS-Instanzen > begin > dbms_aqadm.create_queue > ( queue_name =3D> 'Q_AQTEST_LRS' > , queue_table =3D> 'QT_AQTEST_LRS' > , queue_type =3D> DBMS_AQADM.NORMAL_QUEUE > , auto_commit =3D> false > , comment =3D> 'Reporting Queue f=FCr LRS' > ); > end; > / >=20 > Is it possible (or planned) for cx_Oracle to support > such Oracle Types directly? Not possible today but planned. > As a workaround, right now I'm using a wrapper > stored procedure that returns the individual members > of my AQTEST_MESSAGE_T in several out parameters. >=20 > So there's no need for urgent help, I just want to know... >=20 >=20 > BTW: > I tried running the tests with cx_Oracle 4.1 and Python 2.4.1 > using a 10g Database, and those tests using datetime failed. > There's some comment in the documentation about Python 2.4 > and datetime, but perhaps the tests should be adapted, too. Fixed. Thanks. > Henning >=20 >=20 > ------------------------------------------------------- > This SF.Net email is sponsored by Oracle Space Sweepstakes > Want to be the first software developer in space? > Enter now for the Oracle Space Sweepstakes! > http://ads.osdn.com/?ad_idt12&alloc_id=16344&opclick > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: Jani T. <re...@lu...> - 2005-05-23 05:26:43
|
Jani Tiainen kirjoitti: > Hi again, > > Is there possibility to return row values in dictionary instead simple > tuple? Well let's clarify this a bit. I've seen two ways to implement this. First is custom class that can respond to both, column names or indices (pypgsql and pysqlite does this). Second is hook to enable usage of custom classes in generation of rows, this is done at least in pysqlite2. I just wondered could one (maybe latter is better one) be implemented in cx_Oracle directly. Of course this could be done by inheriting cx_Oracle's cursor-class. -- Jani Tiainen |
|
From: <bd...@ad...> - 2005-05-20 19:42:00
|
I had no (serious ;-) trouble building python 2.3.5 using gcc 3.4.3. Cx_oracle 4.1 compiles alright, but then I get the following at link stage: $ ld -b build/temp.hp-ux-B.11.23-ia64-2.3/cx_Oracle.o -L/app/oracle/product/10.1.0.2/lib -lclntsh -o build/lib.hp-ux-B.11.23-ia64-2.3/cx_Oracle.sl -s ld: Can't find library or mismatched ABI for -lclntsh Fatal error. error: command 'ld' failed with exit status 1 Under $ORACLE_HOME, i am seeing both a lib and a lib32 directory. If I substitute lib32 to lib, the above ld invocation works; but then python fails to load the resulting shared lib: [acars@prisme20] cx_Oracle-4.1 $ python Python 2.3.5 (#8, May 20 2005, 20:55:11) [GCC 3.4.3] on hp-ux11 Type "help", "copyright", "credits" or "license" for more information. >>>>>> import cx_Oracle Traceback (most recent call last): File "<stdin>", line 1, in ? ImportError: Failed to load /usr/local/lib/python2.3/site-packages/cx_Oracle.sl >>>>>> I am puzzled; could it be that gcc by default generates 32-bit code on Itanium? I wouldn't mind actually, but then why won't the module built against the 32-bit oracle libraries load? Any suggestion welcome, Cheers, Bernard. |
|
From: Henning v. B. <H.v...@t-...> - 2005-05-20 07:24:04
|
Hello list users, first of all: cx_Oracle is great! Now I'm trying to use DBMS_AQ. With DBMS_AQ, you can define an "object type" for your messages. The output from DBMS_AQ.DEQUEUE is then=20 your object type togehter with some additional info, i.e. create or replace type AQTEST_MESSAGE_T as object ( id number(8) -- wird =FCberlaufen , prioritaet number(2) -- je h=F6her desto wichtiger , inhalt varchar2(256) -- 256 Bytes sollten erstmal reichen ); / grant execute on AQTEST_MESSAGE_T to public; REM Anlegen einer Queuetabelle f=FCr die LRS-Instanzen begin dbms_aqadm.create_queue_table ( queue_table =3D> 'QT_AQTEST_LRS' , queue_payload_type =3D> 'AQTEST_MESSAGE_T' , sort_list =3D> null , multiple_consumers =3D> false , auto_commit =3D> false , compatible =3D> '8.1' , comment =3D> 'Reporting Queue Table f=FCr LRS' ); end; / REM Anlegen einer Queue f=FCr die LRS-Instanzen begin dbms_aqadm.create_queue ( queue_name =3D> 'Q_AQTEST_LRS' , queue_table =3D> 'QT_AQTEST_LRS' , queue_type =3D> DBMS_AQADM.NORMAL_QUEUE , auto_commit =3D> false , comment =3D> 'Reporting Queue f=FCr LRS' ); end; / Is it possible (or planned) for cx_Oracle to support such Oracle Types directly? As a workaround, right now I'm using a wrapper=20 stored procedure that returns the individual members of my AQTEST_MESSAGE_T in several out parameters. So there's no need for urgent help, I just want to know... BTW: I tried running the tests with cx_Oracle 4.1 and Python 2.4.1 using a 10g Database, and those tests using datetime failed. There's some comment in the documentation about Python 2.4 and datetime, but perhaps the tests should be adapted, too. Henning |
|
From: Jani T. <re...@lu...> - 2005-05-19 21:42:22
|
Hi again, Is there possibility to return row values in dictionary instead simple tuple? -- Jani Tiainen |
|
From: Anthony T. <ant...@gm...> - 2005-05-18 20:44:44
|
We don't use HP-UX much but the few times that I have used it gcc seemed to work the best -- at least for the past year or so. Prior to that gcc had all sorts of issues compiling Python but everything was smooth sailing the last time I tried it with gcc 3.2. On 5/18/05, Bernard Delm=E9e <bd...@ad...> wrote: > Hello, >=20 > I am a very satisfied user of cx_oracle on windows and HP-UX > where Anthony once kindly helped me sort out installation > problems. Thanks again for your patience. >=20 > Because we will be moving to Oracle 10g on Itanium, > I will shortly need to compile python 2.3 and cx_oracle > on that platform. I seem to recall people having problem > compiling python on HP-UX in general, and am interested > in opinions about which compiler to use. Should I require > the HP compiler, or is gcc known to work for this purpose ? >=20 > A binary build of gcc is provided by HP at > http://hpux.connect.org.uk/hppd/hpux/Gnu/gcc-3.4.3/ >=20 > "uname -a" reports the following, in case it helps: > HP-UX prisme20 B.11.23 U ia64 1530408444 unlimited-user license >=20 > Thanks for any hint, >=20 > Bernard. >=20 > ------------------------------------------------------- > This SF.Net email is sponsored by Oracle Space Sweepstakes > Want to be the first software developer in space? > Enter now for the Oracle Space Sweepstakes! > http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: Anthony T. <ant...@gm...> - 2005-05-18 20:41:23
|
On 5/18/05, Jani Tiainen <re...@lu...> wrote:
> Anthony Tuininga kirjoitti:
> > On 5/18/05, Jani Tiainen <re...@lu...> wrote:
> >
> >>Jani Tiainen kirjoitti:
> >>
> >>
> >>>In application code insert clause is in form:
> >>>
> >>>sql =3D "INSERT INTO FOOBAR (ID, VALUE, CLOB_VALUE) VALUES (%s, %s, %s=
)"
> >>>params =3D (1, 'foobar', 'verylongfoobar')
> >>>
> >>>This is converted to format:
> >>>
> >>>sql =3D "INSERT INTO FOOBAR (ID, VALUE, CLOB_VALUE) VALUES (:val1, :va=
l2,
> >>>:val3)"
> >>>params =3D {'val1' : 1, 'val2' : 'foobar', 'val3' : 'verylongfoobar'}
> >>>
> >>>Now this works as long as string I'm trying to insert doesn't exceed
> >>>4000 chars. If that happens it tries insert LONG to CLOB column.
> >>>
> >>>I've tried following piece of code:
> >>>
> >>># Adjust inputsizes..
> >>>inputsizes =3D {}
> >>>for k, v in params.items():
> >>> if type(v) is str and len(v) > 4000:
> >>> inputsizes[k] =3D cx_Oracle.CLOB
> >>> else:
> >>> inputsizes[k] =3D None
> >>>
> >>>cursor.setinputsizes(inputsizes)
> >>>
> >>>And I always endup having "cx_Oracle.NotSupportedError:
> >>>Variable_TypeByPythonType(): unhandled data type" error. Even I remove
> >>>else-branch final result is still same.
> >>>
> >>>Even I used cx_Oracle.STRING instead of None result was same.
> >>>
> >>
> >>Only occassion when abowe works is when named parameters are passed.
> >>
> >>Even following doesn't seem to work:
> >>
> >>cursor.setinputvalues([None, cx_Oracle.CLOB])
> >>cursor.execute("INSERT INTO FOOBAR(ID, CLOB_VAR) VALUES (:1, :2)",
> >> [{'1' : 1002}, {'2' : 'longfoobartext'}])
> >
> >
> > This should be
> >
> > cursor.execute(insert_statement, [1002, 'longfoobartext'])
> >
> > In other words, you should not pass a dictionary for positional
> > arguments but a sequence instead.
>=20
> I saw that on some example and it seemed to work tough.. :)
>=20
> Well finally I got it workin (felt a little stupid after all.. :)
>=20
> But thak you very much for help and patience.
You're welcome. Glad to hear you got it working.
> Final question: Is there plans to support c-format (%s) parameters in
> execute query?
Not really. You can always use "sql_statement % args" as the statement
parameter to the execute or you can subclass cx_Oracle.Cursor and
perform this yourself -- plenty of options if you really like that
motif. Its generally not considered good form, though, since you
destroy Oracle's cursor cache which reduces performance quite a bit
when a lot of statements are being issued.
> --
>=20
> Jani Tiainen
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
|
|
From: <bd...@ad...> - 2005-05-18 17:18:03
|
Hello, I am a very satisfied user of cx_oracle on windows and HP-UX where Anthony once kindly helped me sort out installation problems. Thanks again for your patience. Because we will be moving to Oracle 10g on Itanium, I will shortly need to compile python 2.3 and cx_oracle on that platform. I seem to recall people having problem compiling python on HP-UX in general, and am interested in opinions about which compiler to use. Should I require the HP compiler, or is gcc known to work for this purpose ? A binary build of gcc is provided by HP at http://hpux.connect.org.uk/hppd/hpux/Gnu/gcc-3.4.3/ "uname -a" reports the following, in case it helps: HP-UX prisme20 B.11.23 U ia64 1530408444 unlimited-user license Thanks for any hint, Bernard. |
|
From: Jani T. <re...@lu...> - 2005-05-18 15:59:24
|
Anthony Tuininga kirjoitti:
> On 5/18/05, Jani Tiainen <re...@lu...> wrote:
>
>>Jani Tiainen kirjoitti:
>>
>>
>>>In application code insert clause is in form:
>>>
>>>sql = "INSERT INTO FOOBAR (ID, VALUE, CLOB_VALUE) VALUES (%s, %s, %s)"
>>>params = (1, 'foobar', 'verylongfoobar')
>>>
>>>This is converted to format:
>>>
>>>sql = "INSERT INTO FOOBAR (ID, VALUE, CLOB_VALUE) VALUES (:val1, :val2,
>>>:val3)"
>>>params = {'val1' : 1, 'val2' : 'foobar', 'val3' : 'verylongfoobar'}
>>>
>>>Now this works as long as string I'm trying to insert doesn't exceed
>>>4000 chars. If that happens it tries insert LONG to CLOB column.
>>>
>>>I've tried following piece of code:
>>>
>>># Adjust inputsizes..
>>>inputsizes = {}
>>>for k, v in params.items():
>>> if type(v) is str and len(v) > 4000:
>>> inputsizes[k] = cx_Oracle.CLOB
>>> else:
>>> inputsizes[k] = None
>>>
>>>cursor.setinputsizes(inputsizes)
>>>
>>>And I always endup having "cx_Oracle.NotSupportedError:
>>>Variable_TypeByPythonType(): unhandled data type" error. Even I remove
>>>else-branch final result is still same.
>>>
>>>Even I used cx_Oracle.STRING instead of None result was same.
>>>
>>
>>Only occassion when abowe works is when named parameters are passed.
>>
>>Even following doesn't seem to work:
>>
>>cursor.setinputvalues([None, cx_Oracle.CLOB])
>>cursor.execute("INSERT INTO FOOBAR(ID, CLOB_VAR) VALUES (:1, :2)",
>> [{'1' : 1002}, {'2' : 'longfoobartext'}])
>
>
> This should be
>
> cursor.execute(insert_statement, [1002, 'longfoobartext'])
>
> In other words, you should not pass a dictionary for positional
> arguments but a sequence instead.
I saw that on some example and it seemed to work tough.. :)
Well finally I got it workin (felt a little stupid after all.. :)
But thak you very much for help and patience.
Final question: Is there plans to support c-format (%s) parameters in
execute query?
--
Jani Tiainen
|
|
From: Anthony T. <ant...@gm...> - 2005-05-18 13:31:19
|
On 5/18/05, Jani Tiainen <re...@lu...> wrote:
> Jani Tiainen kirjoitti:
>=20
> > In application code insert clause is in form:
> >
> > sql =3D "INSERT INTO FOOBAR (ID, VALUE, CLOB_VALUE) VALUES (%s, %s, %s)=
"
> > params =3D (1, 'foobar', 'verylongfoobar')
> >
> > This is converted to format:
> >
> > sql =3D "INSERT INTO FOOBAR (ID, VALUE, CLOB_VALUE) VALUES (:val1, :val=
2,
> > :val3)"
> > params =3D {'val1' : 1, 'val2' : 'foobar', 'val3' : 'verylongfoobar'}
> >
> > Now this works as long as string I'm trying to insert doesn't exceed
> > 4000 chars. If that happens it tries insert LONG to CLOB column.
> >
> > I've tried following piece of code:
> >
> > # Adjust inputsizes..
> > inputsizes =3D {}
> > for k, v in params.items():
> > if type(v) is str and len(v) > 4000:
> > inputsizes[k] =3D cx_Oracle.CLOB
> > else:
> > inputsizes[k] =3D None
> >
> > cursor.setinputsizes(inputsizes)
> >
> > And I always endup having "cx_Oracle.NotSupportedError:
> > Variable_TypeByPythonType(): unhandled data type" error. Even I remove
> > else-branch final result is still same.
> >
> > Even I used cx_Oracle.STRING instead of None result was same.
> >
>=20
> Only occassion when abowe works is when named parameters are passed.
>=20
> Even following doesn't seem to work:
>=20
> cursor.setinputvalues([None, cx_Oracle.CLOB])
> cursor.execute("INSERT INTO FOOBAR(ID, CLOB_VAR) VALUES (:1, :2)",
> [{'1' : 1002}, {'2' : 'longfoobartext'}])
This should be
cursor.execute(insert_statement, [1002, 'longfoobartext'])
In other words, you should not pass a dictionary for positional
arguments but a sequence instead.
> Any ideas why it always gives error except in case of named params?
>=20
> --
>=20
> Jani Tiainen
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
|
|
From: Anthony T. <ant...@gm...> - 2005-05-18 13:29:44
|
On 5/17/05, Jani Tiainen <re...@lu...> wrote:
> Anthony Tuininga kirjoitti:
> > On 5/17/05, Jani Tiainen <re...@lu...> wrote:
> >
> >>Anthony Tuininga kirjoitti:
> >>
> >>>On 5/17/05, Jani Tiainen <re...@lu...> wrote:
> >>>
> >>>
> >>>>>BTW, if you __really__ have no control, you can always subclass
> >>>>>Connection and Cursor and do whatever you need to do. Subclassing ha=
s
> >>>>>been quite convenient and I use it myself for a number of situations
> >>>>>where the code is used by multiple database adapters.
> >>>>
> >>>>Any pointers in web (example would be nice) since I'm just becoming
> >>>>friend of Python and I might be trying to do things wrong here...
> >>>
> >>>
> >>>Recent e-mails to this list have had some examples. Subclassing
> >>>cx_Oracle.Connection and cx_Oracle.Cursor are the same as sublcassing
> >>>any other class in Python -- not very helpful if you haven't done much
> >>>of it yourself yet, I guess. :-)
> >>
> >>Well I have something like following:
> >>
> >>query =3D "insert into foobar (id, name) values (:1, :2)"
> >>values =3D {'1' : 123, '2' : 'Mr. Dumb'
> >>cursor.setinputsizes({'2' : cx_Oracle.CLOB})
> >>cursor.execute(query, values)
> >>
> >>But I'm getting error:
> >>Variable_TypeByPythonType(): unhandled data type
> >>
> >>What I'm doing wrong..?
> >
> >
> > Oracle uses :1, :2 for __positional__ arguments and :fred and :george
> > for __named__ arguments. cx_Oracle expects a dictionary for named
> > arguments and a sequence for positional arguments. So instead of
> > passing a dictionary as the arguments, pass a list instead and that
> > should solve your problems. In addition, setinputsizes() uses the
> > *args and **kwargs notation so you should specify the following:
> >
> > cursor.setinputsizes([None, cx_Oracle.CLOB]) OR
>=20
> I got this never working... It just says "cx_Oracle.ProgrammingError:
> number of elements must be an integer"
What version of cx_Oracle are you using? The above will only work with
cx_Oracle 4.1.
> > cursor.setinputsizes(value =3D cx_Oracle.CLOB)
> >
> > and reference :value in your statement. Make sense?
>=20
> Yes, but... I think I pasted too short description of my problem.
>=20
> In application code insert clause is in form:
>=20
> sql =3D "INSERT INTO FOOBAR (ID, VALUE, CLOB_VALUE) VALUES (%s, %s, %s)"
> params =3D (1, 'foobar', 'verylongfoobar')
>=20
> This is converted to format:
>=20
> sql =3D "INSERT INTO FOOBAR (ID, VALUE, CLOB_VALUE) VALUES (:val1, :val2,
> :val3)"
> params =3D {'val1' : 1, 'val2' : 'foobar', 'val3' : 'verylongfoobar'}
>=20
> Now this works as long as string I'm trying to insert doesn't exceed
> 4000 chars. If that happens it tries insert LONG to CLOB column.
>=20
> I've tried following piece of code:
>=20
> # Adjust inputsizes..
> inputsizes =3D {}
> for k, v in params.items():
> if type(v) is str and len(v) > 4000:
> inputsizes[k] =3D cx_Oracle.CLOB
> else:
> inputsizes[k] =3D None
>=20
> cursor.setinputsizes(inputsizes)
You want to use this instead:
cursor.setinputsizes(**inputsizes)
> And I always endup having "cx_Oracle.NotSupportedError:
> Variable_TypeByPythonType(): unhandled data type" error. Even I remove
> else-branch final result is still same.
Yes, see above. The method is expecting keyword arguments or a list of
arguments (when using cx_Oracle 4.1). So if you build your dictionary
in this fashion you need to use the ** syntax to pass it through as
keyword arguments.
> Even I used cx_Oracle.STRING instead of None result was same.
Certainly. BTW, you don't need to specify inputsizes except to tell
the driver about things it can't figure out on its own. In the above
code you can eliminate the else branch completely.
> --
>=20
> Jani Tiainen
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick
> _______________________________________________
> 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.
