Thanks guys. You're right, 3.3 does have the fix, and it creates the tables, but throws this exception: WrapperSimpleApp: Encountered an error running main: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pop3server': Invocation of init method failed; nested exception is java.lang.ArrayIndexOutOfBoundsException: 1 INFO | jvm 1 | 2019/03/25 15:01:27 | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pop3server': Invocation of init method failed; nested exception is java.lang.ArrayIndexOutOfBoundsException: 1
Jeff. -----Original Message----- From: cryptearth [mailto:cryptea...@cryptearth.de] Sent: Tuesday, March 26, 2019 2:13 AM To: server-user@james.apache.org Subject: Re: sqlResources.xml Hey Jeffrey, hey Garry, as I look through the source from 3.4 it seems this is already fixed, at least it was in master-branch as of Feb 28th 08:05 UTC (a quick check: 3.2.x doesn't contain the fix, but the 3.3.x does). Once I encountered a similar issue as I once didn't set database type correctly in james-database.properties file. So, possible fix: update to 3.3.x branch. greetings, Matt Am 25.03.2019 um 21:09 schrieb Garry Hurley: > 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.JamesServerApplicationConte >> xt | 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.a >> pache.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.a >> pache.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 > --------------------------------------------------------------------- To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org For additional commands, e-mail: server-user-h...@james.apache.org