Re: Delete queues from JDBC storage

2011-08-22 Thread Dejan Bosanac
AM, Pham Ngoc Hai wrote: > So deleting directly from DB is not an option? even when I stop the broker? > > Regards, > Ngoc Hai > > > > > --- On Fri, 8/19/11, Hervé BARRAULT wrote: > > > From: Hervé BARRAULT > > Subject: Re: Delete queues from JDBC

Re: Delete queues from JDBC storage

2011-08-20 Thread Hervé BARRAULT
> > --- On Fri, 8/19/11, Hervé BARRAULT wrote: > > > From: Hervé BARRAULT > > Subject: Re: Delete queues from JDBC storage > > To: users@activemq.apache.org > > Date: Friday, August 19, 2011, 6:39 PM > > Hi, > > For the purge mechanism i have found on

Re: Delete queues from JDBC storage

2011-08-19 Thread Pham Ngoc Hai
So deleting directly from DB is not an option? even when I stop the broker? Regards, Ngoc Hai --- On Fri, 8/19/11, Hervé BARRAULT wrote: > From: Hervé BARRAULT > Subject: Re: Delete queues from JDBC storage > To: users@activemq.apache.org > Date: Friday, August 19, 2011,

Re: Delete queues from JDBC storage

2011-08-19 Thread Hervé BARRAULT
> >> I tried with JMX and it took a few hours to purge a queue with 50000 > msgs. > >> > >> > >> > >> --- On Thu, 8/18/11, Dejan Bosanac wrote: > >> > >> > From: Dejan Bosanac > >> > Subject: Re: De

Re: Delete queues from JDBC storage

2011-08-19 Thread Gary Tully
>> >> > From: Dejan Bosanac >> > Subject: Re: Delete queues from JDBC storage >> > To: users@activemq.apache.org >> > Date: Thursday, August 18, 2011, 6:36 PM >> > Why don't you delete it using JMX or >> > web console? >>

Re: Delete queues from JDBC storage

2011-08-19 Thread Hervé BARRAULT
eue with 5 msgs. > > > > --- On Thu, 8/18/11, Dejan Bosanac wrote: > > > From: Dejan Bosanac > > Subject: Re: Delete queues from JDBC storage > > To: users@activemq.apache.org > > Date: Thursday, August 18, 2011, 6:36 PM > > Why don't you de

Re: Delete queues from JDBC storage

2011-08-18 Thread Pham Ngoc Hai
I tried with JMX and it took a few hours to purge a queue with 5 msgs. --- On Thu, 8/18/11, Dejan Bosanac wrote: > From: Dejan Bosanac > Subject: Re: Delete queues from JDBC storage > To: users@activemq.apache.org > Date: Thursday, August 18, 2011, 6:36 PM > Why don't

Re: Delete queues from JDBC storage

2011-08-18 Thread Dejan Bosanac
Why don't you delete it using JMX or web console? Regards -- Dejan Bosanac - http://twitter.com/dejanb - The experts in open source integration and messaging - http://fusesource.com ActiveMQ in Action - http://www.manning.com/snyder/ Blog - http://www.nighttale.net On Thu, Aug 1

Delete queues from JDBC storage

2011-08-18 Thread Pham Ngoc Hai
Hi, I'm using JDBC as storage, is it sufficient to delete a queue by deleting it from the tables with DELETE FROM activemq_msgs where container='queue://name' DELETE FROM activemq_acks where container='queue://name' Regards, Ngoc Hai