yes, this is a good workaround, can you open a jira issue to track this change so that it can be integrated into the code base.
The variations in SLQ syntax for the DBs are driven by the driver name string, so reusing the settings for 2.0 makes sense. On 10 January 2011 09:36, werdex <hodchenko...@belhard.com> wrote: > > Hello! > > 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 ACTIVEMQ_MSGS(ID BIGINT NOT NULL, CONTAINER VARCHAR(250), > MSGID_PROD VARCHAR(250), MSGID_SEQ 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: > http://activemq.2283324.n4.nabble.com/activemq-and-sql-server-2008-td2367448.html > > 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. > > I'm interested if it is a good workaround and whether MS SQL 3.0 support is > planned in future releases of ActiveMQ? > > Thanks in advance. > > -- > View this message in context: > http://activemq.2283324.n4.nabble.com/MSSQL-3-0-support-tp3206822p3206822.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > -- http://blog.garytully.com http://fusesource.com
