[jboss-dev-forums] [JBoss Messaging Development] - JBoss tests with new HSQLDB version

[freddt]

HSQLDB 1.9 is nearing GA release.

This version improves in all areas, including transaction isolation, SQL and JDBC support. But most important for JBoss usage:

* improved reliability with large numbers of large sized row data which caused hsqldb cache purges and ocassional data errors with previous versions in MQ
* new LOB store which stores data at 10-20 MBytes / sec, (up to several terabytes of lobs and no size limit per lob) with data immediately committed to disk, and no time overhead with the MQ update query that is performed on each message cache store
* intended to be a drop-in replacement for the old jar

I would like to get this tested (or test myself) with a load test. Please co-ordinate and suggest the tests to download and run. 

In order to use the LOB store, the table definition in JBoss should change from VARBINARY to BLOB. We may be able to introduce a workaround for this.

Fred Toussi
Maintainer, HSQLDB Project

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4256073#4256073

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4256073