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 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 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 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

JDBC persistence for postgresql

2017-06-05 Thread Bill Chen
Hi All, I am using ActiveMQ 5.14.5 as MQTT broker, and I would like to use postgres as database. My configuration in activemq.xml: When I start ActiveMQ, I check the tables(activemq_acks, activemq_lock, activemq_msgs) has created in postgres. But,