Skip site navigation (1) Skip section navigation (2)

BUG #1233: JDBC driver: moveToCurrentRow fails

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1233: JDBC driver: moveToCurrentRow fails
Date: 2004-08-27 09:59:55
Message-ID: 20040827095955.E1D035A1154@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1233
Logged by:          David Bucciarelli

Email address:      dbucciarelli(at)tradesoft(dot)it

PostgreSQL version: 7.4.3

Operating system:   Linux Suse 9.0

Description:        JDBC driver: moveToCurrentRow fails

Details: 

The method moveToCurrentRow in the ResultSet class of the  JDBC driver fails 
with the following message:  

"Result Set not updateable. The query that generated this result set must 
select only one table, and must select all primary keys from that table. See 
the JDBC 2.1 API Specification, section 5.6 for more details." 

even if the query _include_ all primary keys and selects only one table (the 
same code works fine with other JDBC drivers: i.e. MySql). 

I guess this happen because the code at line 679 of the 
org.postgresql.jdbc2.AbstractJdbc2ResultSet.moveToCurrentRow should be: 

if ( !isUpdateable() )

instead of:

if (!updateable)

Thanks and my best regards,
David Bucciarelli




Responses

pgsql-bugs by date

Next:From: PostgreSQL Bugs ListDate: 2004-08-27 12:17:47
Subject: BUG #1234: prepared statements and libpq don't work as expected
Previous:From: Steve IngramDate: 2004-08-27 06:00:50
Subject: Apologies if you don't consider this a bug and I've wasted your time.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group