[AMQ-2492] Microsoft SQL Server JDBC Driver 2.0 not recognized

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.3.0
• Fix Version/s: 5.5.0
• Component/s: Broker
• Patch Info: Patch Available
• Assignee: Gary Tully
• Reporter: Steffen Enni
• Created: 13/Nov/09 21:00
• Updated: 14/Dec/10 15:37
• Resolved: 14/Dec/10 15:36

Description

The sqljdbc4.jar driver from http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en is not recognized.

The log says:
INFO | Using Persistence Adapter: JDBCPersistenceAdapter(org.apache.commons.dbcp.BasicDataSource@47570945)
WARN | Database lock driver override not found for : [microsoft_sql_server_jdbc_driver_2_0]. Will use default implementation.

The fix is to add
activemq-core\src\main\resources\META-INF\services\org\apache\activemq\store\jdbc\microsoft_sql_server_jdbc_2_0_driver
activemq-core\src\main\resources\META-INF\services\org\apache\activemq\store\jdbc\lock\microsoft_sql_server_jdbc_2_0_driver

With the same content as the microsoft_sql_server_2005_driver in both directories.

I've attached a pach