ActiveMQ 5.12.0 and SQL Server Persistence

[mtod <mt...@thetods.net>]

I have ActiveMQ 5.12 using Persistence on SQL Server in my development
environment.
I need to setup a staging environment but I keep getting this error.

Note:

>ActiveMQ 5.12.0
>MS JDBC 4.1
>OS Windows 2012 R2

2015-09-23 15:56:49,354 | INFO  | Using Persistence Adapter:
JDBCPersistenceAdapter(org.apache.commons.dbcp2.BasicDataSource@715a0b19) |
org.apache.activemq.broker.BrokerService | main
2015-09-23 15:56:49,947 | INFO  | Database adapter driver override not found
for : [microsoft_jdbc_driver_4_2_for_sql_server].  Will use default
implementation. | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter |
main
2015-09-23 15:56:50,385 | 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: S0006
Vendor code: 2715 |
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter | main
2015-09-23 15:56:50,385 | WARN  | Failure details: Column, parameter, or
variable #6: Cannot find data type BLOB. |
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main
com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or
variable #6: Cannot find data type BLOB.
	at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)[sqljdbc41.jar:]
	at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)[sqljdbc41.jar:]
	at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)[sqljdbc41.jar:]
	at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)[sqljdbc41.jar:]
	at
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)[sqljdbc41.jar:]
	at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)[sqljdbc41.jar:]
	at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)[sqljdbc41.jar:]
	at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)[sqljdbc41.jar:]
	at
com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:735)[sqljdbc41.jar:]
	at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)[commons-dbcp2-2.1.jar:2.1]
	at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)[commons-dbcp2-2.1.jar:2.1]
	at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doCreateTables(DefaultJDBCAdapter.java:111)[activemq-jdbc-store-5.12.0.jar:5.12.0]
	at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.init(JDBCPersistenceAdapter.java:303)[activemq-jdbc-store-5.12.0.jar:5.12.0]
	at
org.apache.activemq.broker.LockableServiceSupport.preStart(LockableServiceSupport.java:89)[activemq-broker-5.12.0.jar:5.12.0]
	at
org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:54)[activemq-client-5.12.0.jar:5.12.0]
	at
org.apache.activemq.broker.BrokerService.doStartPersistenceAdapter(BrokerService.java:651)[activemq-broker-5.12.0.jar:5.12.0]
	at
org.apache.activemq.broker.BrokerService.startPersistenceAdapter(BrokerService.java:640)[activemq-broker-5.12.0.jar:5.12.0]
	at
org.apache.activemq.broker.BrokerService.start(BrokerService.java:604)[activemq-broker-5.12.0.jar:5.12.0]
	at
org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:88)[activemq-console-5.12.0.jar:5.12.0]
	at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:62)[activemq-console-5.12.0.jar:5.12.0]
	at
org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:154)[activemq-console-5.12.0.jar:5.12.0]
	at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:62)[activemq-console-5.12.0.jar:5.12.0]
	at
org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:104)[activemq-console-5.12.0.jar:5.12.0]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[:1.7.0_80]
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[:1.7.0_80]
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.7.0_80]
	at java.lang.reflect.Method.invoke(Method.java:606)[:1.7.0_80]
	at
org.apache.activemq.console.Main.runTaskClass(Main.java:262)[activemq.jar:5.12.0]
	at
org.apache.activemq.console.Main.main(Main.java:115)[activemq.jar:5.12.0]

Thanks

Mike



--
View this message in context: http://activemq.2283324.n4.nabble.com/ActiveMQ-5-12-0-and-SQL-Server-Persistence-tp4702242.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.

Re: ActiveMQ 5.12.0 and SQL Server Persistence

[mtod <mt...@thetods.net>]

Fixed added

<persistenceAdapter>			
	<jdbcPersistenceAdapter dataDirectory="${activemq.data}"
dataSource="#mssql-ds" createTablesOnStartup="true"
lockKeepAlivePeriod="5000">
		<adapter><transact-jdbc-adapter/></adapter>
		<locker>
			<lease-database-locker leaseHolderId="XXXXXXX"
lockAcquireSleepInterval="10000"/>
		</locker>
	</jdbcPersistenceAdapter>
</persistenceAdapter>



--
View this message in context: http://activemq.2283324.n4.nabble.com/ActiveMQ-5-12-0-and-SQL-Server-Persistence-tp4702242p4702249.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.