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: [email protected]
For additional commands, e-mail: [email protected]
