Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Sheetal1
Contributor
Contributor

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

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
Labels (4)
3 Replies
Anonymous
Not applicable

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....
Best regards
Sabrina
Sheetal1
Contributor
Contributor
Author

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
0683p000009MBVM.png
0683p000009MBIq.png
Sheetal1
Contributor
Contributor
Author

Hi Sabrina,
I am able to connect successfully to Oracle 11g Database. 0683p000009MACn.png
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