Tomcat & MySQL fail when using the -g driver

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Fixed
    • None
    • Component/s: None
    • None

      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

      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
      

            Assignee:
            Unassigned
            Reporter:
            Nick Menere [Atlassian] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: