2 Replies Latest reply on May 24, 2011 9:37 AM by yashgarg

    Queue count from Database

    yashgarg
    yashgarg May 12, 2011 2:35 PM

      Hi,

       

      How can I get the count of the queues from the database with their respective status. What will be the SQL.

       

      Thanks,

       

      Yash

      • 3034 Views
      • Tags:
        • 1. Queue count from Database
          mp911de
          mp911de May 23, 2011 3:03 PM (in response to yashgarg)

          Hi Yash,

          Database for getting such things is a very bad idea....

          Access this information via MBeans, they can say you everything you need (take a look at /jmx-console of your server). You get access to your MBeans via MBeanServerLocator (JBoss Class)

           

          Best regards,

          Mark

            • Actions
          • 2. Re: Queue count from Database
            yashgarg
            yashgarg May 24, 2011 9:37 AM (in response to mp911de)

            Hi Mark,

             

            I know this can be very expensive, but this is to relate some other DB tables for our internal process which can not be done with MBeans, and this is not on regular basis. I will appreciate if I can get the queries for the same.

             

            Thanks,

             

            Yash

              • Actions