Has anyone applied the JDBC abstraction framework and used based JDBC transaction management (e.g. commit, rollback)?

I like the idea of "hiding" direct access to JDBC - but don't understand how this could be accomplished without adding utilities for setting the auto commit mode, starting transactions, rolling back partially completed transactions and manually committing???