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/