org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:jdbc:oracle:oci@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb01-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb02-vip)(PORT=1521))(LOAD_BALANCE=no)(FAILOVER=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rac.test.com)))' [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:jdbc:oracle:oci@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb01-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb02-vip)(PORT=1521))(LOAD_BALANCE=no)(FAILOVER=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rac.test.com)))']

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.

  • Re:Setup Oracle OCI on Quartz
    via by danielwa,
  • openjpa
    via by Unknown author,
  • NINAN / Mailing Lists
    via by Unknown author,
    • org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:jdbc:oracle:oci@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb01-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb02-vip)(PORT=1521))(LOAD_BALANCE=no)(FAILOVER=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rac.test.com)))' [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:jdbc:oracle:oci@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb01-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb02-vip)(PORT=1521))(LOAD_BALANCE=no)(FAILOVER=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rac.test.com)))'] at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:689) at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3757) at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2729) at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:jdbc:oracle:oci@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb01-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=lxapandb02-vip)(PORT=1521))(LOAD_BALANCE=no)(FAILOVER=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rac.test.com)))' at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.quartz.utils.PoolingConnectionProvider.getConnection(PoolingConnectionProvider.java:197) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112) at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:686) ... 4 more Caused by: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:264) at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437) ... 9 more

    Users with the same issue

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