MySQL: No suitable driver found.

[Onra]

Hello,

I want to establish a connection to my MySQL database so I can query it from my jsp/web application. I added mysql-connector-java-5.1.14-bin.jar to my WEB-INF/lib folder.

Now when I try to establish a connection it says: No suitable driver found for jdbc:mysql://localhost?autoReconnect=true.

The lines in my code where the error occurs are:

            m_url = "jdbc:mysql://" + mDatabaseHost +"?autoReconnect=true";
            m_connection = DriverManager.getConnection(m_url, mDatabaseUser, mDatabasePassword);

User and password are correct. What might be wrong?

[Tolls]

Have you loaded the driver?

Class.forName("com.mysql.jdbc.Driver"); // check the class name

[Onra]

This yields a ClassNotFoundException.

[doWhile]

You need to add the library to your classpath.

[Onra]

And how do I do that?

I thought when adding a library to WEB-INF/lib it is automatically added?

[doWhile]

I thought when adding a library to WEB-INF/lib it is automatically added?

Given the error, it is evidently not. Make sure when you deploy it is contained within as you expect, or consult the manual/instructions for the software (and version) you are using to verify this folder is placed on the classpath and/or the best place to add libraries to the classpath of the container.

[Tolls]

What server are you using?
It does seem odd that it's not picking it up if everything is where it should be.

[Onra]

Tomcat 7.0.

[Tolls]

Not used 7.
I'd be surprised if they'd changed the basic structure of what a web app should look like.