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.
