Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unnesasary TRace messages seen for "IF @@TRANCOUNT > 0 COMMIT TRAN"

843859Nov 20 2007 — edited Nov 20 2014
Hi,
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2007
Added on Nov 20 2007
0 comments
174 views