Multi insert statement and getUpdateCount().

Поиск
Список
Период
Сортировка
От Jeremy Whiting
Тема Multi insert statement and getUpdateCount().
Дата
Msg-id 551434D9.6040906@redhat.com
обсуждение исходный текст
Ответы Re: Multi insert statement and getUpdateCount().
Список pgsql-jdbc
Hi,
  I have been testing the current version of pgjdbc master branch. I
added a test case to a branch in my repo [1] to check the behaviour when
a multi insert statement adds two rows to a table. I found the return
value when calling .getUpdateCount() does not equal the number of rows
affected.

  My question is what should the return value for .getUpdateCount()
represent. Is it the number of statements executed or rows put in the
database ?

Regards,
Jeremy

[1]
https://github.com/whitingjr/pgjdbc/tree/updatecount-mismatches-updatecount

--
Jeremy Whiting
Senior Software Engineer, JBoss Performance Team
Red Hat

------------------------------------------------------------
Registered Address: RED HAT UK LIMITED, 64 Baker Street, 4th Floor, Paddington. London. United Kingdom W1U 7DF
Registered in UK and Wales under Company Registration No. 3798903  Directors: Michael Cunningham (US), Charles Peters
(US),Matt Parson (US) and Michael O'Neill(Ireland) 



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

Предыдущее
От: Jeremy Whiting
Дата:
Сообщение: Resurrected thread: Speed improvement - Group batch Insert - Rewrite the INSERT at the driver level (using a parameter)
Следующее
От: dmp
Дата:
Сообщение: Re: Multi insert statement and getUpdateCount().