i am using the "delete from activemq_msgs" for deleting the record from the database. and i found that the activemq_msgs would become empty, however, once restart the client, it can still retrieve the data from the broker.
James.Strachan wrote: > > To store just in the database and not in the journal then use > <jdbcPersistenceAdapter/>. > > I don't really understand what SQL operations you carried out so can't > really vouch for what that would have done - to prune a queue I'd > recommend using the MBeans / JConsole instead. > > On 1/11/07, Lok Yu <[EMAIL PROTECTED]> wrote: >> >> Dear experts, >> >> I have tried to use the config.xml for the broker like that >> >> <persistenceAdapter> >> <jdbcPersistenceAdapter dataSource="#mysql-ds"/> >> </persistenceAdapter> >> >> AND ALSO >> >> <persistenceAdapter> >> <journaledJDBC useJournal="false" >> dataSource="#mysql-ds"/> >> </persistenceAdapter> >> >> but i discover that when i deleted all the data which haven't publishws >> to >> the client in the activemq_msgs table in the broker, however, when i >> start >> the client connection to the broker, it can still receive the message >> from >> broker. >> >> can i switch the broker to the mode that message in the broker would only >> store in the database but not elsewhere. >> >> Thanks for answering. >> -- >> View this message in context: >> http://www.nabble.com/how-to-set-the-message-of-the-broker-will-store-in-the-mySQL-only-tf2957449.html#a8273313 >> Sent from the ActiveMQ - User mailing list archive at Nabble.com. >> >> > > > -- > > James > ------- > http://radio.weblogs.com/0112098/ > > -- View this message in context: http://www.nabble.com/how-to-set-the-message-of-the-broker-will-store-in-the-mySQL-only-tf2957449.html#a8290674 Sent from the ActiveMQ - User mailing list archive at Nabble.com.
