org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

Atlassian JIRA | Nick Menere [Atlassian] | 1 decade ago
tip
Do you find the tips below useful? Click on the to mark them and say thanks to Rafael Fischer Viola , poroszd and rafael . Or join the community to write better ones.
  1. 0

    The following was reported when using the *{{mysql-connector-java-3.1.10-bin-g.jar}}* driver. Removing the driver from the Classpath fixed the issue. Note. the *aspectj* error - this has affected quite a few tomcat/Mysql users - http://forums.mysql.com/read.php?39,22579,22579#msg-22579 {code} 2005-11-28 13:56:21,416 ERROR [atlassian.jira.service.DefaultServiceManager] Could not configure services: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Cannot load JDBC driver class 'com.mysql.jdbc.Driver') at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:239) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:318) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696) at com.atlassian.jira.service.DefaultServiceManager.loadServices(DefaultServiceManager.java:55) at com.atlassian.jira.service.DefaultServiceManager.getServices(DefaultServiceManager.java:39) at com.atlassian.jira.upgrade.ConsistencyCheckImpl.destroy(ConsistencyCheckImpl.java:90) at com.atlassian.jira.upgrade.ConsistencyLauncher.contextDestroyed(ConsistencyLauncher.java:33) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3710) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4283) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4132) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:683) at org.apache.catalina.startup.Catalina.start(Catalina.java:537) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:318) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696) at com.atlassian.jira.service.DefaultServiceManager.loadServices(DefaultServiceManager.java:55) at com.atlassian.jira.service.DefaultServiceManager.getServices(DefaultServiceManager.java:39) at com.atlassian.jira.upgrade.ConsistencyCheckImpl.destroy(ConsistencyCheckImpl.java:90) at com.atlassian.jira.upgrade.ConsistencyLauncher.contextDestroyed(ConsistencyLauncher.java:33) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3710) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4283) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4132) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:683) at org.apache.catalina.startup.Catalina.start(Catalina.java:537) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) Caused by: java.lang.NoClassDefFoundError: org/aspectj/lang/Signature at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760) ... 33 more {code}

    Atlassian JIRA | 1 decade ago | Nick Menere [Atlassian]
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
  2. 0

    The following was reported when using the *{{mysql-connector-java-3.1.10-bin-g.jar}}* driver. Removing the driver from the Classpath fixed the issue. Note. the *aspectj* error - this has affected quite a few tomcat/Mysql users - http://forums.mysql.com/read.php?39,22579,22579#msg-22579 {code} 2005-11-28 13:56:21,416 ERROR [atlassian.jira.service.DefaultServiceManager] Could not configure services: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Cannot load JDBC driver class 'com.mysql.jdbc.Driver') at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:239) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:318) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696) at com.atlassian.jira.service.DefaultServiceManager.loadServices(DefaultServiceManager.java:55) at com.atlassian.jira.service.DefaultServiceManager.getServices(DefaultServiceManager.java:39) at com.atlassian.jira.upgrade.ConsistencyCheckImpl.destroy(ConsistencyCheckImpl.java:90) at com.atlassian.jira.upgrade.ConsistencyLauncher.contextDestroyed(ConsistencyLauncher.java:33) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3710) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4283) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4132) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:683) at org.apache.catalina.startup.Catalina.start(Catalina.java:537) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:318) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696) at com.atlassian.jira.service.DefaultServiceManager.loadServices(DefaultServiceManager.java:55) at com.atlassian.jira.service.DefaultServiceManager.getServices(DefaultServiceManager.java:39) at com.atlassian.jira.upgrade.ConsistencyCheckImpl.destroy(ConsistencyCheckImpl.java:90) at com.atlassian.jira.upgrade.ConsistencyLauncher.contextDestroyed(ConsistencyLauncher.java:33) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3710) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4283) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4132) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:683) at org.apache.catalina.startup.Catalina.start(Catalina.java:537) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) Caused by: java.lang.NoClassDefFoundError: org/aspectj/lang/Signature at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760) ... 33 more {code}

    Atlassian JIRA | 1 decade ago | Nick Menere [Atlassian]
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
  3. 0
    samebug tip
    org.apache.http.config.Lookup class is in httpcore-4.3.jar not in httpclient-4.3.1.jar
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0
    samebug tip
    Upgrade play-plugins-redis to play-modules-redis. You may have to delete com.typesafe.plugin.RedisPlugin from play.plugins
  6. 0
    samebug tip
    You might have to readd your libraries if you just upgraded intelliJ. Try readding the netty library to the SDK.
    via GitHub by EBatTiVo
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.lang.NoClassDefFoundError

    org/aspectj/lang/Signature

    at java.lang.Class.forName0()
  2. Java RT
    Class.forName
    1. java.lang.Class.forName0(Native Method)
    2. java.lang.Class.forName(Class.java:164)
    2 frames
  3. org.apache.tomcat
    BasicDataSource.getConnection
    1. org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760)
    2. org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    2 frames
  4. org.ofbiz.core
    GenericDelegator.findAll
    1. org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168)
    2. org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140)
    3. org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99)
    4. org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53)
    5. org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237)
    6. org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:318)
    7. org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
    8. org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)
    9. org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
    10. org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
    11. org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
    12. org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696)
    12 frames
  5. com.atlassian.jira
    ConsistencyLauncher.contextDestroyed
    1. com.atlassian.jira.service.DefaultServiceManager.loadServices(DefaultServiceManager.java:55)
    2. com.atlassian.jira.service.DefaultServiceManager.getServices(DefaultServiceManager.java:39)
    3. com.atlassian.jira.upgrade.ConsistencyCheckImpl.destroy(ConsistencyCheckImpl.java:90)
    4. com.atlassian.jira.upgrade.ConsistencyLauncher.contextDestroyed(ConsistencyLauncher.java:33)
    4 frames
  6. Glassfish Core
    Catalina.start
    1. org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3710)
    2. org.apache.catalina.core.StandardContext.stop(StandardContext.java:4283)
    3. org.apache.catalina.core.StandardContext.start(StandardContext.java:4132)
    4. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
    5. org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
    6. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
    7. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
    8. org.apache.catalina.core.StandardService.start(StandardService.java:450)
    9. org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
    10. org.apache.catalina.startup.Catalina.start(Catalina.java:537)
    10 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:585)
    4 frames
  8. Glassfish Core
    Bootstrap.main
    1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
    2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
    2 frames