All of ActiveMQ's messages are stored in that activemq_msgs table, at least when you're sending persistent messages. Create a durable subscription on your topic and send some persistent messages to it, you'll see new entries get added to activemq_msgs. Note that once a message is ack'd it's removed from the table, so if you want to save messages you could set up a mirrored queue to keep those messages around, have a look at http://activemq.apache.org/mirrored-queues.html
On Tue, Sep 14, 2010 at 1:17 PM, pp <preeti.pada...@gmail.com> wrote: > > hi, > > Do the topics are saved in the activemq database itself or we have > to handle it. if it automatically store on the activemq database then where > these tables are present. We are using the external database MySql. But it > is showing only three tables activemq_acks, activemq_msgs, activemq_lock. > Where are the other tables present like table for topic. > > Any help is appreciable. > > Thanks > -- > View this message in context: > http://activemq.2283324.n4.nabble.com/how-to-save-topics-and-messages-in-mysql-database-tp2539322p2539322.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. >
