cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle

Re: [cx-oracle-users] More cx_Oracle under cygwin python woes

[Steinmann D. <Dan...@co...>]

On Tuesday, September 19, 2006 10:47 PM, Laurelin of Middle Earth wrote:

> Does anybody have "recent information" about how to get
> whatever-it-is- that-is-needed-in-the-simplest-way so that I have the
> OCI "stuff" needed by cx_Oracle so that I can build it myself? =20

1. Download OracleXE:

$ echo $ORACLE_HOME=20
c:/programs/oraclexe/app/oracle/product/10.2.0/server


2. Install cygwin version of gcc and python:

$ gcc --version
gcc (GCC) 3.4.4 (cygming special) (gdc 0.12, using dmd 0.125)
Copyright (C) 2004 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is
NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.

$ python
Python 2.4.3 (#1, May 18 2006, 07:40:45)=20
[GCC 3.3.3 (cygwin special)] on cygwin
Type "help", "copyright", "credits" or "license" for more information.
>>>=20


3. Download cx_Oracle-4.2 and build/install it:

$  python setup.py build
$  python setup.py install

Done!=20

It works out of the box for me.

Daniel

Re: [cx-oracle-users] More cx_Oracle under cygwin python woes

[Steinmann D. <Dan...@co...>]

Sorry, forget my last email (it went out too fast).

I new one is coming soon.

Sorry,
Daniel

Re: [cx-oracle-users] More cx_Oracle under cygwin python woes

[Steinmann D. <Dan...@co...>]

On Tuesday, September 19, 2006 10:47 PM, Laurelin of Middle Earth wrote:

> Does anybody have "recent information" about how to get
> whatever-it-is- that-is-needed-in-the-simplest-way so that I have the
> OCI "stuff" needed by cx_Oracle so that I can build it myself? =20

1. Download OracleXE:


2. Install cygwin version of gcc and python:

tzhstda0@U149568 /home/tmp/src/cx_Oracle-4.2
$ gcc --version
gcc (GCC) 3.4.4 (cygming special) (gdc 0.12, using dmd 0.125)
Copyright (C) 2004 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is
NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.


tzhstda0@U149568 /home/tmp/src/cx_Oracle-4.2
$ python
Python 2.4.3 (#1, May 18 2006, 07:40:45)=20
[GCC 3.3.3 (cygwin special)] on cygwin
Type "help", "copyright", "credits" or "license" for more information.
>>>=20


>=20
> Thanks in advance, lauri
> -- lauri loebel carpenter
>     computing grunt
>     fermilab
>     la...@fn...
>=20
>
------------------------------------------------------------------------
-
> Take Surveys. Earn Cash. Influence the Future of IT Join
> SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys -- and
> earn cash
>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
> _______________________________________________   =20
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users



---
Daniel Steinmann, COMIT AG, Zuerich, Switzerland
dan...@co..., +41 (0)79 251 41 75

[cx-oracle-users] More cx_Oracle under cygwin python woes

[Laurelin of M. E. <la...@fn...>]

Good day,

After much wailing and gnashing of teeth (aka, reading the fine
documentation and trying lots of peoples' suggestions) -- I still
cannot get cx_Oracle to work in my cygwin python environment.  It works
in the Windows python environment -- and the windows installer did
everything "just fine".  But that doesn't really help me.

I've tried building from scratch using "python setup.py build
--compiler=mingw32", but get a multiscreenful of error messages that
indicate I do not have the appropriate OCI "stuff" (whatever that
means).  The ORACLE_HOME I have contains OracleDesigner, and sqlplus,
and other stuff -- but evidently not the part needed for OCI.
(Instructions for this from
http://sourceforge.net/mailarchive/message.php?msg_id=13148558, almost
a year old; I'm not sure if this person ever resolved his/her problem
either).

I found webpages suggesting that one can use the instantclient (basic
plus sdk), so I installed these and tried to follow the "edit and
roll-your-own" instructions.  Evidently the directions were posted
before the latest release of instantclient and/or cx_Oracle, because
the suggested "edit the setup.py file" instructions no longer match
anything that I see when looking at the setup.py file, nor when
looking at the instantclient file hierarchy.  (Instructions for this
from http://sourceforge.net/mailarchive/message.php?msg_id=13558142,
almost a year old).

I've tried copying the cx_Oracle.pyd file from the version that was
Windows-installed into my cygwin $PYTHONPATH, but it seems to be
entirely ignored ("ImportError: no module named cx_Oracle")
(Instructions for this at
http://sourceforge.net/mailarchive/message.php?msg_id=13766188, but it
doesn't seem to work).


Does anybody have "recent information" about how to get whatever-it-is-
that-is-needed-in-the-simplest-way so that I have the OCI "stuff" needed
by cx_Oracle so that I can build it myself?

Thanks in advance, lauri
-- lauri loebel carpenter
    computing grunt
    fermilab
    la...@fn...

Re: [cx-oracle-users] Why do Connection and SessionPool objects not share an Environment?

[Anthony T. <ant...@gm...>]

On 9/19/06, Alex Tingle <al...@fi...> wrote:
> Hi Anthony,
>
> Thanks for taking the time to respond.

You're welcome.

> On 19 Sep 2006, at 15:31, Anthony Tuininga wrote:
>
> >> If you think that cx_Oracle is wrong, then I might send you a patch,
> >> if
> >> you like.
> >
> > Try it first and let me know how it works for you. :-)
>
> Of course. That's always the first and last rule ;-)
>
> Is there a test suite?

Yes. Its in the "test" subdirectory. That covers the basics. It does
not cover (of course) running something with many threads for a long
period of time. That you'll have to set up yourself.

> -Alex
>
> --
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Why do Connection and SessionPool objects not share an Environment?

[Alex T. <al...@fi...>]

Hi Anthony,

Thanks for taking the time to respond.

On 19 Sep 2006, at 15:31, Anthony Tuininga wrote:

>> If you think that cx_Oracle is wrong, then I might send you a patch, 
>> if
>> you like.
>
> Try it first and let me know how it works for you. :-)

Of course. That's always the first and last rule ;-)

Is there a test suite?

-Alex

--

Re: [cx-oracle-users] Why do Connection and SessionPool objects not share an Environment?

[Anthony T. <ant...@gm...>]

On 9/19/06, Alex Tingle <al...@fi...> wrote:
> Hi Anthony,
>
> On 19 Sep 2006, at 14:49, Anthony Tuininga wrote:
>
> > May I ask why you asked the question in the first place?
>
> I'll answer the last question first: I'm toying with the idea of
> 'porting' cx_Oracle to be a C++ interface to OCI. It's really and
> exercise in teaching myself to use OCI. The practical result is I'm
> reading the source code, and trying to work out what it's doing.

Ok. Just be aware that the OCI is a jungle and you need a good sharp
machete to make your way through it... :-) The part that is the most
convoluted is the whole binding/defining area -- the rules are very
obscure and often found only by trial and error. I'm very happy to not
have to deal with the OCI very much at all on a regular basis!

> The code I'm asking about puzzled me. It was either very subtle, or a
> potential bug. If it's subtle, I wanted to know. If it's a bug, I
> thought you'd want to know.

Sure. If its a bug I'd certainly like to know about it. I don't
believe it is, though. We have an application that is heavily threaded
and uses session pools and it appears to be very stable. We've run it
overnight with about 10-15 threads constantly making queries and it
has worked flawlessly.

> > If I understand correctly, however, the environment handle is the
> > "master" handle and all of the other handles are children to it.
>
> That seems reasonable. But if the environment handle is the "master" -
> how can it be right to make a new environment for a session handle
> that's been acquired from a pool that already HAS an environment?

Not certain. Oracle doesn't provide much information about these sorts
of things in the OCI. Its one of those things you simply try -- and if
it works you're happy. I can't remember if I tried the other method
but I think I did and it didn't work very well. Feel free to try it
yourself, though, as my memory may be faulty. :-)

