praveen|changing the connection provider to use transaction manager instead of raw connections