[jira] [Created] (AMQ-4120) SqlServer - SQL Syntax error in initial table creation

["Rasitha Wijesinghe (JIRA)" <ji...@apache.org>]

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