Forum Discussion

ATM's avatar
ATM
Occasional Contributor
16 years ago

DataSink Oracle error "No group 9"

Whenever I try to test my oracle DataSink connection info, i get this error:
"Can't get the Connection for specified properties; java.lang.IndexOutOfBoundsException: No group 9"
If I try to Build Query after using the Configure option, I just get the Error "No group 9"

Driver: oracle.jdbc.driver.OracleDriver
Connection String: jdbc:oracle:thin:WMGBUS/PASS_VALUE@edmoid03.usa.wachovia.net:9901:EastWealthOpsDS
soapUI ver.: 3.5-beta1 (also failed in 3.0.1)
ojdbc5.jar in soapUI's jre/lib/ext
  • ATM's avatar
    ATM
    Occasional Contributor
    16 years ago
    Bah, whatever, this in a Groovy step works just as well:

    import java.io.*;
    import java.sql.*;
    import oracle.jdbc.driver.*;
       
        try
    {
          Connection con=null;
    ResultSet rs = null;
    String output;

          Class.forName("oracle.jdbc.driver.OracleDriver");
          //Get connected to database
          con=DriverManager.getConnection(
        "jdbc:oracle:thin:@machine_name:1521:database_name",
            "USERNAME",
            "PASSWORD");
          Statement s=con.createStatement();
          //The SQL to execute
          rs = s.executeQuery("select COUNT(*) from TABLE");

          //doing one "next" to set the cursor on the first element
      rs.next();

    //output results until resultset is out of elements
    while(!rs.isAfterLast())
    {
    //Get's the data from Xth column of this row in the resultset
    //ex: select dude,sweet from wherecartable
    //rs.getString(1) gets data from dude and rs.getString(2) gets data from sweet

    output = rs.getString(1);
    log.info(output);
    rs.next();
    }


          s.close();
          con.close();
      }
      catch(Exception e)
      {
      e.printStackTrace();
      }