java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

[Khouloudy]

Hi all,

I have a strange problem.

I have a basic flow which is working well in Talend Studio(Talend EB); However, when I deploy it in my Talend TOS runtime, I get this error :

karaf@trun>Exception in component tDBConnection_1 (CreateAccountSFA_PS)

java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver cannot be found by sfa.CreateAccountSFA_PS_0.1.0

at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:484)

at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:395)

at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:387)

at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:150)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)

at java.base/java.lang.Class.forName0(Native Method)

at java.base/java.lang.Class.forName(Class.java:315)

at sfa.createaccountsfa_ps_0_1.CreateAccountSFA_PS.tDBConnection_1Process(CreateAccountSFA_PS.java:2072)

I use oracle 12 c , talend esb 7.3.1 and jdk 11.

.

I have tried these changes without sucess :

Add ojdbc8.jar in runtime_esb/container/lib/ext.

Thank you for your help !

Regards,

Khouloud

[Anonymous]

Hello,

Could you please let us know if this community knowledge helps?

https://community.talend.com/s/article/Using-a-tOracleConnection-component-the-Job-fails-when-deploy...

Best regards

Sabrina

[Khouloudy]

Thanks , for your response i add ojdbc8.jar in lib/ext it's wok fine now.But i still have another probleme "exception in component tdbinput_1 java.lang.nullpointerexception".

Any idea?

[Anonymous]

Hello,

What does your job design look like? Did you use any tDBConnection component in your workflow?

Best regards

Sabrina