Skip to content

load jdbc error #156

Closed
allenmaestro opened this Issue Jan 27, 2014 · 3 comments

3 participants

@allenmaestro

I am stuck with running ycsb command because of the following error.
Any clue?

#ycsb load jdbc -s -P ../workloads/workloada -P ../jdbc-binding/conf/db.properties
java -cp /home/dba_admin/ycsb-0.1.4/voldemort-binding/conf:/home/dba_admin/ycsb-0.1.4/nosqldb-binding/conf:/home/dba_admin/ycsb-0.1.4/core/lib/core-0.1.4.jar:/home/dba_admin/ycsb-0.1.4/jdbc-binding/conf:/home/dba_admin/ycsb-0.1.4/jdbc-binding/lib/jdbc-binding-0.1.4.jar:/home/dba_admin/ycsb-0.1.4/infinispan-binding/conf:/home/dba_admin/ycsb-0.1.4/hbase-binding/conf:/home/dba_admin/ycsb-0.1.4/gemfire-binding/conf com.yahoo.ycsb.Client -db com.yahoo.ycsb.db.JdbcDBClient -s -P ../workloads/workloada -P ../jdbc-binding/conf/db.properties -load
YCSB Client 0.1
Command line: -db com.yahoo.ycsb.db.JdbcDBClient -s -P ../workloads/workloada -P ../jdbc-binding/conf/db.properties -load
Loading workload...
Starting test.
Adding shard node URL: jdbc:mysql://192.168.25.253:3306/test
Error in database operation: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.25.253:3306/test
com.yahoo.ycsb.DBException: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.25.253:3306/test
at com.yahoo.ycsb.db.JdbcDBClient.init(JdbcDBClient.java:203)
at com.yahoo.ycsb.DBWrapper.init(DBWrapper.java:63)
at com.yahoo.ycsb.ClientThread.run(Client.java:189)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.25.253:3306/test
at java.sql.DriverManager.getConnection(DriverManager.java:604)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at com.yahoo.ycsb.db.JdbcDBClient.init(JdbcDBClient.java:187)
... 2 more
com.yahoo.ycsb.DBException: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.25.253:3306/test
at com.yahoo.ycsb.db.JdbcDBClient.init(JdbcDBClient.java:203)
at com.yahoo.ycsb.DBWrapper.init(DBWrapper.java:63)
at com.yahoo.ycsb.ClientThread.run(Client.java:189)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.25.253:3306/test
at java.sql.DriverManager.getConnection(DriverManager.java:604)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at com.yahoo.ycsb.db.JdbcDBClient.init(JdbcDBClient.java:187)
... 2 more
0 sec: 0 operations;
0 sec: 0 operations;
[OVERALL], RunTime(ms), 12.0
[OVERALL], Throughput(ops/sec), 0.0

-----------db.properties-------------
jdbc.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://192.168.25.253:3306/test
db.user=root
db.passwd=password

@cmatser
Collaborator
cmatser commented Jan 28, 2014

You're missing the mysql java driver jar like: "mysql-connector-5.1.18.jar". Get the version you want and put it in the jdbc-binding/lib directory.

@allenmaestro

it woks like charm, thanks

@westonplatter

@allenmaestro closing this issue since it sounds like you got it working :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.