I have tried a number of things; switching classes12.zip out for a different
 file, deleting and remaking datasources, and finally switching to ojdbc14.j
ar in WAS6 in my classpath.  With ojdbc14.jar in the classpath, I get a new 
and equally bizarre error:


Test connection failed for data source <My Data Source Name> on server dmgr 
at node dmgr_wfadc020 with the following exception: java.sql.SQLException: j
ava.lang.LinkageError: Class oracle/jdbc/ttc7/MAREngine violates loader cons
traints.

[ Post a follow-up to this message ]

two things:
1) you should be using ojdbc14.jar, and not classes12.zip.  the later is
used only with jdk13, and is NOT certified by Oracle to run with JDK14, and
15.
2) from the error, I see that you are using T2 which required more than just
the ojdbc14.jar file, it also requires Oracle libraries to be present in
your path which depends on the OS you are running:

export ORACLE_HOME:<where oracle is installed>
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32 ==> this is for Solaris
export SHLIB_PATH=$ORACLE_HOME/lib32: ==> this is for hp env
export LD_LIBRARY_PATH=$ORACLE_HOME/lib ==> this is for Linux
export
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip:$ORACLE_HOME/jdbc/lib/nls_char
set12.zip: note that if the jdk level is 1.4.1 or higher (e.g. WAS5.1 and
beyond) then you must use ojdbc14.jar instead of classes12.zip)


At this point to validate things, I would suggest you try the thin client
first (i.e. set your url to the following format:
jdbc:oracle:thin:@<hostname>:<portnumber>:<databasename>  for example
jdbc:oracle:thin:@localhost:1521:IBM).

Hope that helps!!!



<tate.austin@wachovia.com> wrote in message
news:1791313593.1141239591739.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
> I have tried a number of things; switching classes12.zip out for a
different file, deleting and remaking datasources, and finally switching to
ojdbc14.jar in WAS6 in my classpath.  With ojdbc14.jar in the classpath, I
get a new and equally bizarre error:
>
> Test connection failed for data source <My Data Source Name> on server
dmgr at node dmgr_wfadc020 with the following exception:
java.sql.SQLException: java.lang.LinkageError: Class
oracle/jdbc/ttc7/MAREngine violates loader constraints.
>

[ Post a follow-up to this message ]