Uploaded image for project: 'James Server'
  1. James Server
  2. JAMES-2410

Column name 'KEY' in JPAMailboxAnnotation not allowed by SQL Server

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0-beta4
    • Fix Version/s: None
    • Component/s: mailbox
    • Labels:
      None
    • Environment:
      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.

       

        Attachments

        1. james-server.log
          17 kB
          Matt Pryor

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mattpryor Matt Pryor
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: