Yeah, I had put up a bug report on that issue. I had to fix that in the source
code. The problem is the MailboxAnnotation class uses the column name ‘KEY’
which is a reserved word in SQL, so most real SQL databases balk at it. I
thought that had been fixed before the 3.3 tag was finalized. All we need to do
is change the column name to ‘ANNOTATION_KEY’. That has to be done in source
code though, not in the sqlResources file. Welcome to JPA.
Sent from my iPhone
> On Mar 25, 2019, at 12:49 PM, Marans.Jeffrey <jeffrey.mar...@cic.gc.ca> wrote:
>
> When I start james 3.0.2 the log contains Connected to Microsoft SQL Server
> version 12.12 using JDBC driver Microsoft JDBC Driver 7.2 for SQL Server
> version 7.2.1.0, and 3 tables were created.
>
> But this warning turns fatal
> WARN 12:21:51,120 |
> org.apache.james.container.spring.context.JamesServerApplicationContext |
> Exception encountered during context initialization - cancelling refresh
> attempt: org.springframework.beans.factory.UnsatisfiedDependencyException:
> Error creating bean with name 'authenticator' defined in class path resource
> [META-INF/org/apache/james/spring-mailbox-authenticator.xml]: Unsatisfied
> dependency expressed through constructor argument with index 0 of type
> [org.apache.james.user.api.UsersRepository]: : Error creating bean with name
> 'usersrepository': Injection of autowired dependencies failed; nested
> exception is org.springframework.beans.factory.BeanCreationException: Could
> not autowire method: public void
> org.apache.james.user.lib.AbstractUsersRepository.setDomainList(org.apache.james.domainlist.api.DomainList);
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'domainlist': Initialization of bean failed;
> nested exception is org.springframework.beans.FatalBeanException: Unable to
> execute lifecycle method on beandomainlist; nested exception is
> <openjpa-3.0.0-r422266:1833209 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Incorrect syntax near
> the keyword 'KEY'. {stmnt 1664030951 CREATE TABLE JAMES_MAILBOX_ANNOTATION
> (KEY VARCHAR(200) NOT NULL, MAILBOX_ID BIGINT NOT NULL, VALUE VARCHAR(255),
> PRIMARY KEY (KEY, MAILBOX_ID))} [code=156, state=S0001]; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'usersrepository': Injection of autowired dependencies failed;
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Could not autowire method: public void
> org.apache.james.user.lib.AbstractUsersRepository.setDomainList(org.apache.james.domainlist.api.DomainList);
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'domainlist': Initialization of bean failed;
> nested exception is org.springframework.beans.FatalBeanException: Unable to
> execute lifecycle method on beandomainlist; nested exception is
> <openjpa-3.0.0-r422266:1833209 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Incorrect syntax near
> the keyword 'KEY'. {stmnt 1664030951 CREATE TABLE JAMES_MAILBOX_ANNOTATION
> (KEY VARCHAR(200) NOT NULL, MAILBOX_ID BIGINT NOT NULL, VALUE VARCHAR(255),
> PRIMARY KEY (KEY, MAILBOX_ID))} [code=156, state=S0001]
>
> I can't find anything on the web regarding how to modify sqlResources.xml to
> work with MS SQL Server.
>
>
> Jeffrey Marans
>
> Enterprise Architect Biometrics, Domestic Network
> Immigration, Refugees and Citizenship Canada / Government of Canada
> jeffrey.mar...@cic.gc.ca<mailto:jeffrey.mar...@cic.gc.ca> / Tel: 613-437-9890
>
> Architecte de biométrie (Consultant), Solutions et gestion de l'information
> Immigration, Réfugiés et Citoyenneté Canada / Gouvernement du Canada
> jeffrey.mar...@cic.gc.ca<mailto:jeffrey.mar...@cic.gc.ca> / Tél.: 613-437-9890
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org
