multiple oracle drivers in jboss 3.2.5

[Brent Falk]

We have an application that will be connecting to two different Oracle databases. One of these databases is an Oracle 9i database, and the other is Oracle 8. We are currently accessing the 9i database using the 10g driver. While this driver is backwards compatible with Oracle 9i, it does not appear to support Oracle 8. My question is this: is it possible in Jboss to deploy different container managed datasources with different Oracle drivers? My concern is that there will be classpath issues with the two versions of the driver, since the driver class is the same for both. Any help or references would be much appreciated.

thanks,
Brent

[Eric Lemaitre]

Hi !

I believe no issue, I see 3 ways :

_ standard Oracle driver which works for both Oracle-9i & 8i, this is what I use in my company.

_ use applications packaged within EAR owning a RAR for holding database driver, so each application will be able to use its own driver within its own context which is root of EAR.

_ use datasources accessible through JNDI, each can own its own driver which shouldn't interfere with others.

Best regards.