Re: Issue using MSSQL for persistence

2018-06-05 Thread Matt Pryor
Hi Simon, thanks for the reply. I'll try changing it in the xml file and see if that helps. Matt On 4 June 2018 at 16:59, Simon Levesque wrote: > Hi Matt, > > I am no James expert, but I think using the column escape character > (double-quotes) should fix it: > CREATE TABLE

Re: Issue using MSSQL for persistence

2018-06-04 Thread Simon Levesque
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