Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL

Question

I am getting the above exception, and I don't know why. Here is some more information:

Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mysql://localhost:3306/staffing_2014'

I am using Spring. In the Spring application context, I have the following dataSource:

<jee:jndi-lookup id="dataSource"
    jndi-name="jdbc/StaffingDB"
    expected-type="javax.sql.DataSource" />

It seems to read the database URL and credentials OK from tomcat's context.xml:

<Resource name="jdbc/StaffingDB" auth="Container" type="javax.sql.DataSource"
           maxActive="100" maxIdle="30" maxWait="10000"
           username="xxx" password="yyy" driverClassName="com.mysql.jdbc.Driver"
           url="jdbc:mysql://localhost:3306/staffing_2014"/>

Before anyone suggests Googling it, I have. The obvious answers I've found have been:

Database URL malformed? - checked and OK.
MySQL driver in classpath? Yes- jar is in $TOMCAT_HOME/lib

Any other suggesions?

EDIT - way down the bottom:

java.sql.SQLException: No suitable driver
java.sql.DriverManager.getDriver(DriverManager.java:279)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)

Is there a specific Exception being thrown (e.g. NoClassDefFoundException or ClassNotFoundException)? — austin
– austin, Commented Nov 5, 2013 at 16:24
@NickJ can you write a simple JSP inside a separate clean web app that uses the JNDI resource jdbc/StaffingDB and tries to connect to the db as a test? If it works then the issue is with the Spring layer — David Brossard
– David Brossard, Commented Nov 5, 2013 at 16:35
@NickJ check this post out: stackoverflow.com/questions/10354997/… - are you hitting the same issue? — David Brossard
– David Brossard, Commented Nov 5, 2013 at 16:55

David Brossard · Accepted Answer · 2013-11-05 16:33:44Z

1

What version of Tomcat are you using? In some Tomcats (T5), TOMCAT_HOME/lib may not be the right location. You have to put the driver in Tomcat's endorsed folder which could be

TOMCAT_HOME/endorsed or
TOMCAT_HOME/shared/lib

Check your Tomcat setup.

edited Nov 5, 2013 at 16:33

answered Nov 5, 2013 at 16:26

David Brossard

13.8k6 gold badges61 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

NickJ Over a year ago

The version is 6.0.35. The endorsed and shared directories do not exist. The lib directory is correct according to the Tomcat JNDI HowTo at tomcat.apache.org/tomcat-6.0-doc/…

MTilsted Over a year ago

I think it's better to put the .jar file in webapps/$yourAppName/WEB-INF/lib

NickJ Over a year ago

I had it there originally. I wanted to move it out to try and avoid a memory leak when redeploying.

David Brossard Over a year ago

You can only put the jdbc driver in webapp/WEB-INF/lib if you define the jndi resource within the web app. So if your context.xml is in Tomcat's conf/ folder then you need to add the library to Tomcat's lib folder.

Collectives™ on Stack Overflow

Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related