activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Claus Ibsen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMQ-4120) SqlServer - SQL Syntax error in initial table creation
Date Wed, 30 Oct 2013 14:35:46 GMT

    [ https://issues.apache.org/jira/browse/AMQ-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809153#comment-13809153
] 

Claus Ibsen commented on AMQ-4120:
----------------------------------

Dont we have a SQL server adaptor now? Can you check AMQ 5.9 release?

> 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
>             Fix For: NEEDS_REVIEWED
>
>
> 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.1#6144)

Mime
View raw message