Re: [Zope-DB] DCOracle2 installation, I'm missing header files

2008-05-31 Thread Chris Withers
M.-A. Lemburg wrote: Oh, ok. Is there a Zope DB adapter for cxOracle? If you're looking for a stable Zope DA interface to Oracle, you might want to try our mxODBC Zope DA: http://www.egenix.com/products/zope/mxODBCZopeDA/ cxOracle is pretty stable, and doesn't require you going near

Re: [Zope-DB] DCOracle2 installation, I'm missing header files

2008-05-31 Thread David Durham, Jr.
On Fri, May 30, 2008 at 6:26 AM, Chris Withers [EMAIL PROTECTED] wrote: M.-A. Lemburg wrote: Oh, ok. Is there a Zope DB adapter for cxOracle? If you're looking for a stable Zope DA interface to Oracle, you might want to try our mxODBC Zope DA:

Re: [Zope-DB] DCOracle2 installation, I'm missing header files

2008-05-13 Thread M.-A. Lemburg
On 2008-04-04 01:38, David Durham, Jr. wrote: On Thu, Apr 3, 2008 at 6:09 PM, Chris Withers [EMAIL PROTECTED] wrote: David Durham, Jr. wrote: Anyone spot what I'm doing wrong? You're using DCOracle2 instead of cxOracle ;-) http://sourceforge.net/projects/cx-oracle/ Oh, ok. Is there a

Re: [Zope-DB] DCOracle2 installation, I'm missing header files

2008-04-03 Thread Chris Withers
David Durham, Jr. wrote: Anyone spot what I'm doing wrong? You're using DCOracle2 instead of cxOracle ;-) http://sourceforge.net/projects/cx-oracle/ Chris -- Simplistix - Content Management, Zope Python Consulting - http://www.simplistix.co.uk

Re: [Zope-DB] DCOracle2 installation, I'm missing header files

2008-04-03 Thread David Durham, Jr.
On Thu, Apr 3, 2008 at 6:09 PM, Chris Withers [EMAIL PROTECTED] wrote: David Durham, Jr. wrote: Anyone spot what I'm doing wrong? You're using DCOracle2 instead of cxOracle ;-) http://sourceforge.net/projects/cx-oracle/ Oh, ok. Is there a Zope DB adapter for cxOracle? Thanks, Dave

[Zope-DB] DCOracle2 and x86_64

2007-03-22 Thread Maan M. Hamze
Maceij - You got the following: gcc -pthread -shared ./dco2.o -L/opt/oracle/client.9/product/lib32/ -lclntsh -Wl,-rpath,/opt/oracle/client.9/product/lib -o ./dco2.so BOTH oracle lib directories should be lib32. In the above, you have one pointing to lib32 and the other one to lib. Change

Re: [Zope-DB] DCOracle2 and x86_64

2007-03-22 Thread Maciej Wisniowski
Maceij - You got the following: gcc -pthread -shared ./dco2.o -L/opt/oracle/client.9/product/lib32/ -lclntsh -Wl,-rpath,/opt/oracle/client.9/product/lib -o ./dco2.so BOTH oracle lib directories should be lib32. In the above, you have one pointing to lib32 and the other one to lib.

Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns a ref_cur

2007-03-21 Thread Maan M. Hamze
- Original Message - From: Matthew T. Kromer [EMAIL PROTECTED] To: Maan M. Hamze [EMAIL PROTECTED] Cc: zope-db@zope.org Sent: Tuesday, March 20, 2007 8:17 PM Subject: Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns a ref_cur If I recall, DCOracle2 returns an array

[Zope-DB] DCOracle2 TIMESTAMP DataType Issue

2007-03-21 Thread Maan M. Hamze
] To: Maan M. Hamze [EMAIL PROTECTED] Cc: zope-db@zope.org Sent: Tuesday, March 20, 2007 8:32 PM Subject: Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR / ORA TIMESTAMP DataType Issue Chances are good that the C code that is trying to construct the timestamp doesn't know

RE: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR / ORA TIMESTAMP DataType Issue

2007-03-20 Thread Maan M. Hamze
data type with DCOracle2? Maan -Original Message- From: Maan M. Hamze [mailto:[EMAIL PROTECTED] Sent: Saturday, March 17, 2007 5:32 PM To: zope-db@zope.org Subject: Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR m.banaouas [EMAIL PROTECTED]: options = (2714

RE: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR

2007-03-20 Thread Maan M. Hamze
You have a point Maciej - but I got used to DCOracle2 and so far it has performed quite well. I link it with Oracle lib32 libraries, but use it with ora lib 64-bit libraries in the path. So far, there has been no issues I am aware of. The only thing that came up recently is how to use it with a

Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR / ORA TIMESTAMP DataType Issue

2007-03-20 Thread Matthew T. Kromer
-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR m.banaouas [EMAIL PROTECTED]: options = (2714, + ' + + ', + 36, 1, c2) it's wrong! you must give a sequence as second parameter of execute method. So you do like this: options = (2714, '',36, 1, c2) c1.execute(sql

Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR / ORA TIMESTAMP DataType Issue

2007-03-20 Thread Maciej Wisniowski
This was causing a segmentation fault on a Sun Solaris box. On Windows, I got an actual error message. While fetching, the cursor has a field of ora datatype TimeStamp. This was crashing DCOracle2. a to_char solved the issue. I am using DCOracle2 and Oracle 10 on Solaris (and Windows XP).

Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns a ref_cur

2007-03-17 Thread m.banaouas
options = (2714, + ' + + ', + 36, 1, c2) it's wrong! you must give a sequence as second parameter of execute method. So you do like this: options = (2714, '',36, 1, c2) c1.execute(sql, options) Maan M. Hamze a écrit : Hello - Thanks for your help. I am still getting

[Zope-DB] DCOracle2 and x86_64

2006-12-05 Thread Maciej Wisniowski
Hi Anybody uses DCOracle2 under 64 bit machine? Any problems with that? We have some problems under RHEL4 and 64 bit Operton CPU. Under heavy load our Zope is just restarting. /var/log/messages says: (...) kernel: python[10526]: segfault at a0084c10 rip 002a959041a0 rsp

Re: [Zope-DB] DCOracle2 on AIX5.2 -- issues

2006-03-15 Thread Matthew T . Kromer
It's probably the TRACE macro which is generating a lot of these messages, if you don't need to be able to do runtime tracing (for diagnostics) then you can tweak the #define TRACE(condition,args) to be a no-op macro -- just delete the body of the macro. On Mar 14, 2006, at 2:54 PM,

Re: [Zope-DB] DCOracle2 on AIX5.2 -- issues

2006-03-15 Thread mfmorss
Obviously, your compiler does not like thing (to be precise: the implicit conversion between short and unsigned short) that the author did not expect to hurt compilers (and which most compilers accept). Your options: * use a different (less strict) compiler * fix the code (such that even

Re: [Zope-DB] DCOracle2 on AIX5.2 -- issues

2006-03-14 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2006-3-13 13:32 -0500: ... However, during compilation of cdo2.o, I did encounter these symptoms: cc_r -DNDEBUG -O -I/oracle/product/9.2.0.6/rdbms/demo -I/oracle/product/9.2.0.6/network/public -I/oracle/product/9.2.0.6 /plsql/public

[Zope-DB] DCOracle2 on AIX5.2 -- issues

2006-03-13 Thread mfmorss
I have Python 2.4.2 installed on AIX 5.2. With some trouble, I have been able to compile and install dco2.so. The main problem was that the header files desired by setup.py were not found in oracle_home, but elsewhere in my Oracle installation -- they appear to be part of Oracle 8, not Oracle 9,

[Zope-DB] DCOracle2 installation problem

2006-02-28 Thread Causevic, Dzenan
Title: DCOracle2 installation problem I downloaded DCOracle2-1.2.tgz and I am trying to install DCOracle on Fedora Core 3, I am using Oracle client libraries version 9.2, $ORACLE_HOME is correctly set, but when I try to build from the source files I get the following error message saying

RE: [Zope-DB] DCOracle2: lib vs lib64: make fails on SuSE SLES 9

2006-02-22 Thread Jet Wilda
-Original Message- From: Christian Long [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 22, 2006 12:12 AM To: Jet Wilda Subject: RE: [Zope-DB] DCOracle2: lib vs lib64: make fails on SuSE SLES 9 Yes, it's working fine. Here are the steps I followed. Let me know how you do, and we can

[Zope-DB] DCOracle2 for Python2.4

2005-11-16 Thread Matthew Cahn
I have an application which uses DCOracle2. I wonder if anyone has built dco2.pyd for Python 2.4. The 2.3 version built by Mikey at Zope has been working great. Matthew ___ Zope-DB mailing list Zope-DB@zope.org

[Zope-DB] DCOracle2, Oracle 10g and Long data type

2005-10-19 Thread Seth Gottlieb
I have heard that people are successfully using DCOracle2 against Oracle 10g. I was able to get it working but I seem to be getting a Oracle error (ORA-21301: not initialized in object mode) when trying to write to a Long datatype. BTW, I am using dtml-sqlvar type 'string' in my SQL

[Zope-DB] DCOracle2 and ConnectionReleasedError

2005-07-13 Thread Maciej Wisniowski
Hi We are using DCOracle2 from CVS head branch, but I'm testing chrisw_fixconnectionleak_branch branch created by chrisw and I've fallen into some errors with this. First of all, is chrisw_fixconnectionleak_branch branch the recommended one? I've seen Carsten Gerner question about the version

Re: [Zope-DB] DCoracle2 - truncates UTF-8 string with national characters

2005-05-24 Thread Maciej Winiowski
Are you sure that this is a DCOracle2 problem and not a database problem? UTF-8 may need 5 times more bytes then the character length. Both DCOracle2 and Oracle may get this wrong. Queries from TOAD or sqlplus are returning correct results. I've tried to run sqlplus query as user Zope on the

[Zope-DB] Dcoracle2

2005-04-13 Thread Wadis
Hallo, I have zope 2.7.5 on Windows. I would like use Dcoracle2 for connect to Oracle 8.1.7. In download of Dcoracle2 are pre-compiled binaries for Python 1.5 - 2.2 and I need pre-compiled binaries for Python 2.3.5. Help me please Wadis