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 "Matt Pryor (JIRA)" <se...@james.apache.org> on 2018/06/05 09:19:00 UTC
[jira] [Created] (JAMES-2410) Column name 'KEY' in
JPAMailboxAnnotation not allowed by SQL Server
Matt Pryor created JAMES-2410:
---------------------------------
Summary: 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
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
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org