Answers for "no suitable driver found for jdbc:mysql:"

java.sql.sqlexception: no suitable driver found

This error occurs if JDBC is not able to find a suitable driver for
the URL format passed to the getConnection()
method e.g."jdbc:mysql://" in our case.

In order to solve this error,
you need the MySQL JDBC driver like
"mysql-connector-java-5.1.36.jar" in your classpath.

no suitable driver found for jdbc:mysql

Connection con = null;
try {
    //registering the jdbc driver here, your string to use 
    //here depends on what driver you are using.
    Class.forName("something.jdbc.driver.YourFubarDriver");   
    con = DriverManager.getConnection("jdbc:apache:commons:dbcp:test");
} catch (SQLException e) {
    throw new RuntimeException(e);
}

no suitable driver found for jdbc:mysql:

Try putting the driver jar in the server lib folder. ($CATALINA_HOME/lib)

I believe that the connection pool needs to be set up even before the application is instantiated. (At least that's how it works in Jboss)