DbSetup simple example, SQLException occurs

Question

There's very little information about DbSetup so I couldn't find an answer to this question anywhere else. I need to test Data Access Layer and decided to use DbSetup for it. I tried to use DbSetup user guide this example just to see how it works but I get such exception:

com.ninja_squad.dbsetup.DbSetupRuntimeException: java.sql.SQLException: No suitable driver found for 127.0.0.1:3306

My database is MySQL Server. What could be the problem?

Answer 1

Your URL is incorrect. JDBC URL for MySQL looks like

jdbc:mysql://localhost:3306/databasename

as described in the documentation.

And of course, the jar of the MySQL JDBC driver must be in the classpath.