No suitable driver found for jdbc:mysql

Hi,

I am a new jruby user. I am using jruby-complete-1.7.11
I have got a script which is connecting to MySQL db and fetching some
data.

While executing I am getting error “No suitable driver found for
jdbc:mysql”

Need help to solve this error.

Doesn’t look like a JRuby problem to me. My guess is that the connect
also doesn’t work from pure Java - did you try this? In this case, I
would conclude that the MySql database driver is missing.

The reason you got this error is because you forgot to register your java mysql jdbc driver with the application.

Should be like this:

Class.forName("com.mysql.jdbc.Driver");

This forces the driver to register itself, so that Java knows how to handle those database connection strings.

You’ll have to read the manual on your specific mysql jdbc driver to find the exact string to place inside the the Class.forName("…") parameter.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs