topic Facing issue to connect Oracle 11g db through Talend open studio in Talend Studio

Facing issue to connect Oracle 11g db through Talend open studio

Sheetal1 — Thu, 08 Sep 2016 11:36:18 GMT

Hi All,
I am trying to connect oracle 11g db through Talend open studio for Data Integration Version: 6.1.1
However I am getting following error:
Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
      at java.net.URLClassLoader.findClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:121)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:146)
      ... 9 more

Connection details attaching herewith:

Can you please help me what is the exact problem?
Thanks,
Sheetal

Re: Facing issue to connect Oracle 11g db through Talend open studio

Anonymous — Fri, 09 Sep 2016 04:18:24 GMT

Hi,
Did you see ojdbc6 installed completely in module view? Can you successfully connect your Oracle DB through client without using talend tool?
What does your J AVA_HOME look like?
Here is a related forum about this issue:https://community.talend.com/t5/Installing-and-Upgrading/resolved-connection-failure-you-must-change-db-settings-talend-6/td-p/61651.
Best regards
Sabrina

Re: Facing issue to connect Oracle 11g db through Talend open studio

Sheetal1 — Mon, 12 Sep 2016 05:47:44 GMT

Hi Sabrina,
Yes, you are correct. I am facing the same problem as per blog suggested by you.
I already went through that. But didnt get any solution.
I am able to see ojdbc6.jar and ojdbc7.jar installed.
Please find attached herewith.

Could you please let me know more about JAVA_PATH? Do I need to set the path where my JRE is installed or else?
Dont know much about this.
Connection details are as following:

Thanks,
Sheetal

Re: Facing issue to connect Oracle 11g db through Talend open studio

Sheetal1 — Mon, 12 Sep 2016 10:22:54 GMT

Hi Sabrina,
I am able to connect successfully to Oracle 11g Database.
I have followed: https://help.talend.com/search/all?query=Installing+external+modules&content-lang=en
I have Copied ojdbc6.jar file in location: <Open Studio Installation path>\workspace\.Java\lib
Thanks for your guidance
Sheetal