topic Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver in Talend Studio

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

Khouloudy — Sat, 16 Nov 2024 01:13:31 GMT

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

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

Anonymous — Wed, 28 Oct 2020 11:09:23 GMT

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-deployed-in-Runtime-with-a-java-lang-NoClassDefFoundError-oracle-jdbc-OracleDriver-error-message-tTkC8

Best regards

Sabrina

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

Khouloudy — Wed, 28 Oct 2020 14:59:36 GMT

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?

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

Anonymous — Fri, 30 Oct 2020 07:37:27 GMT

Hello,

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

Best regards

Sabrina