jdbc - number of updated rows

Поиск
Список
Период
Сортировка
От Piotr Stelmaszyk
Тема jdbc - number of updated rows
Дата
Msg-id 11524.990522@fanthom.math.put.poznan.pl
обсуждение исходный текст
Список 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@fanthom.math.put.poznan.pl ---------/
/----- mailto:kelman@alpha.net.pl -----------------------/
/--------------------------------------------------------/




В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Piotr Stelmaszyk
Дата:
Сообщение: jdbc - getArray
Следующее
От: Peter Garner
Дата:
Сообщение: Error with JDBC