> > In order to establish thread safety you want to make sure that the
> > handles from one thread are not used in another -- otherwise you need
> > to establish locking and the like which has its own set of issues.
>
> cx_Oracle's Environment struct contains an errorHandle as well as an
> env handle. Each thread certainly needs its own error handle. Perhaps a
> new Environment struct was made in order to make a new error handle,
> and the new env handle was just made by mistake?

Maybe, but I don't think so.

> I assume that it works OK, even if it's strictly incorrect.

It does work OK. I'm not sure if it is strictly incorrect or not. If
you can find a pointer in the OCI documentation about this I'd be
happy to see it.

> If you think that cx_Oracle is wrong, then I might send you a patch, if
> you like.

Try it first and let me know how it works for you. :-)

> -Alex
>
> --
>
> > On 9/18/06, Alex Tingle <al...@fi...> wrote:
> >> Hello,
> >>
> >> This is a question about the C implementation of cx_Oracle. I've been
> >> reading the source code and trying to understand how you are using
> >> OCI.
> >>
> >> When a Connection is acquired from a SessionPool, it creates a brand
> >> new
> >> environment for itself, rather than using the environment that the
> >> SessionPool already has. That seems odd to me. (See
> >> Connection_Acquire()
> >> and Connection_Init() in Connection.c.)
> >>
> >> Can you explain why you create a new environment?
> >>
> >> Are you following the OCI documentation (if so where - I can't find
> >> anything that suggests this) or have you established the method's
> >> reliability by experience?
> >>
> >> (Sorry in advance if this is a stupid question.)
> >>
> >> -Alex
> >>
> >> --
> >> :: Let me solve your problems: http://www.firetree.net/consulting/
> >> :: alex.tingle AT firetree.net  +44-7901-552763
> >>
> >> ----------------------------------------------------------------------
> >> ---
> >> Take Surveys. Earn Cash. Influence the Future of IT
> >> Join SourceForge.net's Techsay panel and you'll get the chance to
> >> share your
> >> opinions on IT & business topics through brief surveys -- and earn
> >> cash
> >> http://www.techsay.com/default.php?
> >> page=join.php&p=sourceforge&CID=DEVDEV
> >> _______________________________________________
> >> cx-oracle-users mailing list
> >> cx-...@li...
> >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >>
> >
> > -----------------------------------------------------------------------
> > --
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to
> > share your
> > opinions on IT & business topics through brief surveys -- and earn cash
> > http://www.techsay.com/default.php?
> > page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Why do Connection and SessionPool objects not share an Environment?

