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

oracle.jdbc.OracleDriver not found by wrap_mvn_c3p0_c3p0_0.9.1.2

sonyjop May 27, 2016 12:09 AM

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,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 |

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 ]

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