Anyways I got working finally – as I was having troubles actually committing database inserts. Finally, found out it was because i was using a InnoDB type engine for the my MySQL table. I changed it to MyISAM and it worked fine.
From what I gather MyISAM is always on autocommit and is non-transactional. This tutorial itself doesn’t seem transactional either. Now I was wondering if anyone knows of a tutorial or example that uses the same design i.e. Using Spring to persist the DAO but also being able to use InnoDB engine (i.e. transactional).