[Alex T. <al...@fi...>]

Hi Anthony,

On 19 Sep 2006, at 14:49, Anthony Tuininga wrote:

> May I ask why you asked the question in the first place?

I'll answer the last question first: I'm toying with the idea of  
'porting' cx_Oracle to be a C++ interface to OCI. It's really and  
exercise in teaching myself to use OCI. The practical result is I'm  
reading the source code, and trying to work out what it's doing.

The code I'm asking about puzzled me. It was either very subtle, or a  
potential bug. If it's subtle, I wanted to know. If it's a bug, I  
thought you'd want to know.


> If I understand correctly, however, the environment handle is the
> "master" handle and all of the other handles are children to it.

That seems reasonable. But if the environment handle is the "master" -  
how can it be right to make a new environment for a session handle  
that's been acquired from a pool that already HAS an environment?


> In order to establish thread safety you want to make sure that the
> handles from one thread are not used in another -- otherwise you need
> to establish locking and the like which has its own set of issues.

cx_Oracle's Environment struct contains an errorHandle as well as an  
env handle. Each thread certainly needs its own error handle. Perhaps a  
new Environment struct was made in order to make a new error handle,  
and the new env handle was just made by mistake?

I assume that it works OK, even if it's strictly incorrect.

If you think that cx_Oracle is wrong, then I might send you a patch, if  
you like.

-Alex

--

> On 9/18/06, Alex Tingle <al...@fi...> wrote:
>> Hello,
>>
>> This is a question about the C implementation of cx_Oracle. I've been
>> reading the source code and trying to understand how you are using  
>> OCI.
>>
>> When a Connection is acquired from a SessionPool, it creates a brand  
>> new
>> environment for itself, rather than using the environment that the
>> SessionPool already has. That seems odd to me. (See  
>> Connection_Acquire()
>> and Connection_Init() in Connection.c.)
>>
>> Can you explain why you create a new environment?
>>
>> Are you following the OCI documentation (if so where - I can't find
>> anything that suggests this) or have you established the method's
>> reliability by experience?
>>
>> (Sorry in advance if this is a stupid question.)
>>
>> -Alex
>>
>> --
>> :: Let me solve your problems: http://www.firetree.net/consulting/
>> :: alex.tingle AT firetree.net  +44-7901-552763
>>
>> ---------------------------------------------------------------------- 
>> ---
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>> share your
>> opinions on IT & business topics through brief surveys -- and earn  
>> cash
>> http://www.techsay.com/default.php? 
>> page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>
> ----------------------------------------------------------------------- 
> --
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] Why do Connection and SessionPool objects not share an Environment?

[Anthony T. <ant...@gm...>]

It is not a stupid question. I'm not absolutely certain of the answer,
either. :-)

If I understand correctly, however, the environment handle is the
"master" handle and all of the other handles are children to it. In
order to establish thread safety you want to make sure that the
handles from one thread are not used in another -- otherwise you need
to establish locking and the like which has its own set of issues.
Does that answer your question? May I ask why you asked the question
in the first place?

On 9/18/06, Alex Tingle <al...@fi...> wrote:
> Hello,
>
> This is a question about the C implementation of cx_Oracle. I've been
> reading the source code and trying to understand how you are using OCI.
>
> When a Connection is acquired from a SessionPool, it creates a brand new
> environment for itself, rather than using the environment that the
> SessionPool already has. That seems odd to me. (See Connection_Acquire()
> and Connection_Init() in Connection.c.)
>
> Can you explain why you create a new environment?
>
> Are you following the OCI documentation (if so where - I can't find
> anything that suggests this) or have you established the method's
> reliability by experience?
>
> (Sorry in advance if this is a stupid question.)
>
> -Alex
>
> --
> :: Let me solve your problems: http://www.firetree.net/consulting/
> :: alex.tingle AT firetree.net  +44-7901-552763
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Why do Connection and SessionPool objects not share an Environment?

[Alex T. <al...@fi...>]

Hello,

This is a question about the C implementation of cx_Oracle. I've been
reading the source code and trying to understand how you are using OCI.

When a Connection is acquired from a SessionPool, it creates a brand new
environment for itself, rather than using the environment that the
SessionPool already has. That seems odd to me. (See Connection_Acquire()
and Connection_Init() in Connection.c.)

Can you explain why you create a new environment?

Are you following the OCI documentation (if so where - I can't find
anything that suggests this) or have you established the method's
reliability by experience?

(Sorry in advance if this is a stupid question.)

-Alex

-- 
:: Let me solve your problems: http://www.firetree.net/consulting/
:: alex.tingle AT firetree.net  +44-7901-552763 

Re: [cx-oracle-users] cx_oracle and Oracle 9.0.1

[Anthony T. <ant...@gm...>]

The cx_Oracle 4.2 version should work just as well. Its just that you
need to use the Oracle 8i version, not the Oracle 9i version. I assume
that most people would move away from an unsupported Oracle version.
Not everyone does, though, obviously. ;-)

