[resolved] [Talend 6.0.1] tOracleConnection error

[Anonymous]

Hello,
I'm testing my route using Talend ESB 6.0.1 on a new server.
It doesn't work because the component tOracleConnection is unable to connect to our database while I installed the ojdbc14.jar into my runtime. 
See the errors below I received on TAC.
Could you see how can I resolve this issue and which bundle I need to deploy in order to connect to our Oracle database 11g ?
Thanks in advance

[Anonymous]

Hi,
It depends how you used tOracleConnection component, if you don't check "Specify a data source alias" option, then you don't need to install the ojdbc driver into the Runtime container. if you checked this option, then:
1) install ojdbc driver into Runtime (Note: please using wrap: because ojdbc jar is not an OSGi bundle.  bundle:install wrap:file :/ojdbc4.jar)
2) install datasource xml for oracle into Runtime
(also please provide the full log from Runtime container/logs/tesb.log)
HTH

[Anonymous]

Hello and thank you for your answer.
"Specify a data source alias" option is not check but I think I need to install the ojdbc driver because I use a metadata connection.
Thus I installed the driver ojdbc6.jar as you recommanded but I have still the same error.
Below the log:

10:55:45,347 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 | Changes to perform:
10:55:45,348 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |   Region: root10:55:45,348 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |     Bundles to install:10:55:45,348 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |       mvn:VEHANN/A

To see the whole post, download it here
OriginalPost.pdf

[Anonymous]

Tac tells me at least one bundle is not active:

[Anonymous]

I have another error in wrapper.log:

INFO   | jvm 1    | 2016/01/07 10:55:46 | Exception in component tOracleConnection_1
INFO   | jvm 1    | 2016/01/07 10:55:46 | java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver cannot be found by gate.ATT_GAT_BOR_0.2.0
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:439)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:352)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:344)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:160)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.lang.Class.forName0(Native Method)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.lang.Class.forName(Class.java:264)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at gate.att_gat_bor_write_0_5.ATT_GAT_BOR_WRITE.tOracleConnection_1Process(ATT_GAT_BOR_WRITE.java:1286)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at gate.att_gat_bor_write_0_5.ATT_GAT_BOR_WRITE.runJobInTOS(ATT_GAT_BOR_WRITE.java:17182)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at gate.att_gat_bor_write_0_5.ATT_GAT_BOR_WRITE.runJob(ATT_GAT_BOR_WRITE.java:16970)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at gate.att_gat_bor_0_2.ATT_GAT_BOR.tRunJob_1Process(ATT_GAT_BOR.java:3168)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at gate.att_gat_bor_0_2.ATT_GAT_BOR.tXSDValidator_1Process(ATT_GAT_BOR.java:1920)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at gate.att_gat_bor_0_2.ATT_GAT_BOR.tFixedFlowInput_4Process(ATT_GAT_BOR.java:1650)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at gate.att_gat_bor_0_2.ATT_GAT_BOR.tRouteInput_1Process(ATT_GAT_BOR.java:1111)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at gate.att_gat_bor_0_2.ATT_GAT_BOR.runJobInTOS(ATT_GAT_BOR.java:3985)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.talend.camel.TalendProducer.invokeTalendJob(TalendProducer.java:109)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.talend.camel.TalendProducer.process(TalendProducer.java:65)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:129)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.processor.Pipeline.process(Pipeline.java:118)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.processor.Pipeline.process(Pipeline.java:80)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.component.file.GenericFileConsumer.processExchange(GenericFileConsumer.java:439)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.component.file.GenericFileConsumer.processBatch(GenericFileConsumer.java:211)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.component.file.GenericFileConsumer.poll(GenericFileConsumer.java:175)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.impl.ScheduledPollConsumer.doRun(ScheduledPollConsumer.java:174)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:101)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
INFO   | jvm 1    | 2016/01/07 10:55:46 | 	at java.lang.Thread.run(Thread.java:745)

[Anonymous]

hi,
could you check if the oracle.jdbc.* package is imported in the headers? And indeed - the driver needs to be installed always (as a wrapper!)
Carpe diem
g.

[Anonymous]

Hi,
I don't understand your question. I need to check the headers of what or which component ?
Thx for your help

[Anonymous]

Hello
My idea was to check if the job bundle is started, and if not, , the most probable cause will be 'unsatisfied dependency'. Log in into the TESB console (ssh esb_runtime:8101 or http://esb_runtime:8040/system.console).  Details could be found in the bundle headers (in the tesb CLI console issue command 'headers <bundle id>').  
Using command 'list' you could see if the oracle driver bundle is active (and loaded as a wrapper - hence exporting all its classes, see the post from xldai ).
g.

[Anonymous · Accepted solution]

Hi ,
The solution is to add a PreJob ->tLibraryLoad ->OnComponentOk / OnSubjobOk -> tOracleConnection -> ..
Thanks all for your help