JDBC with Failover MS SQL

[abrasha70]

Hi,

I set an ActiveMQ service based on database using JDBC to a Failover MS SQL
Server Database.

When the SQL server fails-over, the AMQ service goes down for some reason,
and doesn't go up back again.

How can I prevent it?
Do I need to configure anything?
I'm using version 1.11.1

***

Here's what I configured in the Jetty.xml:
<bean id="mssql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
        <property name="driverClassName"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
        <property name="url"
value="jdbc:sqlserver://localhost:1433;databaseName=AMQDB;user=MyUserName;password=MyPassword"/>
</bean>

Here's what I configured in the ActiveMQ.xml:
<persistenceAdapter>
        <jdbcPersistenceAdapter dataDirectory="${activemq.base}/data"
dataSource="#mssql-ds" createTablesOnStartup="true">
                <adapter>
                        <transact-jdbc-adapter />
                </adapter>
                <databaseLocker>
                        <transact-database-locker/>
                </databaseLocker>
        </jdbcPersistenceAdapter>
</persistenceAdapter>



--
View this message in context: 
http://activemq.2283324.n4.nabble.com/JDBC-with-Failover-MS-SQL-tp4702654.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.