Interestingly, AMQ-6904 defined the SQL Server adapter but didn't use it in https://git-wip-us.apache.org/repos/asf?p=activemq.git;a=tree;f=activemq-jdbc-store/src/main/resources/META-INF/services/org/apache/activemq/store/jdbc. Would you be willing to do some JAR surgery to edit the SQL Server files from that directory to reference SqlServerJDBCAdapter rather than TransactJDBCAdapter? I'd guess only the 6.1 file needs a change, but maybe try them one by one to determine the minimum set?
Also, what SQL Server version are you using? Tim On Mon, Mar 14, 2022, 6:42 AM Tim Bain <[email protected]> wrote: > Support for SQL Server (including the use of varbinary) was added in > 5.15.11 and 5.16.0 under AMQ-6904 ( > https://issues.apache.org/jira/browse/AMQ-6904), but the broker is using > DefaultJDBCAdapter instead. Can you show your config? > > Tim > > On Mon, Mar 14, 2022, 4:52 AM <[email protected]> wrote: > >> Hello Community, >> >> after updating my ActivMQ (+OS, Java, MSSQL lease lock DB) >> I get this message in the activemq.log: >> >> 022-03-14 11:32:13,646 | WARN | Could not create JDBC tables; they could >> already exist. Failure was: CREATE TABLE ACTIVEMQ_MSGS(ID BIGINT NOT NULL, >> CONTAINER VARCHAR(250) NOT NULL, 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: S0006 >> Vendor code: 2715 | >> org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter | main >> 2022-03-14 11:32:13,647 | WARN | Failure details: Column, parameter, or >> variable #6: Cannot find data type BLOB. | >> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main >> >> >> I find on the Microsoft page: "BLOB types can be used with varbinary(max)" >> But how can I fix the Statement in ActiveMQ 5-16-4? >> Or can it be overridden by config? >> >> Best Regards >> >> Herbert >> ------------------------------ >> >> >> *Herbert Helmstreit*Dipl.-Phys. >> Software Engineer >> >> [image: SYSTEMA Logo] <https://www.systema.com> >> >> Phone: +49 941 / 7 83 92 36 >> Fax: +49 351 / 88 24 772 >> >> [email protected] | www.systema.com >> >> [image: LinkedIn] <https://www.linkedin.com/company/systema-gmbh/>[image: >> Facebook] <https://de-de.facebook.com/SYSTEMA.automation/>[image: XING] >> <https://www.xing.com/pages/systemagmbh> >> >> SYSTEMA Systementwicklung Dipl.-Inf. Manfred Austen GmbH >> Schikanederstraße 2b - Posthof | 93053 Regensburg >> HRB 11256 Amtsgericht Dresden | USt.-ID DE 159 607 786 >> Geschäftsführer: Manfred Austen, CEO und Dr. Ulf Martin, COO >> >>