On 9/15/06, Jeanne d' Arc Halabi <Jeanned'Arc...@in...> wrote:
> The cx_Oracle 4.1 version works perfect.
>
> Many thanks for your help.
>
>
> -----Original Message-----
> From: cx-...@li...
> [mailto:cx-...@li...] On Behalf Of
> Henning von Bargen
> Sent: Friday, September 15, 2006 2:45 AM
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] cx_oracle and Oracle 9.0.1
>
>
> > HI,
> >
> > We have a Windows 2000 server, running Oracle version 9.0.1.
> > I have been
> > reading some of the previous posted messages, and wanted to
> > double check
> > if cx_oracle will work with the Oracle version. Python message below.
> >
> > >>> import cx_Oracle
> >
> > File "<stdin>", line 1m n ?
> >
> > ImportError: DLL load Failed: The specified procedure could not be
> > found.
> >
> > If this will not work, is there a workaround to connect Python to
> > Oracle?
> >
> > Thanks, JD
> >
>
> The OCI API changed from Oracle 8.0 to 8i to 9.0 to 9.2 to 10g...
>
> In order to use cx_Oracle, you should
> - have the correct ORACLE_HOME\bin in your PATH variable.
> - perhaps try out the cx_Oracle 4.1 version built with Oracle 8.1.7.
>
> HTH
> Henning
>
>
> ------------------------------------------------------------------------
> -
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> Interconex is committed to providing outstanding service to all of it clients, customers, and colleagues.  This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs and is free of any viruses.
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] cx_oracle and Oracle 9.0.1

[Jeanne d' A. H. <Jeanned'<Arc...@In...>]

The=20cx_Oracle=204.1=20version=20works=20perfect.

Many=20thanks=20for=20your=20help.


-----Original=20Message-----
From:=20c...@li...
[mailto:cx-...@li...]=20On=20Behalf=20Of
Henning=20von=20Bargen
Sent:=20Friday,=20September=2015,=202006=202:45=20AM
To:=20c...@li...
Subject:=20Re:=20[cx-oracle-users]=20cx_oracle=20and=20Oracle=209.0.1


>=20HI,
>=20
>=20We=20have=20a=20Windows=202000=20server,=20running=20Oracle=20version=20=
9.0.1.=20
>=20I=20have=20been
>=20reading=20some=20of=20the=20previous=20posted=20messages,=20and=20want=
ed=20to=20
>=20double=20check
>=20if=20cx_oracle=20will=20work=20with=20the=20Oracle=20version.=20Python=
=20message=20below.
>=20
>=20>>>=20import=20cx_Oracle
>=20
>=20File=20"<stdin>",=20line=201m=20n=20?
>=20
>=20ImportError:=20DLL=20load=20Failed:=20The=20specified=20procedure=20co=
uld=20not=20be
>=20found.
>=20
>=20If=20this=20will=20not=20work,=20is=20there=20a=20workaround=20to=20co=
nnect=20Python=20to
>=20Oracle?
>=20
>=20Thanks,=20JD
>=20

The=20OCI=20API=20changed=20from=20Oracle=208.0=20to=208i=20to=209.0=20to=20=
9.2=20to=2010g...

In=20order=20to=20use=20cx_Oracle,=20you=20should
-=20have=20the=20correct=20ORACLE_HOME\bin=20in=20your=20PATH=20variable.
-=20perhaps=20try=20out=20the=20cx_Oracle=204.1=20version=20built=20with=20=
Oracle=208.1.7.

HTH
Henning


------------------------------------------------------------------------
-
Using=20Tomcat=20but=20need=20to=20do=20more?=20Need=20to=20support=20web=20=
services,
security?
Get=20stuff=20done=20quickly=20with=20pre-integrated=20technology=20to=20m=
ake=20your=20job
easier
Download=20IBM=20WebSphere=20Application=20Server=20v.1.0.1=20based=20on=20=
Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642
_______________________________________________
cx-oracle-users=20mailing=20list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Interconex=20is=20committed=20to=20providing=20outstanding=20service=20to=20=
all=20of=20it=20clients,=20customers,=20and=20colleagues.=20=20This=20e-ma=
il=20has=20been=20scanned=20by=20MCI=20Managed=20Email=20Content=20Service=
,=20using=20Skeptic(tm)=20technology=20powered=20by=20MessageLabs=20and=20=
is=20free=20of=20any=20viruses.

Re: [cx-oracle-users] cx_oracle and Oracle 9.0.1

[Henning v. B. <H.v...@t-...>]

> HI,
>=20
> We have a Windows 2000 server, running Oracle version 9.0.1.=20
> I have been
> reading some of the previous posted messages, and wanted to=20
> double check
> if cx_oracle will work with the Oracle version. Python message below.
>=20
> >>> import cx_Oracle
>=20
> File "<stdin>", line 1m n ?
>=20
> ImportError: DLL load Failed: The specified procedure could not be
> found.
>=20
> If this will not work, is there a workaround to connect Python to
> Oracle?
>=20
> Thanks, JD
>=20

The OCI API changed from Oracle 8.0 to 8i to 9.0 to 9.2 to 10g...

In order to use cx_Oracle, you should
- have the correct ORACLE_HOME\bin in your PATH variable.
- perhaps try out the cx_Oracle 4.1 version built with Oracle 8.1.7.

HTH
Henning

[cx-oracle-users] cx_oracle and Oracle 9.0.1

[Jeanne d' A. H. <Jeanned'<Arc...@In...>]

