I"ll check if we can get the more specific cause exception.

1. JBERET-328

Consider throwing more specific exceptions instead of BatchUpdateException in JdbcItemWriter

The above issue is fixed now.  To achieve what you described in the original post, it really depends on the target DBMS and jdbc driver, whether it throws fined-grained exception types.  For instance, the database engine and driver may just throw the same exception for all PK, FK & UK errors.