[jboss-user] [Messaging, JMS & JBossMQ] - 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=4082273#4082273

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