2 Replies Latest reply: Oct 21, 2013 6:22 AM by Gellért RSS

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

    Gellért

      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