org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver' for connect URL 'jdbc:oracle:thin@localhost:1521:orcl'

Atlassian JIRA | Pete de Zwart | 7 years ago
  1. 0

    Datasource creation fails with {{java.sql.SQLException: No suitable driver}} even though the driver class has ben loaded: {noformat} [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 {noformat} Oracle JDBC driver obtained from http://download.oracle.com/otn/utilities_drivers/jdbc/10105/ojdbc14.jar mentioned in [Connecting JIRA to Oracle|http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+Oracle].

    Atlassian JIRA | 7 years ago | Pete de Zwart
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver' for connect URL 'jdbc:oracle:thin@localhost:1521:orcl'
  2. 0

    Datasource creation fails with {{java.sql.SQLException: No suitable driver}} even though the driver class has ben loaded: {noformat} [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 {noformat} Oracle JDBC driver obtained from http://download.oracle.com/otn/utilities_drivers/jdbc/10105/ojdbc14.jar mentioned in [Connecting JIRA to Oracle|http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+Oracle].

    Atlassian JIRA | 7 years ago | Pete de Zwart
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver' for connect URL 'jdbc:oracle:thin@localhost:1521:orcl'
  3. 0

    java web app run in netbeans - SQLException: No suitable driver

    Stack Overflow | 6 years ago | Mihaela
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'http://maven.apache.org'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can't get connection from DataSource object

    Coderanch | 7 years ago | Fabio Piergentili
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'Apr 5, 2010 4:32:35 PM org.apache.catalina.core.ApplicationContext log INFO: StudentServlet: SQLException caught Cannot create JDBC driver of class '' for connect URL 'null'
  6. 0

    Uploading Webapp to CloudBees

    Stack Overflow | 3 years ago | user2785929
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'ec2-23-21-211-172.compute-1.amazonaws.com'

  1. silex 1 times, last 7 months ago
14 unregistered visitors
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.sql.SQLException

    No suitable driver

    at java.sql.DriverManager.getDriver()
  2. Java RT
    DriverManager.getDriver
    1. java.sql.DriverManager.getDriver(DriverManager.java:264)
    1 frame
  3. org.apache.tomcat
    BasicDataSource.getConnection
    1. org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
    2. org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    2 frames
  4. org.ofbiz.core
    ConnectionFactory.getConnection
    1. org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:212)
    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)
    4 frames
  5. com.atlassian.jira
    JiraStartupChecklistContextListener.contextInitialized
    1. com.atlassian.jira.appconsistency.db.OfbizConnectionFactory.getConnection(OfbizConnectionFactory.java:27)
    2. com.atlassian.jira.appconsistency.db.DatabaseConsistencyCheck.isJdbcDriverCorrectTypeForEntityEngine(DatabaseConsistencyCheck.java:101)
    3. com.atlassian.jira.appconsistency.db.DatabaseConsistencyCheck.isOk(DatabaseConsistencyCheck.java:80)
    4. com.atlassian.jira.startup.JiraStartupChecklist.doStartupChecks(JiraStartupChecklist.java:57)
    5. com.atlassian.jira.startup.JiraStartupChecklist.startupOK(JiraStartupChecklist.java:47)
    6. com.atlassian.jira.startup.JiraStartupChecklistContextListener.runStartupChecks(JiraStartupChecklistContextListener.java:96)
    7. com.atlassian.jira.startup.JiraStartupChecklistContextListener.contextInitialized(JiraStartupChecklistContextListener.java:46)
    7 frames
  6. Glassfish Core
    Catalina.start
    1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
    2. org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
    3. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
    4. org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
    5. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
    6. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    7. org.apache.catalina.core.StandardService.start(StandardService.java:448)
    8. org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
    9. org.apache.catalina.startup.Catalina.start(Catalina.java:552)
    9 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:597)
    4 frames
  8. Glassfish Core
    Bootstrap.main
    1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
    2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
    2 frames