I'll appreciate any help or advice.
I'm trying to make a connection between jboss 3.2.1-tomcat 4.1.24 and postreSQL 7.3.4.
My postgreSQL works fine (I can read & write to the DB from a java class), but when I try to communicate the DB from my jboss i get the following message:
11:43:19,552 ERROR [PersistenceManager] Starting failed
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not b
e accurate; - nested throwable: (java.sql.SQLException: ERROR: Relation "jms_messages" does not exi
at sun.reflect.GeneratedMethodAccessor40.invoke(Unknown Source)
I tried to change in jbossmq-service.xml:
DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES WHERE TXID IN (SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP=?
DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES WHERE TXID IS NOT NULL AND TXOP=?
like I saw in a few posts in this forum.
I did of course all the changes in :
If the problem is that the jboss is trying to create a table in Hypersonic DB, what can I do to prevent that?
If this isn't the problem, than what is it?
thank you in advanced,