ActiveMQ 5.10.0 and microsoft_jdbc_driver_4_1_for_sql_server

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

ActiveMQ 5.10.0 and microsoft_jdbc_driver_4_1_for_sql_server

erstanl
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.