activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pol_ice <pavel.grit...@gmail.com>
Subject Re: Restarting ActiveMq removes/cleans all persisted messages/queues/topics
Date Wed, 10 Aug 2011 16:08:09 GMT
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.

Mime
View raw message