runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

by

You need to add a connector library to the Runtime classpath:

java -cp .;mysql-connector-java-5.1.25-bin.jar ClientBase

My example uses Windows classpath separator ";", on other systems it may be different (":" on Linux/Mac). It also assumes, that mysql-connector-java-5.1.25-bin.jar is located on the same folder. If it’s not the case, then put a path to the library instead of the plain name.

ClientBase stands for Java class file name here

c:\>javac Test.java
c:\>java -cp .;F:\CK\JavaTest\JDBCTutorial\mysql-connector-java-5.1.18-bin Test

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. Multiple queries executed in java in single statement
  4. Java: Insert multiple rows into MySQL with PreparedStatement
  5. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  6. Handling MySQL datetimes and timestamps in Java
  7. MySQL and JDBC with rewriteBatchedStatements=true
  8. Closing JDBC Connections in Pool
  9. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  10. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  11. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  12. Returning a ResultSet
  13. How to change MySQL timezone in a database connection using Java?
  14. Retrieve an Image stored as BLOB on a MYSQL DB
  15. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  16. mysql prepared statement error: MySQLSyntaxErrorException
  17. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  18. how to get list of Databases “Schema” names of MySql using java JDBC
  19. oracle.jdbc.driver.OracleDriver ClassNotFoundException
  20. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  21. How to correctly write UTF-8 strings into MySQL through JDBC interface
  22. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  23. java.sql.SQLException: Before start of result set [duplicate]
  24. How to use prepared statement for select query in Java?
  25. Stumped SQL Exception for JDBC
  26. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. A persistent connection with JDBC to MySQL
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment