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

Gell�rt-Oracle · Oct 18, 2013 9:56AM

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.

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

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

Philip Stoyanov-Oracle · Oct 18, 2013 10:52AM

if you look at examples you'll see following statement before getConnectionon...

java.lang.Class.forName ("oracle.jdbc.OracleDriver");

Philip

Gell�rt-Oracle · Oct 21, 2013 3:40AM

That line was missing from the second example. However my problem is infrastructure related:

java.lang.Class.forName ("oracle.jdbc.OracleDriver"); --->Wrapped java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

I used Data Modeler 4.0.0.825. This could be related to the custom java home used by my installation.

The same code works with version "3.3.0.747 jre included"

Forum Stats