activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitry B. (JIRA)" <>
Subject [jira] Created: (AMQ-3134) Add support of MS SQL JDBC driver (version 3.0)
Date Thu, 13 Jan 2011 13:30:45 GMT
Add support of MS SQL JDBC driver (version 3.0)

                 Key: AMQ-3134
             Project: ActiveMQ
          Issue Type: Improvement
          Components: Message Store
         Environment: CentOS Linux 2.6.18-128.el5 x86_64
            Reporter: Dmitry B.

I'm trying to use MS SQL database as ActiveMQ datastore, so I've put MS SQL driver 3.0 (sqljdbc4.jar)
in $ACTIVE_MQ/lib folder and configured MS SQL datasource. But when I start ActiveMQ I get
the following error message:

INFO | Database adapter driver override not found for : [microsoft_sql_server_jdbc_driver_3_0].
 Will use default implementation.
 WARN | Could not create JDBC tables; they could already exist. Failure was: CREATE TABLE
BIGINT, EXPIRATION BIGINT, MSG BLOB, PRIMARY KEY ( ID ) ) Message: Column, parameter, or variable
#6: Cannot find data type BLOB. SQLState: S0007 Vendor code: 2715

I found the similar problem description here:

But it relates to 2.0 version of MS SQL driver. I can't use version 2.0, because it complains
that it does not work with java 1.6. So, I opened META-INF/services/org/apache/activemq/store/jdbc
folder in $ACTIVEMQ_HOME/lib/activemq-core-5.4.2.jar and copied microsoft_sql_server_jdbc_2_0_driver
as microsoft_sql_server_jdbc_driver_3_0. After that ActiveMQ started successfully. 

So, the workaround is to add a "microsoft_sql_server_jdbc_driver_3_0" file to "activemq-core"
Can you please, add this file to a code base (if this is a right solution) or provide any
other changes to support JDBC driver for MS SQL (version 3.0).

Thank you!

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message