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
