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 по дате отправления: