Hello Friends,
You may have come across “java.lang.ClassNotFoundException: com.mysql.jdbc.Driver” error/exception while working with java and JDBC. The error occurs mainly when we try to connect to the mySql database from our java code. The error message itself give the clear indication about what we are missing. It says that it is unable to find the Class – “com.mysql.jdbc.Driver”.
Now, this exception is mainly due to unavailability of the mysql-connector jar file which contains the required class which is missing while the compilation of the code. This jar file contains many other classes those are listed in the below table
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 |
com.mysql.jdbc.AssertionFailedException.class com.mysql.jdbc.Blob.class com.mysql.jdbc.BlobFromLocator.class com.mysql.jdbc.Buffer.class com.mysql.jdbc.CachedResultSetMetaData.class com.mysql.jdbc.CallableStatement.class com.mysql.jdbc.CharsetMapping.class com.mysql.jdbc.Clob.class com.mysql.jdbc.CommunicationsException.class com.mysql.jdbc.CompressedInputStream.class com.mysql.jdbc.Connection.class com.mysql.jdbc.ConnectionFeatureNotAvailableException.class com.mysql.jdbc.ConnectionProperties.class com.mysql.jdbc.ConnectionPropertiesTransform.class com.mysql.jdbc.Constants.class com.mysql.jdbc.CursorRowProvider.class com.mysql.jdbc.DatabaseMetaData.class com.mysql.jdbc.DatabaseMetaDataUsingInfoSchema.class com.mysql.jdbc.DocsConnectionPropsHelper.class com.mysql.jdbc.Driver.class com.mysql.jdbc.EscapeProcessor.class com.mysql.jdbc.EscapeProcessorResult.class com.mysql.jdbc.EscapeTokenizer.class com.mysql.jdbc.ExportControlled.class com.mysql.jdbc.Field.class com.mysql.jdbc.LicenseConfiguration.class com.mysql.jdbc.LoadBalancingConnectionProxy.class com.mysql.jdbc.Messages.class com.mysql.jdbc.MiniAdmin.class com.mysql.jdbc.MysqlDataTruncation.class com.mysql.jdbc.MysqlDefs.class com.mysql.jdbc.MysqlErrorNumbers.class com.mysql.jdbc.MysqlIO.class com.mysql.jdbc.MysqlParameterMetadata.class com.mysql.jdbc.MysqlSavepoint.class com.mysql.jdbc.NamedPipeSocketFactory.class com.mysql.jdbc.NonRegisteringDriver.class com.mysql.jdbc.NonRegisteringReplicationDriver.class com.mysql.jdbc.NotImplemented.class com.mysql.jdbc.NotUpdatable.class com.mysql.jdbc.OperationNotSupportedException.class com.mysql.jdbc.OutputStreamWatcher.class com.mysql.jdbc.PacketTooBigException.class com.mysql.jdbc.PingTarget.class com.mysql.jdbc.PreparedStatement.class com.mysql.jdbc.ReplicationConnection.class com.mysql.jdbc.ReplicationDriver.class com.mysql.jdbc.ResultSet.class com.mysql.jdbc.ResultSetMetaData.class com.mysql.jdbc.RowData.class com.mysql.jdbc.RowDataDynamic.class com.mysql.jdbc.RowDataStatic.class com.mysql.jdbc.SQLError.class com.mysql.jdbc.Security.class com.mysql.jdbc.ServerPreparedStatement.class com.mysql.jdbc.SingleByteCharsetConverter.class com.mysql.jdbc.SocketFactory.class com.mysql.jdbc.StandardSocketFactory.class com.mysql.jdbc.Statement.class com.mysql.jdbc.StringUtils.class com.mysql.jdbc.TimeUtil.class com.mysql.jdbc.UpdatableResultSet.class com.mysql.jdbc.Util.class com.mysql.jdbc.VersionedStringProperty.class com.mysql.jdbc.WatchableOutputStream.class com.mysql.jdbc.WatchableWriter.class com.mysql.jdbc.WriterWatcher.class com.mysql.jdbc.exceptions.MySQLDataException.class com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException.class com.mysql.jdbc.exceptions.MySQLInvalidAuthorizationSpecException.class com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException.class com.mysql.jdbc.exceptions.MySQLNonTransientException.class com.mysql.jdbc.exceptions.MySQLSyntaxErrorException.class com.mysql.jdbc.exceptions.MySQLTimeoutException.class com.mysql.jdbc.exceptions.MySQLTransactionRollbackException.class com.mysql.jdbc.exceptions.MySQLTransientConnectionException.class com.mysql.jdbc.exceptions.MySQLTransientException.class com.mysql.jdbc.integration.c3p0.MysqlConnectionTester.class com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter.class com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker.class com.mysql.jdbc.jdbc2.optional.CallableStatementWrapper.class com.mysql.jdbc.jdbc2.optional.ConnectionWrapper.class com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource.class com.mysql.jdbc.jdbc2.optional.MysqlDataSource.class com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory.class com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.class com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.class com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.class com.mysql.jdbc.jdbc2.optional.MysqlXAException.class com.mysql.jdbc.jdbc2.optional.MysqlXid.class com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.class com.mysql.jdbc.jdbc2.optional.StatementWrapper.class com.mysql.jdbc.jdbc2.optional.SuspendableXAConnection.class com.mysql.jdbc.jdbc2.optional.WrapperBase.class com.mysql.jdbc.log.CommonsLogger.class com.mysql.jdbc.log.Jdk14Logger.class com.mysql.jdbc.log.Log.class com.mysql.jdbc.log.Log4JLogger.class com.mysql.jdbc.log.LogFactory.class com.mysql.jdbc.log.LogUtils.class com.mysql.jdbc.log.NullLogger.class com.mysql.jdbc.log.StandardLogger.class com.mysql.jdbc.profiler.ProfileEventSink.class com.mysql.jdbc.profiler.ProfilerEvent.class com.mysql.jdbc.util.BaseBugReport.class com.mysql.jdbc.util.ErrorMappingsDocGenerator.class com.mysql.jdbc.util.LRUCache.class com.mysql.jdbc.util.PropertiesDocGenerator.class com.mysql.jdbc.util.ReadAheadInputStream.class com.mysql.jdbc.util.ResultSetUtil.class com.mysql.jdbc.util.ServerController.class com.mysql.jdbc.util.TimezoneDump.class com.mysql.jdbc.util.VersionFSHierarchyMaker.class org.gjt.mm.mysql.Driver.class |
What you need to do is, just add the mysql-connector-java jar file in the build path of your program and then run the program again. Your program will run and execute properly. You can download the jar from MySql download link.
Hope this will help you.
Regards,
Nikhil Naoghare.
Thanks for fix. sometime you need correct version of JDBC driver as well. I have shared few tips here http://javarevisited.blogspot.com/2012/03/jdbc-javalangclassnotfoundexception.html Fixing java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Java