Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Cannot Reproduce
-
3.0-beta4
-
None
-
None
-
Windows Server 2016, MS SQL Server 2016, Java 1.8.0_171-b11, JDBC driver 4.2.6420.100
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.