Sybase Transaction Log

One of the database vendors that my company supports is Sybase. We have a Sybase database which we hit from JUnit tests but every once in a while a Sybase specific JUnit test will just freeze. I found out that the JUnit test would freeze because the Sybase transaction log would fill up and need to be cleared.

To clear the transaction log open up Sybase SQL Advantage and log in. Once log in execute the following statement:

dump transaction <DATABASE NAME> with no_log

Once I run this command my JUnit tests continue without a hitch.

Technorati Tags: , ,