Rasitha Wijesinghe created AMQ-4120:
---------------------------------------
Summary: SqlServer - SQL Syntax error in initial table creation
Key: AMQ-4120
URL: https://issues.apache.org/jira/browse/AMQ-4120
Project: ActiveMQ
Issue Type: Bug
Affects Versions: 5.7.0
Environment: Windows Server 2008 R2, 64bit, MS SQL Server 2008
persistence adapter.
Reporter: Rasitha Wijesinghe
Priority: Minor
When using SQL Server as the backing data store and creating the AMQ tables for
the very first time, the following error is logged:
INFO | jvm 1 | 2012/10/19 11:12:03 | WARN | 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: S1000
Vendor code: 156
INFO | jvm 1 | 2012/10/19 11:12:03 | WARN | Failure details: Incorrect
syntax near the keyword 'PRIMARY'.
INFO | jvm 1 | 2012/10/19 11:12:03 | java.sql.SQLException: Incorrect
syntax near the keyword 'PRIMARY'.
Since there is no specific adapter for SQL Server it uses the
DefaultJDBCAdapter which has getDropAckPKAlterStatementEnd() returning "DROP
PRIMARY KEY".
Not sure if this is an issue with other databases as well.
(Note: If you already have the tables, this error is still present but only
logs a DEBUG entry).
Does it make sense to add a MSSqlJDBCAdapter that overrides
getDropAckPKAlterStatementEnd?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
