This content has been marked as final.
Show 3 replies
-
1. Re: update/insert hangs on JMS_MESSAGES
unnijboss Jul 21, 2008 1:57 PM (in response to 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. -
2. Re: update/insert hangs on JMS_MESSAGES
adrian.brock Jul 25, 2008 9:01 AM (in response to unnijboss)"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. -
3. Re: update/insert hangs on JMS_MESSAGES
unnijboss Jul 25, 2008 5:54 PM (in response to unnijboss)Thanks Adrian . Working with DBA to set a different TABLESPACE for the BLOB. Also using Oracle Thin Persistance Manager. Let see...