1 Reply Latest reply on May 27, 2016 9:32 AM by Sony Joseph

    oracle.jdbc.OracleDriver not found by wrap_mvn_c3p0_c3p0_0.9.1.2

    Sony Joseph Novice

      Hello Friends

       

      There is a new problem that I face while using the below combination:

       

      JBoss Fuse - 6.2.1

      Oracle - ojdbc7.jar 12.1.0.1

      camel-quartz2 6.2.1-xxxxx-084

       

      I am trying to have a quartz Job Store externalised into a DB table in Oracle.While installing my route I see the below exception stack. Kindly anybody suggest.

      Note: kindly ignore any h2 database reference in the log; to start with my effort is to ensure that the com.jdbc.OracleDriver is loaded.

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      09:28:59,485 | INFO  | FelixStartLevel  | JobStoreTX                       | 310 - org.quartz-scheduler.quartz - 2.2.1 | JobStoreTX initialized.

      09:28:59,490 | INFO  | FelixStartLevel  | QuartzScheduler                  | 310 - org.quartz-scheduler.quartz - 2.2.1 | Scheduler meta-data: Quartz Scheduler (v2.2.1) 'DatabaseClusteredScheduler-camel-blueprint-quartz' with instanceId 'sobhitha1464321539472'n  |   Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.n  |   NOT STARTED.n  |   Currently in standby mode.n  |   Number of jobs executed: 0n  |   Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.n  |   Using job-store 'org.quartz.impl.jdbcjobstore.JobStoreTX' - which supports persistence. and is clustered.n  |

      09:28:59,490 | INFO  | FelixStartLevel  | StdSchedulerFactory              | 310 - org.quartz-scheduler.quartz - 2.2.1 | Quartz scheduler 'DatabaseClusteredScheduler-camel-blueprint-quartz' initialized from an externally provided properties instance.

      09:28:59,490 | INFO  | FelixStartLevel  | StdSchedulerFactory              | 310 - org.quartz-scheduler.quartz - 2.2.1 | Quartz scheduler version: 2.2.1

      09:28:59,529 | WARN  | er$PoolThread-#1 | DriverManagerDataSource          | 309 - wrap_mvn_c3p0_c3p0_0.9.1.2 - 0.0.0 | Could not load driverClass oracle.jdbc.OracleDriver

      java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver not found by wrap_mvn_c3p0_c3p0_0.9.1.2 [309]

        at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1556)[org.apache.felix.framework-4.4.1.jar:]

        at org.apache.felix.framework.BundleWiringImpl.access$400(BundleWiringImpl.java:77)[org.apache.felix.framework-4.4.1.jar:]

        at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.loadClass(BundleWiringImpl.java:1993)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)[:1.7.0_75]

        at java.lang.Class.forName0(Native Method)[:1.7.0_75]

        at java.lang.Class.forName(Class.java:191)[:1.7.0_75]

        at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)[309:wrap_mvn_c3p0_c3p0_0.9.1.2:0.0.0]

        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)[309:wrap_mvn_c3p0_c3p0_0.9.1.2:0.0.0]

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)[309:wrap_mvn_c3p0_c3p0_0.9.1.2:0.0.0]

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)[309:wrap_mvn_c3p0_c3p0_0.9.1.2:0.0.0]

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)[309:wrap_mvn_c3p0_c3p0_0.9.1.2:0.0.0]

        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)[309:wrap_mvn_c3p0_c3p0_0.9.1.2:0.0.0]

        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)[309:wrap_mvn_c3p0_c3p0_0.9.1.2:0.0.0]

        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)[309:wrap_mvn_c3p0_c3p0_0.9.1.2:0.0.0]

        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)[309:wrap_mvn_c3p0_c3p0_0.9.1.2:0.0.0]

      09:28:59,529 | INFO  | FelixStartLevel  | AbstractPoolBackedDataSource     | 309 - wrap_mvn_c3p0_c3p0_0.9.1.2 - 0.0.0 | Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge0w89g1uoxvftfdon20|4208f7a6, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge0w89g1uoxvftfdon20|4208f7a6, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:h2:file:~/h2/cronjob;AUTO_SERVER=TRUE, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 120, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]

      09:28:59,529 | WARN  | er$PoolThread-#2 | DriverManagerDataSource          | 309 - wrap_mvn_c3p0_c3p0_0.9.1.2 - 0.0.0 | Could not load driverClass oracle.jdbc.OracleDriver

      java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver not found by wrap_mvn_c3p0_c3p0_0.9.1.2 [309]

        at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1556)[org.apache.felix.framework-4.4.1.jar:]

        at org.apache.felix.framework.BundleWiringImpl.access$400(BundleWiringImpl.java:77)[org.apache.felix.framework-4.4.1.jar:]

        at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.loadClass(BundleWiringImpl.java:1993)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)[:1.7.0_75]

        at java.lang.Class.forName0(Native Method)[:1.7.0_75]

        at java.lang.Class.forName(Class.java:191)[:1.7.0_75]