1. Home
  2. Portal
  3. Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

34561, modified 18 Years ago.
Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
New Member Posts: 14 Join Date: 8/8/07 Recent Posts
I put the mysql-connector-java-5.1.5-bin.jar into the %TOMCAT_HOME%/common/lib/etc folder

Changed the root.xml file to only use mysql database.

./version.sh outputs
Using CATALINA_BASE: /usr/local/liferay
Using CATALINA_HOME: /usr/local/liferay
Using CATALINA_TEMPDIR: /usr/local/liferay/temp
Using JRE_HOME: /usr/java/jdk1.6.0_04/jre
Server version: Apache Tomcat/6.0.14
Server built: Jul 20, 2007
Server number: 6.0.14.0
OS Name: Linux
OS version: 2.6.16.54-0.2.5-default
Architecture: i386
JVM Version: 1.6.0_04-b12
JVM Vendor: Sun Microsystems Inc.


When I startup the portal i get:

java.lang.IllegalStateException at org.apache.calalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1244)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
at org.apache.activemq.broker.BrokerService.stop(BrokerService.java:440)
at org.apache.activemq.broker.BrokerService.containerShutdown(BrokerService.java:1391)


along with the cannot load JDBC driver error.

Anyone have any ideas?
thumbnail
282548, modified 18 Years ago.
RE: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
Expert Posts: 491 Join Date: 11/19/07 Recent Posts
Hi Chris-
Anytime I've configured Liferay to use a mysql database I've always used the mysql.jar file included with Liferay's portal source. Try using that file located in ../lib/development and see if that works for you.
jr
34561, modified 18 Years ago.
RE: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
New Member Posts: 14 Join Date: 8/8/07 Recent Posts
hmmm, doesn't seem to be located in my liferay folder.

I downloaded the liferay + tomcat 6 bundle.

Does JDK 6 work with the bundle I downloaded?
thumbnail
282548, modified 18 Years ago.
RE: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
Expert Posts: 491 Join Date: 11/19/07 Recent Posts
Hi Chris-
Sorry that I wasn't more clear, but the Mysql.jar file that I use is in the liferay-portal-src-4.4.1.zip. It's a larger file, but try downloading that from sourceforge, so you have the original portal source. Once you unzip that you should find the MySQL.jar file located in ../build/lib/development. As far as JDK 6 in concerned, it should be compatible without a problem. Hope this helps.
jr
34561, modified 18 Years ago.
RE: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
New Member Posts: 14 Join Date: 8/8/07 Recent Posts
What do I do with the mysql.jar once I get it?
thumbnail
282548, modified 18 Years ago.
RE: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
Expert Posts: 491 Join Date: 11/19/07 Recent Posts
Hi Chris-
Try deploying it to the $TOMCAT_HOME/common/lib/ext and see if that solves your problems.
jr