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

    Queue count from Database

    Yash Garg Newbie

      Hi,

       

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

       

      Thanks,

       

      Yash

        • 1. Queue count from Database
          Mark Paluch Master

          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

          • 2. Re: Queue count from Database
            Yash Garg Newbie

            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