Maxim Solodovnik created OPENMEETINGS-1483:
----------------------------------------------
Summary: Error while installing OM on MSSQL
Key: OPENMEETINGS-1483
URL: https://issues.apache.org/jira/browse/OPENMEETINGS-1483
Project: Openmeetings
Issue Type: Bug
Components: BuildsAndReleases
Affects Versions: 3.1.3
Environment: DB: MS SQL 2014
encoding: Cyrillic_General_CI_AI
Reporter: Maxim Solodovnik
Assignee: Maxim Solodovnik
Fix For: 3.1.4, 3.2.0, 4.0.0
{code}
Caused by: <openjpa-2.4.1-r422266:1730418 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Incorrect syntax near the
keyword 'key'. {stmnt 1149624438 CREATE TABLE configuration (id BIGINT NOT NULL
IDENTITY, comment TEXT, deleted BIT, inserted DATETIME2, key VARCHAR(255),
updated DATETIME2, value VARCHAR(255), user_id BIGINT, PRIMARY KEY (id),
CONSTRAINT U_CNFGRTN_KEY UNIQUE (key))} [code=156, state=S0001]
at
org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:561)
at
org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:457)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:208)
at
org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:154)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:226)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:153)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:59)
at
org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:449)
at
org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:369)
... 12 more
{code}
link to the thread: http://markmail.org/message/kluuge4hd6pit7wv
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
