Another thing. If you are getting the following exception
14:41:28,307 WARN [ServiceController] Problem starting service
jboss.mq:service=PersistenceManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions.
Message recovery may not be accurate; - nested throwable:
(java.
The missing alias in the sql statement has been fixed in branch40 and head
http://jira.jboss.com/jira/browse/JBAS-2424
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3906569#3906569
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mo
When I appended "AS TR_TABLE" to the statement, JBoss just hung on startup.
Actually the query just hung.
This may be related to this MySQL bug:
http://bugs.mysql.com/bug.php?id=8726
I had MySQL 4.1.10a and just updated to 4.1.13, now the statement executes
normal.
And of course JBoss now also
I was able to get it to werk using the following:
SELECT_MAX_TX = SELECT MAX(TXID) FROM (SELECT * FROM (SELECT MAX(TXID) AS TXID
FROM JMS_TRANSACTIONS) AS T UNION SELECT * FROM (SELECT MAX(TXID) AS TXID FROM
JMS_MESSAGES) AS M) AS Main
You needed two other aliases to make it all werkerize
Vie
I used
anonymous wrote : SELECT MAX(TXID) FROM (SELECT MAX(TXID) AS TXID FROM
JMS_TRANSACTIONS UNION SELECT MAX(TXID) AS TXID FROM JMS_MESSAGES) AS TR_TABLE
And i still hav ehte same error :O
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3900241#3900241
Rep
10x
I'll try the solution...
cant think of a more generic sql sorry.. :/
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3900235#3900235
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3900235
--
This is because of this issue:
http://jira.jboss.com/jira/browse/JBAS-2056
I've tested in a MySQL database and it worked, later on I've tested in another
database and didn't work. This same query also works on Oracle.
We need a more generic query. Do you have any?
Clebert
View the original