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 -----------------------/
/--------------------------------------------------------/
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 |