activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pol_ice <>
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"
		<property name="jdbcUrl"
		<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"/>

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

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:
Sent from the ActiveMQ - User mailing list archive at

View raw message