HI,

=20

We=20have=20a=20Windows=202000=20server,=20running=20Oracle=20version=209.=
0.1.=20I=20have=20been
reading=20some=20of=20the=20previous=20posted=20messages,=20and=20wanted=20=
to=20double=20check
if=20cx_oracle=20will=20work=20with=20the=20Oracle=20version.=20Python=20m=
essage=20below.

=20

>>>=20import=20cx_Oracle

File=20"<stdin>",=20line=201m=20n=20?

ImportError:=20DLL=20load=20Failed:=20The=20specified=20procedure=20could=20=
not=20be
found.

=20

If=20this=20will=20not=20work,=20is=20there=20a=20workaround=20to=20connec=
t=20Python=20to
Oracle?

Thanks,=20JD

=20


Interconex=20is=20committed=20to=20providing=20outstanding=20service=20to=20=
all=20of=20it=20clients,=20customers,=20and=20colleagues.=20=20This=20e-ma=
il=20has=20been=20scanned=20by=20MCI=20Managed=20Email=20Content=20Service=
,=20using=20Skeptic(tm)=20technology=20powered=20by=20MessageLabs=20and=20=
is=20free=20of=20any=20viruses.

Re: [cx-oracle-users] type object matching - BINARY

[Anthony T. <ant...@gm...>]

On 9/13/06, Mario Frasca <mf...@zo...> wrote:
> On 2006-0913 11:33:04, Anthony Tuininga wrote:
> > [...] I won't be adding anything along the lines of
> > DBAPITypeObject() as it doesn't make any sense -- see above. If
> > that is something you really care about you can always create
> > your own Python wrapper.... :-)
>
> pity, I don't like needing wrappers, I prefer using things out of the box
> (sounds like the classical lazy developer), even if that involves needing
> to patch them.  I also don't like the style chosen in the db-api2:
> testing for equality and implementing it as a test for inclusion is
> quite confusing, to say the least.  subclassing seems more appropriate.
> as far as I understood, it has been implemented like this because this
> way you can define a CLOB to fall into a BINARY but also into a STRING...
> you can achieve this also by multiple inheritance, but maybe it has been
> considered overkill, less efficient, I don't know, just making hypoteses.

I don't like wrappers either -- but the great goal of being able to
simply drop in a database driver just isn't there. There are too many
discrepancies and the DB-API does not cover them (and doesn't really
try to, either). Its been great for making the interfaces __similar__
-- and that's good enough for me, for now.

> I had seen there was some movement on db-sig and a possible new version
> of the db-api agreements.  until then, my library will have to cope with
> so many different interpretations of the directives...  hope this better
> db-api3 comes soon!

Agreed.

> greetings,
> Mario

Re: [cx-oracle-users] type object matching - BINARY

[Mario F. <mf...@zo...>]

On 2006-0913 11:33:04, Anthony Tuininga wrote:
> [...] I won't be adding anything along the lines of
> DBAPITypeObject() as it doesn't make any sense -- see above. If
> that is something you really care about you can always create
> your own Python wrapper.... :-)

pity, I don't like needing wrappers, I prefer using things out of the box
(sounds like the classical lazy developer), even if that involves needing
to patch them.  I also don't like the style chosen in the db-api2:
testing for equality and implementing it as a test for inclusion is
quite confusing, to say the least.  subclassing seems more appropriate.
as far as I understood, it has been implemented like this because this
way you can define a CLOB to fall into a BINARY but also into a STRING...
you can achieve this also by multiple inheritance, but maybe it has been
considered overkill, less efficient, I don't know, just making hypoteses.

I had seen there was some movement on db-sig and a possible new version
of the db-api agreements.  until then, my library will have to cope with
so many different interpretations of the directives...  hope this better
db-api3 comes soon!

greetings,
Mario

-- 
Nie udało się wysłać wiadomości pod numer: +4851482xxxx
Użytkownik nie ma aktywnej usługi SMS z Internetu, SMS nie został wysłany

Re: [cx-oracle-users] type object matching - BINARY

[Anthony T. <ant...@gm...>]

The PEP is very vague on the types and their handling. It specifies
only BINARY and then proceeds to indicate that LONG (long strings in
Oracle) should be based on this as well?? That doesn't make any sense
at all. Note that CLOB would fall into "BINARY" as far as the PEP is
concerned but as far as Oracle is concerned that makes no sense. I've
taken the approach that the DB API PEP should be followed as much as
possible -- except where following it would make the interface to
Oracle difficult to follow/understand for anyone who understands
Oracle. In addition, binary data is rarely used in databases so using
setinputsizes() to specify the type directly works quite well and
doesn't involve (IMHO) brain damage. :-)

I'd be happy to suggest a change to the PEP that would work for other
interfaces as well -- I know there are a number of interfaces that
deal with input/output in a much more controlled fashion but none of
this has gone into the PEP. I subscribe to the db-sig mailing list as
well and there is significant resistance to make any changes at all.

If you have any further suggestions I'd be happy to entertain them. I
won't be adding anything along the lines of DBAPITypeObject() as it
doesn't make any sense -- see above. If that is something you really
care about you can always create your own Python wrapper.... :-)

On 9/13/06, D.R.   Boxhoorn <da...@as...> wrote:
>
> Hoi Mario,
>
> You are right, but I'm happy to leave the C implementation to Anthony.
> Personally, I very much dislike the whole idea of using the equivalence
> operator on types in the way suggested in the pep. For example
>
>    BINARY =3D=3D CLOB
>
> To me BINARY and CLOB are not equivalent and never will be.
> More natural would be
>
>    issubclass(CLOB, BINARY)
>
> (Now you now what C and B in the help() for issubclass() stand for ;)
> but even so, it's usually better to stay as far as possible from discussi=
ons
> on such matters.
>
> Cheers,
>
>                                                    Danny
>
> On Wed, Sep 13, 2006 at 05:41:30PM +0200, Mario Frasca wrote:
> > Hi Danny,
> >
> > ... thinking a bit...  but what you describe is what I would expect to
> > find already in cx_Oracle...  I expected BINARY to have been defined
> > as DBAPITypeObject(cx_Oracle.BLOB, cx_Oracle.LOB, cx_Oracle.CLOB) (or
> > something similar, maybe including LONG_STRING?)...  I would even have =
a
> > look at the sources, but the Python/C bindings still scare me a bit awa=
y.
> >
> > if there was a cx_Oracle.py source, I would have added the following
> > line:
> >
> > BINARY =3D DBAPITypeObject(BLOB, LOB, CLOB)
> >
> > made some tests, submitted a patch.
> >
> > as I said, I'm a very bad educator...
> >
> > regards,
> > Mario
> >
> > --
> >  je vais m'envoyer une lettre de felicitation.
> >  Des felicitations, =E7a fait toujours plaisir,
> >  surtout de la part de quelqu'un qu'on aime bien.
> >
> > -----------------------------------------------------------------------=
--
> > Using Tomcat but need to do more? Need to support web services, securit=
y?
> > Get stuff done quickly with pre-integrated technology to make your job =
easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geron=
imo
> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job ea=
sier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] type object matching - BINARY

[D.R. B. <da...@as...>]

Hoi Mario,

You are right, but I'm happy to leave the C implementation to Anthony.
Personally, I very much dislike the whole idea of using the equivalence
operator on types in the way suggested in the pep. For example

   BINARY =3D=3D CLOB

To me BINARY and CLOB are not equivalent and never will be.
More natural would be

   issubclass(CLOB, BINARY)

(Now you now what C and B in the help() for issubclass() stand for ;)
but even so, it's usually better to stay as far as possible from discussi=
ons
on such matters.

Cheers,

                                                   Danny

On Wed, Sep 13, 2006 at 05:41:30PM +0200, Mario Frasca wrote:
> Hi Danny,
>=20
> ... thinking a bit...  but what you describe is what I would expect to
> find already in cx_Oracle...  I expected BINARY to have been defined
> as DBAPITypeObject(cx_Oracle.BLOB, cx_Oracle.LOB, cx_Oracle.CLOB) (or
> something similar, maybe including LONG_STRING?)...  I would even have =
a
> look at the sources, but the Python/C bindings still scare me a bit awa=
y.
>=20
> if there was a cx_Oracle.py source, I would have added the following
> line:
>=20
> BINARY =3D DBAPITypeObject(BLOB, LOB, CLOB)
>=20
> made some tests, submitted a patch.
>=20
> as I said, I'm a very bad educator...
>=20
> regards,
> Mario
>=20
> --=20
>  je vais m'envoyer une lettre de felicitation.
>  Des felicitations, =E7a fait toujours plaisir,=20
>  surtout de la part de quelqu'un qu'on aime bien.
>=20
> -----------------------------------------------------------------------=
--
> Using Tomcat but need to do more? Need to support web services, securit=
y?
> Get stuff done quickly with pre-integrated technology to make your job =
easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geron=
imo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] type object matching - BINARY

[Mario F. <mf...@zo...>]

Hi Danny,

... thinking a bit...  but what you describe is what I would expect to
find already in cx_Oracle...  I expected BINARY to have been defined
as DBAPITypeObject(cx_Oracle.BLOB, cx_Oracle.LOB, cx_Oracle.CLOB) (or
something similar, maybe including LONG_STRING?)...  I would even have a
look at the sources, but the Python/C bindings still scare me a bit away.

if there was a cx_Oracle.py source, I would have added the following
line:

BINARY = DBAPITypeObject(BLOB, LOB, CLOB)

made some tests, submitted a patch.

as I said, I'm a very bad educator...

regards,
Mario

-- 
 je vais m'envoyer une lettre de felicitation.
 Des felicitations, ça fait toujours plaisir, 
 surtout de la part de quelqu'un qu'on aime bien.

Re: [cx-oracle-users] type object matching - BINARY

[D.R. B. <da...@as...>]

Hello Mario,

The pep that you refer to, http://www.python.org/dev/peps/pep-0249/
contains the answer to your question, although I'll admit that it's not
obvious.
In the pep you'll find a helper class DBAPITypeObject without an explanation
on how to use it.
A simple example hopefully explains what you'll have to do

   >>> import cx_Oracle

   >>> print DBAPITypeObject(cx_Oracle.CLOB)   == DBAPITypeObject(cx_Oracle.BINARY, cx_Oracle.BLOB, cx_Oracle.CLOB)
   True

   >>> print DBAPITypeObject(cx_Oracle.NUMBER) == DBAPITypeObject(cx_Oracle.BINARY, cx_Oracle.BLOB, cx_Oracle.CLOB)
   False

