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