cx-oracle-users

RE: [cx-oracle-users] cx_Oracle 4.1.1

[Amaury F. <Ama...@gl...>]

Hello Anthony,

Thanks for this new release of cx_Oracle.

However, I am surprised by this change:

	#ifdef OCI_ATTR_MODULE
	#define ORACLE_10G
	#elif OCI_FNCODE_STMTRELEASE
	#define ORACLE_9I
	#endif

This implies that with Oracle 10, session pools and timestamps=20
are no more available... I don't think this was intended.

I can see two possible workarounds:

- When compiling with Oracle 10, both ORACLE_10G and ORACLE_9I=20
are defined. This is what I have done in my local copy.

- We could change the define to look like a version number:
	#ifdef OCI_ATTR_MODULE
	#define CX_OCI_VERSION 1000
	#elif OCI_FNCODE_STMTRELEASE
	#define CX_OCI_VERSION 901
	#else
	#define CX_OCI_VERSION 815
	#endif
And use it this way:
	#if CX_OCI_VERSION >=3D 901
	...session pools...
	#endif

Just to keep

--=20
Amaury Forgeot d'Arc
Ubix Development
www.ubitrade.com

Re: [cx-oracle-users] cx_Oracle 4.1.1

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

Oops. Good catch. I'll make another release of cx_Oracle with this
patch (the first one you suggested) shortly. We don't use session
pools with Oracle 10g (yet) and the test suite simply looks for the
presence of the attribute.... :-) I really wish Oracle would provide
some indication of what client version was in use!

On 12/19/05, Amaury Forgeotdarc <Ama...@gl...> wrote:
> Hello Anthony,
>
> Thanks for this new release of cx_Oracle.
>
> However, I am surprised by this change:
>
>         #ifdef OCI_ATTR_MODULE
>         #define ORACLE_10G
>         #elif OCI_FNCODE_STMTRELEASE
>         #define ORACLE_9I
>         #endif
>
> This implies that with Oracle 10, session pools and timestamps
> are no more available... I don't think this was intended.
>
> I can see two possible workarounds:
>
> - When compiling with Oracle 10, both ORACLE_10G and ORACLE_9I
> are defined. This is what I have done in my local copy.
>
> - We could change the define to look like a version number:
>         #ifdef OCI_ATTR_MODULE
>         #define CX_OCI_VERSION 1000
>         #elif OCI_FNCODE_STMTRELEASE
>         #define CX_OCI_VERSION 901
>         #else
>         #define CX_OCI_VERSION 815
>         #endif
> And use it this way:
>         #if CX_OCI_VERSION >=3D 901
>         ...session pools...
>         #endif
>
> Just to keep
>
> --
> Amaury Forgeot d'Arc
> Ubix Development
> www.ubitrade.com
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_idv37&alloc_id=16865&opclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>