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

[sansunsru]

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#4082277

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4082277