My Oracle Support Banner

"java.lang.RuntimeException: Java.lang.ClassNotFoundException: Oracle.jdbc.OracleDriver" In Talend Studio (Doc ID 2747075.1)

Last updated on AUGUST 01, 2023

Applies to:

JDBC - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

On : 19.3 version, Thin JDBC driver

Problem with connection from Talend Open Studio to the Oracle Database.

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:204)
  at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1139)
  at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
  at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
  at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4189)
  at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.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:124)
  at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:149)
  ... 9 more

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.