groovy sql not working anymore

      groovy sql not working anymore

      Hi,
      until yesterday I used the following code in a groovy job:

      import groovy.sql.Sql;
      def sql = Sql.newInstance("jdbc:oracle:thin:@127.0.0.1:1521:DYISSG", "DYIS", "*****");
      row = sql.firstRow("SELECT ACT_MONTH, PREV_MONTH FROM DYIS.DATES");

      however since today I get the following error messages:

      java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@127.0.0.1:1521:DYISSG

      anyone had such issue before?

      I'm running on Palo 3.3



      update 24/3/2014
      when I create a connection to Oracle in ETL and test it, everything is fine. Also my groovy job runs fine after I tested the connection...

      Post was edited 2 times, last by “Packo1980” ().