You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by "Benoit Tellier (Jira)" <se...@james.apache.org> on 2020/06/18 04:05:00 UTC
[jira] [Commented] (JAMES-2410) Column name 'KEY' in
JPAMailboxAnnotation not allowed by SQL Server
[ 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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org