• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

multiple oracle drivers in jboss 3.2.5

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 538
Hibernate Eclipse IDE Tomcat Server
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic