Spring Transaction Management and Oracle Stored Procedures

I am currently integrating transaction management in my code.

I am trying to tune it to stored procedures that already exist.

Stored procedures are committed at the end of them.

In my eclipse console, I see how transaction control code is called

datasource.DataSourceTransactionManager Initiating transaction rollback
datasource.DataSourceTransactionManager Rolling back JDBC transaction on Connection [oracle.jdbc.driver.LogicalConnection@1544055]
datasource.DataSourceTransactionManager Releasing JDBC Connection [oracle.jdbc.driver.LogicalConnection@1544055] after transaction

But I still see the rest of the record that should have been dropped in my database tables.

If we use spring transaction management, should we remove all commits from our stored procedures?

Thanks Damien

+3
source share

All Articles