-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ziggy,

On 11/14/2009 12:52 PM, Ziggy wrote:
> Because of this i couldnt really use the connection object provided via
> JNDI.

Sure you can: just use the getInnermostDelegate method to get the "real"
Connection object. You ought to be able to cast that to
OracleConnection. It looks like you're already doing that.

> The other problem i had is that when i had two connection types, i was
> getting lots of problems with the way the driver was being loaded. I think
> this was because Tomcat was already loading the jdbc driver via common/lib
> and i had the driver in WEB-INF/lib it was not happy about it.

Right: don't do that. Allow Tomcat to load the Oracle driver from
common/lib (because it's necessary if you want to have Tomcat set up
your JNDI DataSource) and remove it from your webapp (because it will
interfere).

> Anyway now i
> only have the driver in common/lib and use just jndi using the underlying
> connection delegate.

Perfect (other than the use of the Oracle-specific stuff).

>> How about java.sql.Array instead? I guess it depends on what you're
>> doing with it...
> 
> Does this map to an Oracle Type?

Presumably, the java.sql.Array type is usable in place of Oracle's
oracle.sql.ARRAY type. You just have to figure out how. Since I can't
see your code, it's unclear what your code is trying to do.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAksAGl4ACgkQ9CaO5/Lv0PC3kQCglpvdmZkPOXLJ+e4tnVAB3E4g
uTcAnR3dEdYPNAxPbXoq1r0rIClR0BRn
=j/eI
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to