aspose file tools*
The moose likes JBoss/WildFly and the fly likes Problem with different oracle JDBC drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Problem with different oracle JDBC drivers" Watch "Problem with different oracle JDBC drivers" New topic
Author

Problem with different oracle JDBC drivers

Ali Gohar
Ranch Hand

Joined: Mar 18, 2004
Posts: 572
Hi Everyone,

I have Jboss-3.5.2 installed on my machine and i have different web applications deployed on it as .war files. Some of the applications connect with Oracle 8i databases whereas some of them needs to connect with Oracle 10g.

Every web app has its own oracle jdbc driver in its class path. But as jdbc drivers are different for 8i and 10g, so it creates problem when i deploy all these applications at the same time on the AS.

I think JBoss loads one of the driver classes and use it for all the connections to be made by all the applications.

Can anybody tell me how can i get rid of this problem? how can i run both applications with oracle 8i and 10g at the same time?

Thanks in advance
KArol Muszynski
Ranch Hand

Joined: Aug 09, 2005
Posts: 45
Ali,

maybe this tip will be helpful http://www.devx.com/tips/Tip/29164

Best Regards,
KArol Muszynski
Ali Gohar
Ranch Hand

Joined: Mar 18, 2004
Posts: 572
Hi,

Thanks for the reply, i have tried that solution but i am using JNDI Connection pooling through JBOSS JNDI Connection Pooling and i am getting the error that No class definition found "com.piratepete.jndi.JndiUtil"

any idea?

Thanks
KArol Muszynski
Ranch Hand

Joined: Aug 09, 2005
Posts: 45
Ali,

is "com.piratepete.jndi.JndiUtil" class yours ? Or it comes from outside package !?

Remember to put all jars required by Your application to WEB-INF/lib folder in You war file. After changing this parameter, JBoss uses different classloader mechanism.

Best Regards,
KArol Muszynski
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem with different oracle JDBC drivers
 
Similar Threads
JDBC WITH ORACLE 8i
Regarding Oracle thin and thick drivers
External tables and CallableStatement
Web Application Class Loader and Weblogic
JDBC using Oracle with Servlets