Batch Update updatecounts when error happens

Поиск
Список
Период
Сортировка
Искать
От
Padraic Renaghan
Тема
Batch Update updatecounts when error happens
Дата
Msg-id
1030560811.3d6d1c2b7f51e@mail.montanab.com
Список
Дерево обсуждения
Re: Batch Update updatecounts when error happens Barry Lind <barry@xythos.com>
Re: Batch Update updatecounts when error happens Padraic Renaghan <list@renaghan.com>
I'm having trouble with the error handling of the batch update feature of the 
JDBC 2.0 Postgresql driver. I do not see the standard behavior of returing a -3 
for the statement that failed.

In my example I insert mutliple rows in a single batch into a table. All the 
inserts have the same key value, which causes the second insert to fail with a 
duplicate key error.

I get thrown back the BatchUpdateException which has the updateCounts array 
which I access via getUpdateCounts(). That array contains a single entry, 
updateCounts[0]=1. I am not seeing the -3 entry to indicate the stmt that 
failed. According to my assumptions about how JDBC 2.0 batch updates are 
supposed to work (and according to the JDBC--Postgresql compatability web page) 
I was hoping to see the updateCounts array contain:
updateCounts[0]=1
updateCounts[1]=-3

I'm currently using Postgresql 7.2 and the JDBC driver installed with the 
Postgresql distributed rpm. Specifically I'm using jdbc7.2dev-1.2.jar

Any help would be appreciated.

Thanks
Padraic
В списке pgsql-jdbc по дате отправления
От: Michael Paesold
Дата:
От: Padraic Renaghan
Дата:
FAQ