Re: Error Handling in batch execution

Hi Matthias, I'm very sorry for the delay in my answer. This conversation must have slipped through somehow. Indeed, the Loader API has a more explicit way to access errors than the batch update, which returns only the JDBC int[]. There's a way to access the JDBC exceptions through JDBC

Re: Error Handling in batch execution

Hello Lukas, we use mssql Server. I expected a exception if i make an update and the expected primary key does not exist... But mssql and postgres tells the user only that "0 rows affected"... so there is no error ~~ The Loader Api (we use it for inserts) returns a List of LoaderError this

Re: Error Handling in batch execution

Hello Matthias, Thank you very much for your enquiry. What is the failure you're getting / expecting? A constraint violation exception? For what constraint? Also, what database are you using? Cheers, Lukas 2016-09-15 9:31 GMT+02:00 matscheer via jOOQ User Group < jooq-user@googlegroups.com>: >

Error Handling in batch execution

Hi together, i have the following lines of code: int[] execute = getContext().batchUpdate(records).execute(); If one of the updates fail i get only a entry in the execute array... is there an alternative? The DataAccessException of the execute is not thrown. Otherwise i have to search in the