HSQLDB Message Serialization error

[zumbiehl]

Hi,

I get the following error when MQ tries to store a MapMessage in the table JMS_MESSAGE and I am using an instance of HSQLDB other than the default (port 1701) one.

Caused by: java.sql.SQLException: Serialization failure: org.jboss.mq.SpyMapMess
age in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB,
TXID, TXOP) VALUES(0,'QUEUE.HubCommand','aced00057372001a6f72672e6a626f73732e6d712e5370794d61704d657373616765bbc10eb0da40342b0c0000787200176f72672e6a626f73732e....

When I change my hsqldb-ds.xml to make the DefaultDS point to another DB, that's when I get those serializable failures ..

<connection-url>jdbc:hsqldb:hsql://localhost</connection-url>


What Am I doing wrong ?

thanks for your help
christian

[adrian.brock]

You need to define the correct blob type for
your database in the jdbc2 persistence manager
config. jbossmq-service.xml

Regards,
Adrian

[zumbiehl]

Thanks for your reply ,
but the database I am using is still HSQLDB , the BLOB type shouldn't be different should it ?
It's just not the default instance started up by JBOSS

cheers
christian

[adrian.brock]

You should probably ask the HSQLDB people.

Are you using the same versions?

Regards,
Adrian