JDBC persistence for postgresql

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

<persistenceAdapter>
    <jdbcPersistenceAdapter dataDirectory="${activemq.base}/data"
dataSource="#postgres-ds>
        <adapter><postgresql-jdbc-adapter/></adapter>
    </jdbcPersistenceAdapter>
</persistenceAdapter>

<bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource"
destroy-method="close">
    <property name="serverName" value="192.168.15.2"/>
    <property name="databaseName" value="activemq"/>
    <property name="portNumber" value="5432"/>
    <property name="user" value="activemq"/>
    <property name="password" value="activemq"/>
    <property name="dataSourceName" value="postgres"/>
    <property name="initialConnections" value="1"/>
    <property name="maxConnections" value="10"/>
</bean>

When I start ActiveMQ, I check the tables(activemq_acks, activemq_lock,
activemq_msgs) has created in postgres.
But, no data persist to table after I publish message to subscriber.

Any hints would be appreciated.

Regards,

Bill



--
View this message in context: 
http://activemq.2283324.n4.nabble.com/JDBC-persistence-for-postgresql-tp4727004.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.