This is fixed in the current cvs version (I remember fixing it about 3
weeks ago).
--
Peter T Mount, Enterprise Support
petermount@it.maidstone.gov.uk
Anything I write here are my own views, and cannot be taken as the
official words of Maidstone Borough Council
-----Original Message-----
From: Piotr Stelmaszyk [mailto:kelman@fanthom.math.put.poznan.pl]
Sent: Saturday, May 22, 1999 11:35 AM
To: PgSQL-interfaces
Subject: [INTERFACES] jdbc - number of updated rows
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@fanthom.math.put.poznan.pl ---------/
/----- mailto:kelman@alpha.net.pl -----------------------/
/--------------------------------------------------------/