Re: Error with postgresql-8.2-504.jdbc3.jar

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: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Campbell, Lance
Sent: Thursday, March 08, 2007 10:37 AM
To: pgsql-admin(at)postgresql(dot)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