So, on the left side of the comparison you instantiate a DBAPITypeObject with
the type identifier that you obtained from the cursor description.
On the right side you instantiate a DBAPITypeObject with _all_ the type
identifiers that you think behave the same as one of the type identifiers
mentioned in the pep. In the above example, cx_Oracle.BINARY cx_Oracle.BLOB
and cx_Oracle.CLOB are all considered BINARY.
The DBAPITypeObject will make sure that the equivalence operator will
behave as you expect. Of course, to make the code independent of the
database backend you'll have to do a bit more, but this should explain how
to do it.

Good luck,

                                                   Danny


On Wed, Sep 13, 2006 at 05:07:41PM +0200, Mario Frasca wrote:
> On 2006-0913 08:09:50, Anthony Tuininga wrote:
> > To answer your question: Oracle has three types that hold binary
> > data -- RAW, LONG RAW and BLOB. They are all quite different
> > [...]  Please feel free to educate me if necessary. :-)
> 
> I'm a very bad educator! :)  I hope I will manage to explain myself
> at least.
> 
> let's start from the problem I'm trying to solve...  I need to perform a
> SELECT DISTINCT <fields> FROM ... and I don't want to make any
> assumptions about the table...  I know that the table may contain LOBs
> and on them Oracle complains that it cannot perform a comparison.  to be
> safe, I want to filter out all ''BINARY'' fields, in the sense, all
> those fields where comparison is not possible or would take too long a
> time...  as stated in the PEP249:
> 
> BINARY
>    This type object is used to describe (long) binary columns
>    in a database (e.g. LONG, RAW, BLOBs).
> 
> this 'BINARY' is not a type, but a type object, something quite abstract
> that is used to cathegorize the concrete types in the database into
> db-api2 concepts.  back to my question, at the very least 
> cx_Oracle.BINARY == cx_Oracle.BLOB
> should check True...  my interpretation is that also LOBs and CLOBs are
> cathegorized as BINARY...  but this is my interpretation...
> 
> thanks for your time,
> Mario
> 
> -- 
> ... hinc sequitur, unamquamque rem naturalem tantum iuris ex natura habere,
>     quantum potentiae habet ad existendum et operandum ...
>   -- Baruch de Spinoza, TRACTATUS POLITICUS
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] type object matching - BINARY

[Mario F. <mf...@zo...>]

On 2006-0913 08:09:50, Anthony Tuininga wrote:
> To answer your question: Oracle has three types that hold binary
> data -- RAW, LONG RAW and BLOB. They are all quite different
> [...]  Please feel free to educate me if necessary. :-)

I'm a very bad educator! :)  I hope I will manage to explain myself
at least.

let's start from the problem I'm trying to solve...  I need to perform a
SELECT DISTINCT <fields> FROM ... and I don't want to make any
assumptions about the table...  I know that the table may contain LOBs
and on them Oracle complains that it cannot perform a comparison.  to be
safe, I want to filter out all ''BINARY'' fields, in the sense, all
those fields where comparison is not possible or would take too long a
time...  as stated in the PEP249:

BINARY
   This type object is used to describe (long) binary columns
   in a database (e.g. LONG, RAW, BLOBs).

this 'BINARY' is not a type, but a type object, something quite abstract
that is used to cathegorize the concrete types in the database into
db-api2 concepts.  back to my question, at the very least 
cx_Oracle.BINARY == cx_Oracle.BLOB
should check True...  my interpretation is that also LOBs and CLOBs are
cathegorized as BINARY...  but this is my interpretation...

thanks for your time,
Mario

-- 
... hinc sequitur, unamquamque rem naturalem tantum iuris ex natura habere,
    quantum potentiae habet ad existendum et operandum ...
  -- Baruch de Spinoza, TRACTATUS POLITICUS

Re: [cx-oracle-users] type object matching - BINARY

[Anthony T. <ant...@gm...>]

To answer your question: Oracle has three types that hold binary data
-- RAW, LONG RAW and BLOB. They are all quite different as far as
Oracle is concerned so some means of dealing with that is rather
important -- they cannot simply be the same type. If you're dealing
with Oracle you'll have to deal with this issue -- there is no
database independent way to deal with it that I am aware of. Please
feel free to educate me if necessary. :-)

In addition, Python doesn't really have a concept of "binary" data --
it stores everything in "strings". Its just that some of those
"strings" are not null terminated. :-) I've taken advantage of that
and not bothered with a "Binary()" constructor since I figured that
you can create strings in Python just fine already. Use
setinputsizes() to specify to Oracle how to interpret that data.

BTW, CLOB is not binary data but text data and LOB is simply a way of
indicating that a LOB (Large Object) indicator is present and nothing
more.

Does that answer your questions?

On 9/13/06, Mario Frasca <mf...@zo...> wrote:
> I've a question about this behaviour:
>
> >>> cx_Oracle.BINARY == cx_Oracle.BINARY
> True
> >>> cx_Oracle.BINARY == cx_Oracle.LOB
> False
> >>> cx_Oracle.BINARY == cx_Oracle.BLOB
> False
> >>> cx_Oracle.BINARY == cx_Oracle.CLOB
> False
>
> is it correct?  after reading the pep-249 at
> http://www.python.org/dev/peps/pep-0249/, I would expect all of them to
> check True.  otherwise, how do I check if a field is holding a binary
> object in a db-api2 compatible way?
>
> I've checked pgdb and MySQLdb and only MySQLdb recognizes a binary
> object as above.
>
> how to test:
>
> import cx_Oracle, open a connection, associate cr to a cursor.
>
> >>> cr.execute('create table test(pk_test integer not null primary key, v_text clob)')
> >>> cr.execute('select * from test')
> [<cx_Oracle.NUMBER object at 0x40344ca0>, <cx_Oracle.CLOB object at 0x40311bd0>]
> >>> cr.description[1][1]
> <type 'cx_Oracle.CLOB'>
> >>> cr.description[1][1] == cx_Oracle.BINARY
> False
> >>>
>
> regards,
> MF
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] type object matching - BINARY

[M. A. W. <maw...@gm...>]

this is the code i used to get values

import cx_Oracle
con = cx_Oracle.connect("user/userpassword@xe")
cur = con.cursor()
cur.execute("select * from tab")

res = cur.fetchall()

for rec in res:
 print rec[0] ,"--->", rec[1]

Just a test Code


On 9/13/06, Mario Frasca <mf...@zo...> wrote:
>
> I've a question about this behaviour:
>
> >>> cx_Oracle.BINARY == cx_Oracle.BINARY
> True
> >>> cx_Oracle.BINARY == cx_Oracle.LOB
> False
> >>> cx_Oracle.BINARY == cx_Oracle.BLOB
> False
> >>> cx_Oracle.BINARY == cx_Oracle.CLOB
> False
>
> is it correct?  after reading the pep-249 at
> http://www.python.org/dev/peps/pep-0249/, I would expect all of them to
> check True.  otherwise, how do I check if a field is holding a binary
> object in a db-api2 compatible way?
>
> I've checked pgdb and MySQLdb and only MySQLdb recognizes a binary
> object as above.
>
> how to test:
>
> import cx_Oracle, open a connection, associate cr to a cursor.
>
> >>> cr.execute('create table test(pk_test integer not null primary key,
> v_text clob)')
> >>> cr.execute('select * from test')
> [<cx_Oracle.NUMBER object at 0x40344ca0>, <cx_Oracle.CLOB object at
> 0x40311bd0>]
> >>> cr.description[1][1]
> <type 'cx_Oracle.CLOB'>
> >>> cr.description[1][1] == cx_Oracle.BINARY
> False
> >>>
>
> regards,
> MF
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] type object matching - BINARY

[Mario F. <mf...@zo...>]

I've a question about this behaviour:

>>> cx_Oracle.BINARY == cx_Oracle.BINARY
True
>>> cx_Oracle.BINARY == cx_Oracle.LOB
False
>>> cx_Oracle.BINARY == cx_Oracle.BLOB
False
>>> cx_Oracle.BINARY == cx_Oracle.CLOB
False

is it correct?  after reading the pep-249 at
http://www.python.org/dev/peps/pep-0249/, I would expect all of them to
check True.  otherwise, how do I check if a field is holding a binary
object in a db-api2 compatible way?

I've checked pgdb and MySQLdb and only MySQLdb recognizes a binary
object as above.

how to test:

import cx_Oracle, open a connection, associate cr to a cursor.

>>> cr.execute('create table test(pk_test integer not null primary key, v_text clob)')
>>> cr.execute('select * from test')
[<cx_Oracle.NUMBER object at 0x40344ca0>, <cx_Oracle.CLOB object at 0x40311bd0>]
>>> cr.description[1][1]
<type 'cx_Oracle.CLOB'>
>>> cr.description[1][1] == cx_Oracle.BINARY
False
>>> 

regards,
MF

[cx-oracle-users] ImportError: /lib/libc.so.6: version `GLIBC_2.4' not found (required by /usr/lib/python2.3/lib-dynload/cx_Oracle.so)

[M. A. W. <maw...@gm...>]

it took me 2 days to solve the error which i was getting while importing
cx_Oracle
error was

ImportError: /lib/libc.so.6: version `GLIBC_2.4' not found (required by
/usr/lib/python2.3/lib-dynload/cx_Oracle.so)

Solution on Debian

1) apt-get install python2.3-dev (to get config files )

2) set the ORACLE_HOME path on debian root user ( i put in .bashrc file)
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
  (as i installed oracle 10 g on my debian machine)

3) i downloaded the source from
http://www.cxtools.net/default.aspx?nav=cxorlb
(Source code only)
4) tar  xvzf cx_Oracle-4.2.tar.gz

5) cd  cx_Oracle-4.2

6) python  setup.py  build
7)python  setup.py  install

8) on my machine it loaded the file "cx_Oracle.so" at
/usr/lib/python2.3/site-packages
9) but my python module path was at /usr/lib/python2.3/lib-dynload/
so i copied cx_Oracle.so at the above location

cp /usr/lib/python2.3/site-packages/cx_Oracle.so
/usr/lib/python2.3/site-packages

then it worked fine

Mukhtar (maw...@gm...)