activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rasitha Wijesinghe (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMQ-4120) SqlServer - SQL Syntax error in initial table creation
Date Fri, 19 Oct 2012 22:20:12 GMT
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

Mime
View raw message