jdbc - number of updated rows

From: Piotr Stelmaszyk <kelman(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl>
To: PgSQL-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: jdbc - number of updated rows
Date: 1999-05-22 10:35:10
Message-ID: 11524.990522@fanthom.math.put.poznan.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Please tell me how to get to know how many rows has method
executeUpdate affected. According to documentation
<cut>
Returns:
either the row count for INSERT, UPDATE or DELETE ...
</cut>
this method should return number of updated rows, but it always
returns 1. It's a feature(bug) of postgresql jdbc-driver?

The only solution for my problem, that I made up is:

turn off auto-commit

select count(*) from table
where tID=5
-- now i (probably)know number of updated rows

update table set ...
where tID=5

commit

turn on auto-commit
-- stupid, isn't it ...

PS. remember that I'm new here...

/--------------------------------------------------------/
/- Piotr Stelmaszyk |---- Student of Computer Science ---/
/------------------ | at Poznan University of Technology /
/----- mailto:kelman(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl ---------/
/----- mailto:kelman(at)alpha(dot)net(dot)pl -----------------------/
/--------------------------------------------------------/

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Garner 1999-05-22 11:36:47 Error with JDBC
Previous Message Piotr Stelmaszyk 1999-05-22 10:24:28 jdbc - getArray