[JAMES-2410] Column name 'KEY' in JPAMailboxAnnotation not allowed by SQL Server

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 3.0-beta4
• Component/s: mailbox
• Environment: Windows Server 2016, MS SQL Server 2016, Java 1.8.0_171-b11, JDBC driver 4.2.6420.100
• Assignee: Ioan Eugen Stan
• Reporter: Matt Pryor
• Created: 05/Jun/18 09:18
• Updated: 18/Jun/20 04:04
• Resolved: 17/Jun/20 13:51

Description

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.