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.<\/p>\n
To clear the transaction log open up Sybase SQL Advantage and log in. Once log in execute the following statement:<\/p>\n
\ndump transaction <DATABASE NAME> with no_log\n<\/pre>\nOnce I run this command my JUnit tests continue without a hitch.<\/p>\n
Technorati Tags: sybase<\/a>, database<\/a>, sql<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":""},"categories":[23,3],"tags":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p902K-1g","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/posts\/78"}],"collection":[{"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/comments?post=78"}],"version-history":[{"count":0,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/posts\/78\/revisions"}],"wp:attachment":[{"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/media?parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/categories?post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/tags?post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}