File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JBoss/WildFly and the fly likes multiple oracle drivers in jboss 3.2.5 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "multiple oracle drivers in jboss 3.2.5" Watch "multiple oracle drivers in jboss 3.2.5" New topic
Author

multiple oracle drivers in jboss 3.2.5

Brent Falk
Greenhorn

Joined: Feb 23, 2004
Posts: 2
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
Ranch Hand

Joined: Jul 03, 2004
Posts: 538

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.


Eric LEMAITRE
CNAM IT Engineer, MS/CS (RHCE, RHCX, SCJA, SCJP, SCJD, SCWCD, SCBCD, SCEA, Net+)
Free Online Tutorials: http://www.free-tutorials-online.net/
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: multiple oracle drivers in jboss 3.2.5