ActiveMQ 5.10.0 and microsoft_jdbc_driver_4_1_for_sql_server

[erstanl <er...@gmail.com>]

So I recently updated to jre7 and have noticed a strange problem between jre7
and the microsoft_jdbc_driver_4_0_for_sql_server driver. Looks like a known
issue, resulting in the recommendation to update to
microsoft_jdbc_driver_4_1_for_sql_server. However, it would appear that 5.10
does not support this newer driver:

2014-12-18 14:59:03,347 | INFO  | Database adapter driver override not found
for : [microsoft_jdbc_driver_4_1_for_sql_server].  Will use default
implementation. | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter |
WrapperSimpleAppMain
2014-12-18 14:59:03,631 | INFO  | Database lock driver override not found
for : [microsoft_jdbc_driver_4_1_for_sql_server].  Will use default
implementation. | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter |
WrapperSimpleAppMain

It then sleeps for a period, and tries again to no avail.

I have seen posts from others stating that if I change from:

		<persistenceAdapter>
			<jdbcPersistenceAdapter dataSource="#mssql-ds"
createTablesOnStartup="true"/>
		</persistenceAdapter>
 
to:

		<persistenceAdapter>
			<jdbcPersistenceAdapter dataSource="#mssql-ds"
createTablesOnStartup="true">
				<adapter>
					<transact-jdbc-adapter />
				</adapter>
				<databaseLocker>
					<transact-database-locker/>
				</databaseLocker>
			</jdbcPersistenceAdapter>
		</persistenceAdapter>

It works. And it does in my case as well. I would like to better understand:

A) Why am I not able to use the microsoft_jdbc_driver_4_1_for_sql_server
driver without changing the config?
B) What is the second XML snippet actually telling ActiveMQ to do?

Thanks in advance.



--
View this message in context: http://activemq.2283324.n4.nabble.com/ActiveMQ-5-10-0-and-microsoft-jdbc-driver-4-1-for-sql-server-tp4689221.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.