SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cannot connect to oracle from transformation script (driver not found)

Gell�rt-OracleOct 18 2013 — edited Oct 21 2013

Given the following code in a transformation script:

importPackage(java.sql);

conn = java.sql.DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:db1", "ueser", "passw");

stmt = conn.createStatement();

rset = stmt.executeQuery("SELECT * FROM DUAL");

rset.close();

stmt.close();

conn.close();

The error message is:

No suitable driver found for jdbc:oracle:thin:@localhost:1521:db1

I even tried to add the below lines to "Third Party JDBC Drivers", but it did not help.

D:\oracle\product\12.1.0\dbhome\jdbc\lib\ojdbc7.jar

D:\oracle\product\12.1.0\dbhome\jlib\orai18n.jar

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2013

Added on Oct 18 2013

#data, #jdbc, #script

2 comments

454 views