5 Replies Latest reply on Jan 31, 2006 4:02 PM by chetan aggarwal

    MQ Persistence

    kumaran Newbie

      hi all,
      I am new to Jboss mq . I use maxdb for mq persistence . In the sapdb-jdbc2-service.xml
      i got following entries

      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


      i want to know does jboss create tables JMS_MESSAGES and JMS_TRANSACTIONS or we have create manually. My server log didnt show any error mq status but this two tables are missing in my maxdb database instance and also i want to know is any other table created for mq persistance. any one help me out.
      thanx in advance,
      kumaran

        • 1. Re:  MQ Persistence
          Adrian Brock Master

          Enable debug/trace logging for org.jboss.mq (instructions in the READ THIS FIRST)
          You will see the SQL errors when it tried to create the tables in log/server.log
          Most likley your blob definition is wrong for SAP

          • 2. Re:  MQ Persistence
            Adrian Brock Master

            When you have it working, post the example so I can add it to docs/examples/jms

            • 3. Re:  MQ Persistence
              Pavel Melech Newbie

               

              "adrian@jboss.org" wrote:
              When you have it working, post the example so I can add it to docs/examples/jms

              Hi!
              I am new on this topic. One question: How can I post you example of sapdb-jdbc2-service.xml? I have worked one.

              • 4. Re:  MQ Persistence
                Scott Stark Master

                Add it to this thread by placing the xml configuration between [ code ] ... [ /code ] tags, but don't use the spaces shown here.

                • 5. Re:  MQ Persistence
                  chetan aggarwal Newbie

                  Hi,

                  I am having problem in setting up HA-JMS for oracle.

                  I have followed following link to do it:

                  http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQDB

                  I am even trying to enable logging in log file
                  <category name="org.jboss.mq"
                  priority value="TRACE" class="org.jboss.logging.XLevel"
                  category

                  But even logs are not getting printed for org.jboss.mq

                  I am using following in oracle-jdbc2-service.xml

                  <depends optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=OracleDS

                  BLOB_TYPE=OBJECT_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 (SELECT MAX(TXID) AS TXID FROM JMS_TRANSACTIONS UNION SELECT MAX(TXID) AS TXID FROM JMS_MESSAGES)
                  DELETE_ALL_TX = DELETE FROM JMS_TRANSACTIONS
                  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 MESS WHERE TXOP=:1 AND EXISTS (SELECT TXID FROM JMS_TRANSACTIONS TX WHERE TX.TXID = MESS.TXID)
                  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 OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )
                  CREATE_IDX_MESSAGE_TXOP_TXID = CREATE INDEX JMS_MESSAGES_TXOP_TXID ON JMS_MESSAGES (TXOP, TXID)
                  CREATE_IDX_MESSAGE_DESTINATION = CREATE INDEX JMS_MESSAGES_DESTINATION ON JMS_MESSAGES (DESTINATION)
                  CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER, PRIMARY KEY (TXID) )
                  CREATE_TABLES_ON_STARTUP = TRUE

                  <!-- Uncomment to override the transaction timeout for recovery per queue/subscription, in seconds -->
                  <!--attribute name="RecoveryTimeout">0</attribute-->



                  Nothing is working for me. I am not able to lookup ConnectionFactory , XAConnectionFactory. Even Queues,Topics , PersistanceManager , StateManager are not showing up in JMX-Console.

                  Please some one help.

                  Thanks