Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-8674

Tomcat & MySQL fail when using the -g driver

    XMLWordPrintable

    Details

    • Type: Suggestion
    • Status: Resolved (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Feedback Policy:
      We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see An updated workflow for server feature suggestions.

      Description

      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
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: