Hi Matt,
I am no James expert, but I think using the column escape character
(double-quotes) should fix it:
CREATE TABLE JAMES_MAILBOX_ANNOTATION
("KEY" VARCHAR(200) NOT NULL, "MAILBOX_ID" BIGINT NOT NULL, "VALUE"
VARCHAR(255),
PRIMARY KEY ("KEY", "MAILBOX_ID"))
That is the standard SQL per
Hi there
We are using James 3.0.1, SQL Server 2016 with JDBC driver version 4.2.6420
When James starts it gets as far as creating three tables and then falls
over creating JAMES_MAILBOX_ANNOTATION, it looks like it is using a column
named "key" which is a reserved keyword in SQL Server: