Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-18872

Unable to create Oracle 10 JNDI DS with JIRA standalone & Sun JDK 6.0 1.6.0_12

    XMLWordPrintable

Details

    • Bug
    • Resolution: Invalid
    • High
    • None
    • 4.0
    • Installation
    • Linux CentOS 5.X, Intel 32bit x86, Sun JDK 6.0 1.6.0_12, Oracle 10g Release 2 10.2.0.1.0 (TPM) with atlassian-jira-enterprise-4.0-SNAPSHOT-standalone.zip from QA-ENT-349

    Description

      Datasource creation fails with java.sql.SQLException: No suitable driver even though the driver class has ben loaded:

      [Loaded oracle.jdbc.driver.OracleDriver from file:/root/atlassian-jira-enterprise-4.0-SNAPSHOT-standalone/common/lib/ojdbc14.jar]
      [Loaded oracle.jdbc.OracleDriver from file:/root/atlassian-jira-enterprise-4.0-SNAPSHOT-standalone/common/lib/ojdbc14.jar]
      [Loaded oracle.jdbc.driver.OracleDriverExtension from file:/root/atlassian-jira-enterprise-4.0-SNAPSHOT-standalone/common/lib/ojdbc14.jar]
      [Loaded java.sql.DriverManager from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded java.sql.SQLPermission from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded java.sql.DriverService from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded sun.misc.Service from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded sun.misc.Service$LazyIterator from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded java.util.TreeSet from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded sun.jdbc.odbc.JdbcOdbcDriverInterface from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded sun.jdbc.odbc.JdbcOdbcObject from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded sun.jdbc.odbc.JdbcOdbcDriver from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded sun.jdbc.odbc.JdbcOdbcTracer from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded java.sql.DriverInfo from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded java.sql.SQLWarning from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      [Loaded org.apache.log4j.spi.ThrowableInformation from file:/root/atlassian-jira-enterprise-4.0-SNAPSHOT-standalone/atlassian-jira/WEB-INF/lib/log4j-1.2.15.jar]
      [Loaded java.io.LineNumberReader from /usr/java/jdk1.6.0_12/jre/lib/rt.jar]
      2009-09-05 01:52:17,553 main ERROR     [jira.appconsistency.db.DatabaseConsistencyCheck] There was a SQL exception checking for database driver correctness. Skipping.
      org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver' for connect URL 'jdbc:oracle:thin@localhost:1521:orcl'
              at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
              at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
              at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:212)
              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 com.atlassian.jira.appconsistency.db.OfbizConnectionFactory.getConnection(OfbizConnectionFactory.java:27)
              at com.atlassian.jira.appconsistency.db.DatabaseConsistencyCheck.isJdbcDriverCorrectTypeForEntityEngine(DatabaseConsistencyCheck.java:101)
              at com.atlassian.jira.appconsistency.db.DatabaseConsistencyCheck.isOk(DatabaseConsistencyCheck.java:80)
              at com.atlassian.jira.startup.JiraStartupChecklist.doStartupChecks(JiraStartupChecklist.java:57)
              at com.atlassian.jira.startup.JiraStartupChecklist.startupOK(JiraStartupChecklist.java:47)
              at com.atlassian.jira.startup.JiraStartupChecklistContextListener.runStartupChecks(JiraStartupChecklistContextListener.java:96)
              at com.atlassian.jira.startup.JiraStartupChecklistContextListener.contextInitialized(JiraStartupChecklistContextListener.java:46)
              at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
              at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
              at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
              at org.apache.catalina.core.StandardService.start(StandardService.java:448)
              at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
              at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
              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:597)
              at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
      Caused by: java.sql.SQLException: No suitable driver
              at java.sql.DriverManager.getDriver(DriverManager.java:264)
              at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
              ... 27 more
      

      Oracle JDBC driver obtained from http://download.oracle.com/otn/utilities_drivers/jdbc/10105/ojdbc14.jar mentioned in Connecting JIRA to Oracle.

      Attachments

        Activity

          People

            pdzwart PdZ (Inactive)
            pdzwart PdZ (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: