org.apache.tomcat.dbcp.dbcp.SQLNestedException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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].
    via by Pete de Zwart,
  • 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].
    via by Pete de Zwart,
  • Can't get connection from DataSource object
    via by Fabio Piergentili,
  • Uploading Webapp to CloudBees
    via Stack Overflow by user2785929
    ,
  • Tomcat 7 - mysql driver cannot be found
    via by Unknown author,
    • 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

    Users with the same issue

    Unknown visitor1 times, last one,
    odd
    24 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    11 more bugmates