You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@activemq.apache.org by "Josef Brož (JIRA)" <ji...@apache.org> on 2017/04/10 13:39:41 UTC

[jira] [Created] (AMQ-6650) Failed to auto-create database at MS SQL Server

Josef Brož created AMQ-6650:
-------------------------------

             Summary: Failed to auto-create database at MS SQL Server
                 Key: AMQ-6650
                 URL: https://issues.apache.org/jira/browse/AMQ-6650
             Project: ActiveMQ
          Issue Type: Bug
    Affects Versions: 5.13.4
            Reporter: Josef Brož


2017-04-10 15:16:03.418  INFO 8544 --- [Starting Thread] o.a.a.store.jdbc.JDBCPersistenceAdapter  : Database adapter driver override recognized for : [microsoft_jdbc_driver_6_1_for_sql_server] - adapter: class org.apache.activemq.store.jdbc.adapter.TransactJDBCAdapter
2017-04-10 15:16:03.520  WARN 8544 --- [Starting Thread] o.a.a.s.jdbc.adapter.DefaultJDBCAdapter  : Could not create JDBC tables; they could already exist. Failure was: ALTER TABLE ACTIVEMQ_ACKS DROP PRIMARY KEY Message: Incorrect syntax near the keyword 'PRIMARY'. SQLState: S0001 Vendor code: 156
2017-04-10 15:16:03.522  WARN 8544 --- [Starting Thread] o.a.a.store.jdbc.JDBCPersistenceAdapter  : Failure details: Incorrect syntax near the keyword 'PRIMARY'.

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'PRIMARY'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:232)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1672)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:903)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:796)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:208)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:183)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:769)
	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
	at org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doCreateTables(DefaultJDBCAdapter.java:111)
	at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.init(JDBCPersistenceAdapter.java:303)
	at org.apache.activemq.broker.LockableServiceSupport.preStart(LockableServiceSupport.java:89)
	at org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:54)
	at org.apache.activemq.broker.BrokerService.doStartPersistenceAdapter(BrokerService.java:672)
	at org.apache.activemq.broker.BrokerService.access$000(BrokerService.java:139)
	at org.apache.activemq.broker.BrokerService$2.run(BrokerService.java:644)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)