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
[email protected]<mailto:[email protected]> / 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
[email protected]<mailto:[email protected]> / Tél.: 613-437-9890
