Re: Restarting ActiveMq removes/cleans all persisted messages/queues/topics

[pol_ice]

Hi there,

I have tried to use another datasource for mssql driver:

         <bean id="mssql-ds"
class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
                <property name="driverClass"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
                <property name="jdbcUrl"
value="jdbc:sqlserver://localhost:1433;databaseName=Test;user=activemq;password=activemq@@123"/>
                <property name="user" value="activemq"/>
                <property name="password" value="activemq@@123"/>
                <property name="acquireRetryAttempts" value="100"/>
                <property name="testConnectionOnCheckout" value="true"/>
                <property name="testConnectionOnCheckin" value="true"/>
                <property name="automaticTestTable" value="ACTIVEMQ_CONN_TEST"/>
                <property name="acquireRetryDelay" value="5000"/>
                <property name="preferredTestQuery" value="SELECT 1"/>
        </bean>

        <persistenceAdapter>
                  <jdbcPersistenceAdapter dataSource="#mssql-ds"
createTablesOnStartup="false"  />
        </persistenceAdapter>

But after restart of the activemq service, all queues are still gone.

I am using SQL Server 2008 R2 on Win 64-bit machine for persistence.
ActiveMq is running on Win 64-bit machine as well. Any suggestions from my
above logs?

--
View this message in context: 
http://activemq.2283324.n4.nabble.com/Restarting-ActiveMq-removes-cleans-all-persisted-messages-queues-topics-tp3728577p3733417.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.