File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

multiple oracle drivers in jboss 3.2.5

 
Brent Falk
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 538
Eclipse IDE Hibernate Tomcat Server
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic