I got you bro. this is my first answer xd. but i have your answer.

In put sql, theres a property called Database Session AutoCommit. IF you set it true the fails will route to the failure.

I cant upload the image of the description (low level xd), but you let the DB driver (the one that is set in the DBCP Connection Pool to take command and do the commits and rollbacks.

Idk exactly all the implications of that. but it works xd