james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Pryor (JIRA)" <server-...@james.apache.org>
Subject [jira] [Created] (JAMES-2410) Column name 'KEY' in JPAMailboxAnnotation not allowed by SQL Server
Date Tue, 05 Jun 2018 09:19:00 GMT
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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


Mime
View raw message