Re: JDBC persistence for postgresql

2017-06-19 Thread Bill Chen
Hi Tim, I found Message.setBooleanProperty() in javax.jms.Message, but I actually used the Eclipse Paho MQTT client to publish message. I have set the retained property in org.eclipse.paho.client.mqttv3.MqttMessage, does it like to the ActiveMQ.Retain property as you mentioned? Bill -- View

Re: JDBC persistence for postgresql

2017-06-07 Thread Tim Bain
On Jun 7, 2017 4:14 AM, "Bill Chen" wrote: Tim, I'm sorry that confused you about the reference link. I'm doing the ActiveMQ way, and I have encountered some questions. First, how to set the ActiveMQ.Retain property? You call Message.setBooleanProperty(). Second, I try to add the RetainedMes

Re: JDBC persistence for postgresql

2017-06-07 Thread Bill Chen
Tim, I'm sorry that confused you about the reference link. I'm doing the ActiveMQ way, and I have encountered some questions. First, how to set the ActiveMQ.Retain property? Second, I try to add the RetainedMessageSubscriptionRecoveryPolicy in my configuration, but that occurred exception when a

Re: JDBC persistence for postgresql

2017-06-06 Thread Tim Bain
Bill, You've forwarded a link to documentation for an unrelated product, so I want to make sure you're doing this the ActiveMQ way and not the IBM MessageSight way. Are you saying that you configured the RetainedMessageSubscriptionRecoveryPolicy subscription recovery policy as described in http://

Re: JDBC persistence for postgresql

2017-06-06 Thread Bill Chen
Hi, Tim I'm not sure the retained flag is the same as the persistent flag. About the retained flag as follows: https://www.ibm.com/support/knowledgecenter/en/SSCGGQ_1.0.0/com.ibm.ism.doc/Overview/ov00033.html I publish to a message to a topic, not to a queue. So, I don't have any information in t

Re: JDBC persistence for postgresql

2017-06-06 Thread Tim Bain
What's the retained flag? So to be sure I'm understanding correctly: you publish a message to the queue (or are you publishing to a topic?), you do not consume it, and you can see the message in that queue on the web console, but it's not in the database table. Is that all correct? When you click

Re: JDBC persistence for postgresql

2017-06-06 Thread Bill Chen
Thanks Tim. I have set the retained flag for message when producer publish. But the message still not stored in the activemq_msgs table. May I need to modify my configuration in activemq.xml? -- View this message in context: http://activemq.2283324.n4.nabble.com/JDBC-persistence-for-postgresq

Re: JDBC persistence for postgresql

2017-06-05 Thread Tim Bain
Each message your producer publishes has to have the persistent flag set, otherwise the (non-persistent) message will be stored in the memory store. Are you setting that flag when you publish your messages? On Jun 5, 2017 1:11 AM, "Bill Chen" wrote: > Hi All, > > I am using ActiveMQ 5.14.5 as MQ