users@glassfish.java.net

JDBC-Connection-Pool driver versions

From: Dougal Fraser <Dougal.Fraser_at_Sun.COM>
Date: Tue, 21 Jul 2009 10:42:56 +1200
Hi everybody,
I have a need to connect to Oracle databases of different versions.  Because of various Oracle quirks, I need to use different versions of the oracle JDBC driver.  Both versions have the same driver class name and use URLs of the same format.
I use components that refer to database resources using JNDI.  Is it possible to specify classpaths individually for JDBC connection pools?

At the moment my current solution is to put system components requiring the old version into a separate domain, which is undesirable.

Regards,
Dougal
--
Dougal Fraser
SOA Architect

Sun Microsystems, Inc.
New Zealand
Phone x69822/+64 9 9766822
Mobile +64 21 2711179
Email Dougal.Fraser@Sun.COM