Details
-
Bug
-
Resolution: Invalid
-
High
-
None
-
4.0
-
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
-
4
-
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.