[OPENMEETINGS-1483] Error while installing OM on MSSQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.3
• Fix Version/s: 3.1.4, 3.2.0, 4.0.0
• Component/s: Builds
• Environment: DB: MS SQL 2014; encoding: Cyrillic_General_CI_AI
• Assignee: Maxim Solodovnik
• Reporter: Maxim Solodovnik
• Created: 04/Oct/16 14:05
• Updated: 28/Nov/16 10:26
• Resolved: 05/Oct/16 10:19

Description

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

link to the thread: http://markmail.org/message/kluuge4hd6pit7wv