Add ability to retrieve SQL batch on failure when using BatchSqlUpdate [SPR-10470]

[spring-projects-issues]

Giovanni Botta opened SPR-10470 and commented

When a batch insert/update fails in BatchSqlUpdate, an exception such as the following is thrown:

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO pvaprice_upsert (QuoteId,Ric,Currency,Exchange,TradeDate,PriceClose,PriceHigh,PriceOpen,PriceLow,Vol,creationdate,lastmodifieddate) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)]; SQL state [5000A]; error code [135186]; An attempt to place a null value in a non-nullable datatype.; nested exception is java.sql.BatchUpdateException: An attempt to place a null value in a non-nullable datatype.
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:615)
        at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:884)
        at org.springframework.jdbc.object.BatchSqlUpdate.flush(BatchSqlUpdate.java:184)

It would be very useful to be able to retrieve the batch that failed in order to look at the data to diagnose why the failure happened. This shouldn't be too difficult (I might give it a try over the weekend).

Thanks

---

Affects: 3.2.1

[spring-projects-issues]

Bulk closing outdated, unresolved issues. Please, reopen if still relevant.