I am trying to establish a connection to mysql thru weblogic 8.1. I have configured mysql and added the mysql jdbc driver to the classpath. When I try to create a connection pool weblogic gives me the following error - 'jdbc driver not in classpath'. I have rechecked my classpath. Everything seems to be in place. Can somebody please help?
i have the same problem and it simply dont work in my startWLS.cmd file i added this line set MYSQL_CLASSPATH=%WL_HOME%\server\lib\mysql-connector-java-3.1.11-bin.jar and replaced this line set CLASSPATH=%MYSQL_CLASSPATH%;%JAVA_HOME%\lib\tools.jar;%WL_HOME%\server\lib\weblogic_sp.jar;%WL_HOME%\server\lib\weblogic.jar;%CLASSPATH
but according to doc this file istn read att all (at least by default bewWL installation) instead the file %WL_HOME%\samples\domains\workshop\startWebLogic.cmd is read so i placed thos two lines there too and again nothing happand. hence in %WL_HOME%\samples\domains\workshop\startWebLogic.cmd
is one line echo CLASSPATH=%CLASSPATH%
but when i look at the output of cmd(which starts the beaWL) there is no C:\mysqlconnectorjava3111\mysql-connector-java-3.1.11-bin.jar entry in the classpath although i set it via rightclick on mycomputer->propertis->advenced->env.vars...
i simply dont know which classpath is takeing and where to set it
im running beaWL 8.1 sp3 on w2k sp3
i was able to make a connection via JDBC in DBVisualiser and there C:\mysqlconnectorjava3111\mysql-connector-java-3.1.11-bin.jar worrked. But there was clear question wher to look for jdbc-driver, so i pointed to C:\mysqlconnectorjava3111\mysql-connector-java-3.1.11-bin.jar and there was no problem. But which(where) is the classpath for beaWL?
please, can anyone help? [ October 21, 2005: Message edited by: Ner min ]
Add driver jar file into the \\beasp5\weblogic81\samples\domains\workshopset\DomainEnv.cmd
for eg. set CLASSPATH=%PRE_CLASSPATH%;%WEBLOGIC_CLASSPATH%;%CLASSPATH%;%POST_CLASSPATH%;%WLP_POST_CLASSPATH%;c:\mysql\mysql_jdbc.jar
after adding the jar file into the classpath you can see the Weblogic console whether your newly added jar files is listed into the server classpath or you can print the classpath using echo %classpath%
weblogic actually edits the startWeblogic.sh/.bat script, so it's probably not a good idea to put anything in there. setDomain.env is a good spot to put your check, you can also put your reference in the /bea/user_projects/domains/wls/_cfgwiz_donotdelete/startscript.xml, which gets merged at runtime as well, ie: