Sorry, I did not realize that you need to pass two additional parameters to the connection method when creating a statement that will use a ResultSet and method "absolute":
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Campbell, Lance Sent: Thursday, March 08, 2007 10:37 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Error with postgresql-8.2-504.jdbc3.jar I get the following error when using postgreSQL 8.2.x and postgresql-8.2-504.jdbc3.jar: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkScrollable(AbstractJdbc 2ResultSet.java:190) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.absolute(AbstractJdbc2Result Set.java:196) at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.absolute(DelegatingResul tSet.java:334) Is the method "absolute(int)" not allowed on a ResultSet object in jdbc3? Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu
