After playing with jOOQ as an alternative to my JdbcTemplate wrapper I finally got transactions to work properly.

You can read more about on StackOverflow: JOOQ and Spring.