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/

Reply via email to