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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Campbell, Lance
Sent: Thursday, March 08, 2007 10:37 AM
To: pgsql-admin@xxxxxxxxxxxxxx
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

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux