1 Reply Latest reply: Dec 1, 2009 4:12 AM by 807580 RSS

    scrollable resultset

    807580
      Hi,
      I am using the "net.sourceforge.jtds.jdbc.Driver" to connect to the sql server. I tried to use scrollable resultset since I was to use rs for many times in my program. I am getting this exception while going through the rs. Please suggest.




      I have changed the rs to the scrollable one. When I iterate through the rs object I am getting different exception..

      java.sql.SQLException: No current row in the ResultSet.
      at net.sourceforge.jtds.jdbc.MSCursorResultSet.getColumn(MSCursorResultSet.java:248)
      at net.sourceforge.jtds.jdbc.JtdsResultSet.getString(JtdsResultSet.java:930)
      at net.sourceforge.jtds.jdbc.JtdsResultSet.getString(JtdsResultSet.java:1217)
      at DB2.getDetails(DB_PDF_Generator.java:222)
      at DB_PDF_Generator.main(DB_PDF_Generator.java:107)