We have resolved this issue by clearing up JMS_messages and JMS_transactions table in
HSQLDB, by deleting the records in these table. We can delete the records by adding the
delete statement in hsqldb-jdbc2-servcie.xml file and then starting the JBoss again. This
will delete all the pending queues and messages and clear the DB, so that we can re-use
it. Once we clear the DB, we need to remove the delete statements from the above file and
restart JBoss again, so that it builds up again the transactions and messages in the
queue.
I have posted the above solution so that if some one is facing the issue similar to us
this will help them. Hope this will help someone facing similar problem.
Thanks.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4011822#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...