[
https://issues.apache.org/jira/browse/JAMES-2410?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17139022#comment-17139022
]
Benoit Tellier commented on JAMES-2410:
---------------------------------------
The fix (changing the column name) is relatively easy.
However the data migration part is more tricky.
> Column name 'KEY' in JPAMailboxAnnotation not allowed by SQL Server
> -------------------------------------------------------------------
>
> Key: JAMES-2410
> URL: https://issues.apache.org/jira/browse/JAMES-2410
> Project: James Server
> Issue Type: Bug
> Components: mailbox
> Affects Versions: 3.0-beta4
> Environment: Windows Server 2016, MS SQL Server 2016, Java
> 1.8.0_171-b11, JDBC driver 4.2.6420.100
> Reporter: Matt Pryor
> Assignee: Ioan Eugen Stan
> Priority: Major
> Attachments: james-server.log
>
>
> James 3-0-beta4 fails to start using MS SQL Server 2016 for persistence due
> to the following create table statement:
> {{CREATE TABLE JAMES_MAILBOX_ANNOTATION (KEY VARCHAR(200) NOT NULL,
> MAILBOX_ID BIGINT NOT NULL, VALUE VARCHAR(255), PRIMARY KEY (KEY,
> MAILBOX_ID))}}
> "KEY" is a reserved keyword in SQL Server.
> Logs attached.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
