[ https://issues.apache.org/jira/browse/JAMES-2410?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17139022#comment-17139022 ]
Benoit Tellier commented on JAMES-2410: --------------------------------------- The fix (changing the column name) is relatively easy. However the data migration part is more tricky. > 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 > Assignee: Ioan Eugen Stan > Priority: Major > 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 (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org For additional commands, e-mail: server-dev-h...@james.apache.org