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