[
https://issues.apache.org/jira/browse/AMQ-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13967250#comment-13967250
]
Gurinder commented on AMQ-4120:
-------------------------------
I see this also in 5.9.0
I am using jdbcPersistenceAdapter and my datasource is using the bean class:
org.apache.commons.dbcp.BasicDataSource
> SqlServer - SQL Syntax error in initial table creation
> ------------------------------------------------------
>
> Key: AMQ-4120
> URL: https://issues.apache.org/jira/browse/AMQ-4120
> Project: ActiveMQ
> Issue Type: Improvement
> Affects Versions: 5.7.0
> Environment: Windows Server 2008 R2, 64bit, MS SQL Server 2008
> persistence adapter.
> Reporter: Rasitha Wijesinghe
> Priority: Minor
> Fix For: NEEDS_REVIEW
>
>
> 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 was sent by Atlassian JIRA
(v6.2#6252)
