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