[jboss-jira] [JBoss JIRA] Closed: (JBMESSAGING-825) Transactions corrupted because sybase truncates trailing zeros

Transactions corrupted because sybase truncates trailing zeros -------------------------------------------------------------- Key: JBMESSAGING-825 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-825 Project: JBoss Messaging Issue Type: Bug Affects Versions: 1.2.0.Beta2 Reporter: Tim Fox Assigned To: Tim Fox Fix For: 1.2.0.CR1 Sybase has the wonderful characteristic of truncating trailing zeros in VARBINARY columns. So If I set a byte array with values: 1, 2, 3, 4, 5, 0, 0, 0 Then I get back a byte array with values: 1, 2, 3, 4, 5 Xid global txids and branch qualifiers can have trailing zeros since they can become corrupt after storing and retrieving in the database. Solution is to introduce a flag "usingTrailingByte" on the pm config. If true then a non zero byte will always be appended to the byte[] before storing and removed on retrieval. This flag should be true for sybase config and false for others.