NameError: cannot load Java class com.mysql.jdbc.Driver

Question

I'm using JRuby 1.7.2, along with DataMapper, and I'm getting an error I can't find an answer to.

I'm just testing out DataMapper along with MySQL 5.5 to see if it will run fine when I build around it. Here's the file I'm testing:

require "data_mapper"
require "keys"

DataMapper.setup(:default, "mysql://#{$user}:#{$pass}@localhost/test_db")

And when I run this, I get the error:

NameError: cannot load Java class com.mysql.jdbc.Driver

And it points to the DataMapper.setup line.

My Gemfile should be alright:

source :rubygems

gem "sinatra"
gem "trinidad"
gem "data_mapper"

# do a `sudo apt-get install libmysqlclient-dev` first
gem "dm-mysql-adapter"
gem "jdbc-mysql"

Is there anything I'm missing? I have MySQL set up with a user/pass locally already.

Reimeus · Accepted Answer · 2013-01-10 18:38:17Z

7

This is a common error when running JDBC clients for MySQL. You need to make sure you have mysql-connector-java-bin.jar on the classpath. You can download it from here.

edited Jan 10, 2013 at 18:38

answered Jan 10, 2013 at 18:21

Reimeus

160k16 gold badges225 silver badges282 bronze badges

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

Comments

Darren Hicks · Accepted Answer · 2013-02-02 06:31:04Z

7

I'm using Rails 3.2.9 and to solve the problem I added this to my application.rb

if defined? JRUBY_VERSION
    require 'jdbc/mysql'
    Jdbc::MySQL.load_driver
end

answered Feb 2, 2013 at 6:31

Darren Hicks

5,0861 gold badge36 silver badges35 bronze badges

Comments

kares · Accepted Answer · 2014-04-14 08:21:21Z

2

actually, the correct answer is to work-around an incompatibility between 5.1.13 and 5.1.22 !

jdbc-mysql gem already contains the mysql-connector.jar it just ain't auto-loading anymore :

https://github.com/jruby/activerecord-jdbc-adapter/tree/master/jdbc-mysql (read the README)

you can also force the driver to auto-load using a Java system property e.g. from a cmd line :

jruby -J-Darjdbc.mysql.autoload=true -S rake ...

edited Apr 14, 2014 at 8:21

answered Jan 17, 2013 at 8:31

kares

7,2011 gold badge31 silver badges38 bronze badges

Comments

AlejandroVD · Accepted Answer · 2014-09-03 21:16:38Z

0

I had the same error when trying to use a mysql database from jruby/rails4. In my case this line was missing from ./Gemfile:

gem 'jdbc-mysql'

answered Sep 3, 2014 at 21:16

AlejandroVD

1,87322 silver badges23 bronze badges

Collectives™ on Stack Overflow

NameError: cannot load Java class com.mysql.jdbc.Driver

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related