Postgres Pro
Downloads
Home   >   mailing lists

Re: Error with postgresql-8.2-504.jdbc3.jar - Mailing list pgsql-admin

From Campbell, Lance
Subject Re: Error with postgresql-8.2-504.jdbc3.jar
Date
Msg-id A3AC4FA47DC0B1458C3E5396E685E63302395D0F@SAB-DC1.sab.uiuc.edu
Whole thread Raw
In response to Error with postgresql-8.2-504.jdbc3.jar  ("Campbell, Lance" <lance@uiuc.edu>)
List pgsql-admin
Tree view

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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] 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(AbstractJdbc2ResultSet.java:190)

      at org.postgresql.jdbc2.AbstractJdbc2ResultSet.absolute(AbstractJdbc2ResultSet.java:196)

      at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.absolute(DelegatingResultSet.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

 

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Error with postgresql-8.2-504.jdbc3.jar
Next
From: "Lukas"
Date:
Subject: Pg_dump and bytaA