[
https://issues.apache.org/jira/browse/AMQ-3914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13571163#comment-13571163
]
Petr Nídl edited comment on AMQ-3914 at 2/5/13 9:04 AM:
--------------------------------------------------------
I would recommend to reopen this issue and rename the file
'/META-INF/services/org/apache/activemq/store/jdbc/microsoft_sql_server_jdbc_driver_4_0'
to
'/META-INF/services/org/apache/activemq/store/jdbc/microsoft_jdbc_driver_4_0_for_sql_server'.
The problem is that Microsoft changed the format of its driver's product name
(com.microsoft.sqlserver.jdbc.SQLServerDriver.PRODUCT_NAME) from 'Microsoft SQL
Server JDBC Driver 3.0' to 'Microsoft JDBC Driver 4.0 for SQL Server'.
Similar problem is that there is no file with database locker definition for MS
SQL Server. Again, it should be sufficient to copy the 3.0 file and rename it.
was (Author: pnidl):
I would recommend to reopen this issue and rename the file
'/META-INF/services/org/apache/activemq/store/jdbc/microsoft_sql_server_jdbc_driver_4_0'
to
'/META-INF/services/org/apache/activemq/store/jdbc/microsoft_jdbc_driver_4_0_for_sql_server'.
The problem is that Microsoft changed the format of its driver's product name
(com.microsoft.sqlserver.jdbc.SQLServerDriver.PRODUCT_NAME) from 'Microsoft SQL
Server JDBC Driver 3.0' to 'Microsoft JDBC Driver 4.0 for SQL Server'.
> Add support for MS SQL JDBC driver 4.0
> --------------------------------------
>
> Key: AMQ-3914
> URL: https://issues.apache.org/jira/browse/AMQ-3914
> Project: ActiveMQ
> Issue Type: Improvement
> Components: Message Store
> Affects Versions: 5.5.1
> Reporter: Henrik Karlsson
> Assignee: Claus Ibsen
> Priority: Minor
> Fix For: 5.7.0
>
>
> When using MS SQL JDBC Driver version 4.0 ActiveMQ can't find a "Database
> adapter driver override" as it does with version 3.0 of the driver.
> Version 4.0
> {noformat}
> 2012-07-06 09:50:33,639 | INFO | Database adapter driver override not found
> for : [microsoft_jdbc_driver_4_0_for_sql_server]. Will use default
> implementation. | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter |
> WrapperSimpleAppMain
> 2012-07-06 09:50:33,639 | INFO | Database lock driver override not found for
> : [microsoft_jdbc_driver_4_0_for_sql_server]. Will use default
> implementation. | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter |
> WrapperSimpleAppMain
> {noformat}
> Version 3.0
> {noformat}
> 2012-07-06 10:09:37,322 | INFO | Database adapter driver override recognized
> for : [microsoft_sql_server_jdbc_driver_3_0] - adapter: class
> org.apache.activemq.store.jdbc.adapter.TransactJDBCAdapter |
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | WrapperSimpleAppMain
> 2012-07-06 10:09:37,322 | INFO | Database lock driver override recognized
> for : [microsoft_sql_server_jdbc_driver_3_0] - adapter: class
> org.apache.activemq.store.jdbc.adapter.TransactDatabaseLocker |
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | WrapperSimpleAppMain
> {noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira