I have an audit functionality in my application that on some specific opreations, updates some database tables. This is being done using old
jdbc way and has commit and rollback statements.
I wish to externalize this functionality(as a jar). What is the good way to do it, can jdbcTemplate be returned as an object to this external jar and then the jar takes over from there, is it good to do so? How do I achieve commit and rollback functionality using a jdbcTemplate object? or are there better alternatives?