Weblogic 7.0 , MySQL 3.23 [JDBC Connection Pools]

[Mannu Sureka]

i am using weblogic 7.0 and MySQL 3.23 and right now my objective is to create, configure and test a JDBC
connection pool using the Administrative console.
Here is what i have done till now
- set the classpath of the MySQL driver in the startWLS.cmd like this
SET MYSQL_DRIVER=C:\mysqldriver\mysql-connector-java-2.0.14\mysql-connector-java-2.0.14-bin.jar
set CLASSPATH=%MYSQL_DRIVER%;%CLASSPATH%
- using the weblogic administrative console i have created a new connection pool named as
testpool.
- Here is what i have in the testpool general tab
Name: testpool
URL: jdbc:mysql//localhost:3306/test (test is the name of the database in mysql)
Driver Classname: org.gjt.mm.mysql.Driver
I have not entered any Properties, ACL Name, Password or Open String Password.
- Now i go the the Testing tab and enter a name of a table in my test database and click on Apply
and on the command window i am getting the following exception
java.sql.SQLException No suitable driver

[Angela Margot]

Recently I have become intimately familiar with the connections and connection pools in Weblogic. I haven't used a MySQL database, but have used an Oracle and a Pointbase for queries.
The URLs I used were in the format:
jdbc racle:thin:@152.252.12.23:1521:mydb
Yours is:
jdbc:mysql//localhost:3306/test
So maybe it should be entered as:
jdbc:mysql:@localhost:3306:test
(just guessing at this)
Also, be sure that your driver is in Weblogic (like Oracle is in the classes12.zip file). Read some of the Weblogic documentation, you might have to include a file in the weblogic directory.

[Mannu Sureka]

Hello Leilani,
Thanks for your reply. I will try both the URLs (jdbc:mysql//localhost:3306/test and
jdbc:mysql:@localhost:3306:test ) but i guess i have to first get the weblogic server find the MySQL driver .jar files.
I included the MySQL driver jar files in the weblogic server's classpath by editing the startWLS.cmd file. But is there someother way to include an external library or jar file on weblogic server's classpath.
Thanks,
Ashish.