[
https://issues.apache.org/jira/browse/JAMES-2410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ioan Eugen Stan resolved JAMES-2410.
------------------------------------
Assignee: Ioan Eugen Stan
Resolution: Cannot Reproduce
I'm closing this as part of a issue cleaning.
Also it's for an old, beta release.
We also don't test on that environments (Windows, MS SQL).
If this is still relevant, please open the issue again.
We will gladly accept a patch or a github PR with the fix to your issue.
> 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
