2 Replies Latest reply on Aug 6, 2003 8:48 AM by Mike Finn

    JDBC PM - data?

    Mike Finn Apprentice

      JBoss 3.2.1. Using JDBC PM.

      Seems that messages do not get persisted, even thoguh the delivery mode = persistent on the publisher. JMS_MESSAGES table is always empty. I even changed the SQL in the delete marked messages SQL in jbossmq-service.xml so nothing will be deleted (" AND 1 != 2").

      Same result with HSQL and Oracle as the DB, and using any of the ILs.

      I am investigating a problem where we had several hundred lost messages because we had to restart the server due to JMS hanging. Hopefully, something is just config'd wrong, or I am not understanding the ramifications of the persistent flag (though it seems pretty clear in the spec).

      Any ideas?

      TIA,
      Mike

        • 1. Re: JDBC PM - data?
          Adrian Brock Master

          What type of destination/subscription do you have?
          Messages are only persisted when you have a permenant queue
          or a durable subscription.

          i.e. There is little point persisting messages for
          non-durable topic subscriptions or temporary queues/topics
          as they are lost when the server reboots.

          Regards,
          Adrian

          • 2. Re: JDBC PM - data?
            Mike Finn Apprentice

            Adrian,

            I am using a topic. Subscriber is MDB. I had it declared as durable in XDoclet, but it turns out none of the message-driven-destination content (or anything else besides the basic descr, ejb-name, class, txn type) is being generated by Xdoclet in ejb-jar.xml, so it must be defaulting to non-durable. Once the subscriber is durable, it should work, right?

            I'll fix XDoclet and see where that gets me.

            Thanks,
            Mike