From: | "Campbell, Lance" <lance(at)uiuc(dot)edu> |
---|---|
To: | "Campbell, Lance" <lance(at)uiuc(dot)edu>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Error with postgresql-8.2-504.jdbc3.jar |
Date: | 2007-03-08 17:14:00 |
Message-ID: | A3AC4FA47DC0B1458C3E5396E685E63302395D0F@SAB-DC1.sab.uiuc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
________________________________
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
From | Date | Subject | |
---|---|---|---|
Next Message | Lukas | 2007-03-08 20:02:07 | Pg_dump and bytaA |
Previous Message | Campbell, Lance | 2007-03-08 16:37:03 | Error with postgresql-8.2-504.jdbc3.jar |