update/insert hangs on JMS_MESSAGES

[unnijboss]

We moved from HSQL to Oracle as MQ DB. After this we found that the
transactions are waiting at DB level. Then needs to kill those sessions and
restart DB. The messages we are sending is quite large. Is this causing this issue? please help.

It happens after 3 or 4 days.

[unnijboss]

The query

UPDATE JMS_MESSAGES SET MESSAGEBLOB=:1 WHERE MESSAGEID=:2 AND DESTINATION=:3

and

INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(:1,:2,:3,:4,:5)

are the waiting transactions.

[adrian.brock]

"Unnijboss" wrote:
We moved from HSQL to Oracle as MQ DB. After this we found that the
transactions are waiting at DB level. Then needs to kill those sessions and
restart DB. The messages we are sending is quite large. Is this causing this issue? please help.

It happens after 3 or 4 days.

Oracle issue => ask Oracle.

Unless this is the two JBossMQ servers sharing the same database FAQ.

[unnijboss]

Thanks Adrian . Working with DBA to set a different TABLESPACE for the BLOB. Also using Oracle Thin Persistance Manager. Let see...