WebSphere Application Server - WAS 6.x --JDBC Resources

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Application Server > August 2006 > WAS 6.x --JDBC Resources





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author WAS 6.x --JDBC Resources

2006-08-18, 7:39 am

Hello...
we have a 10.1 client installed and Oracle JDBC driver defined at Cell Scope.
For Technical reasons we have installed a Oracle 10.2 client on the same box as well...and Oracle JDBC driver defined at App.Server level.
One of our applications has to use the 10.2 Client but unfortunately the 10.1 client has a higher precedence over the 10.2 client and the database connections are initialised through the 10.1 client & classes are loaded from the 10.1 client.It is ND envir
onment with 2 Nodes on the Same Machine...

we have tried the following :
(1)Reversing the Class loader from Parent_First to Parent_Last!!
(2)Setting up dataSources at different Scope levels.

Questions:
(1) is it feasible to have 2 Oracle JDBC Drivers which has Same Implementation Class Name at the same or differnent Scope levels?
(2) is there a way to change the Precedence of the Classes that are Loaded from a Resource perspective?

Any help is highly appreciated...!!!


Ben_

2006-08-18, 7:39 am

Why not use the same Oracle 10.2 driver to conect to the 10.1 and 10.2
databases ?

In my experience, this doesn't cause problems and should work:
"
The JDBC drivers are certified to work with the currently supported versions
of the Oracle Database
"
http://download-uk.oracle.com/docs/...ta.htm#i1008205


Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com