-----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