[jboss-user] [JBoss Messaging] - persistenceSql.properties for oracle

Hi , I was trying to configure jboss messaging 1.4.2 cr2 with jboss4.2.1 GA and setting up jms sql properties and getting errors State: RUNNING I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS , ObjectName: jboss.messaging:service=PersistenceManager State: FAILED Reason: java.lang.IllegalArgumentException: No such SQL statement: DELETE_MESSAGES_REF_WITH_TX I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS jboss:service=TransactionManager Depends On Me: jboss.messaging:service=ServerPeer , ObjectName: jboss.messaging:service=PostOffice State: CREATED I Depend On: jboss.messaging:service=ServerPeer jboss.jca:service=DataSourceBinding,name=DefaultDS jboss:service=TransactionManager Depends On Me: jboss.messaging.connectionfactory:service=ConnectionFactory jboss.messaging.connectionfactory:service=ClusteredConnectionFactory jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory jboss.messaging.destination:service=Queue,name=DLQ jboss.messaging.destination:service=Queue,name=ExpiryQueue jboss.messaging.destination:service=Topic,name=testTopic jboss.messaging.destination:service=Topic,name=securedTopic jboss.messaging.destination:service=Topic,name=testDurableTopic jboss.messaging.destination:service=Queue,name=testQueue jboss.messaging.destination:service=Queue,name=A jboss.messaging.destination:service=Queue,name=B jboss.messaging.destination:service=Queue,name=C jboss.messaging.destination:service=Queue,name=D jboss.messaging.destination:service=Queue,name=ex jboss.messaging.destination:service=Queue,name=PrivateDLQ jboss.messaging.destination:service=Queue,name=PrivateExpiryQueue jboss.messaging.destination:service=Queue,name=QueueWithOwnDLQAndExpiryQueue jboss.messaging.destination:service=Topic,name=TopicWithOwnDLQAndExpiryQueue jboss.messaging.destination:service=Queue,name=QueueWithOwnRedeliveryDelay jboss.messaging.destination:service=Topic,name=TopicWithOwnRedeliveryDelay jboss.messaging.destination:service=Queue,name=testDistributedQueue jboss.messaging.destination:service=Topic,name=testDistributedTopic , ObjectName: jboss.messaging:service=JMSUserManager State: RUNNING I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS jboss:service=TransactionManager Depends On Me: jboss.messaging:service=ServerPeer , ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo State: RUNNING I Depend On: jboss:service=TransactionManager jboss.jca:service=DataSourceBinding,name=DefaultDS Is there a place where i can look at the this property file.We have our application running on jboss3.2.7 with the following properties BLOB_TYPE=BINARYSTREAM_BLOB INSERT_TX = INSERT INTO JMS_TRANSACTIONS (TXID) values(?) INSERT_MESSAGE = INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?) SELECT_ALL_UNCOMMITED_TXS = SELECT TXID FROM JMS_TRANSACTIONS SELECT_MAX_TX = SELECT MAX(TXID) FROM JMS_MESSAGES SELECT_MESSAGES_IN_DEST = SELECT MESSAGEID, MESSAGEBLOB FROM JMS_MESSAGES WHERE DESTINATION=? SELECT_MESSAGE = SELECT MESSAGEID, MESSAGEBLOB FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=? MARK_MESSAGE = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=? UPDATE_MESSAGE = UPDATE JMS_MESSAGES SET MESSAGEBLOB=? WHERE MESSAGEID=? AND DESTINATION=? UPDATE_MARKED_MESSAGES = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=? UPDATE_MARKED_MESSAGES_WITH_TX = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=? AND TXID=? DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES WHERE TXID IN (SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP=? DELETE_TX = DELETE FROM JMS_TRANSACTIONS WHERE TXID = ? DELETE_MARKED_MESSAGES = DELETE FROM JMS_MESSAGES WHERE TXID=? AND TXOP=? DELETE_TEMPORARY_MESSAGES = DELETE FROM JMS_MESSAGES WHERE TXOP='T' DELETE_MESSAGE = DELETE FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=? CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, \ DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), \ MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION) ) CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER ) CREATE_TABLES_ON_STARTUP = TRUE what are the changes required if i am using jboss messaging 1.4.2cr2 on jboss4.2.1GA. Any help appreciated. Thanks Sri View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4082277#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...