Unnesasary TRace messages seen for "IF @@TRANCOUNT > 0 COMMIT TRAN"
843859Nov 20 2007 — edited Nov 20 2014Hi,
I have a Java appication running which continiously writes data into a database through a stored procedure.If you view the SQLProfiler trace we get trace mesages as follows:
IF @@TRANCOUNT > 0 COMMIT TRAN
In the Java code I have set connection.setAutocommit(false);
Here for every commit opeartion.I get the message "IF @@TRANCOUNT > 0 COMMIT TRAN ".
This creates locks issues ad slows down the performance.
I will be very thankful is someone guides me for a solution.