0 Replies Latest reply on Jan 25, 2016 11:01 AM by Anne Magee

    AMQ not writing to db tables

    Anne Magee Newbie

      Hi, I'm trying to write messages to a postgresql database and have updated the activemq.xml as below and ran the osgi create commands for jdbc and postgresql. The 3 tables get created ok but when I send persistent messages to a broker they are not being written to the db table. No errors in the log either. Any ideas - is there any way in Fuse to confirm the persistence adapter in use?

      Many thanks

       

              <persistenceAdapter>

                  <jdbcPersistenceAdapter  dataSource="#postgres-ds"/>

              </persistenceAdapter>

       

      <bean id="postgres-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

              <property name="driverClassName" value="org.postgresql.Driver"/>

              <property name="url" value="jdbc:postgresql://localhost:9999/activemq"/>

              <property name="username" value="activemq"/>

              <property name="password" value="activemq"/> <property name="poolPreparedStatements" value="true"/>

      <property name="testWhileIdle" value="true" /></bean>