[jira] [Created] (OPENMEETINGS-1483) Error while installing OM on MSSQL

["Maxim Solodovnik (JIRA)" <ji...@apache.org>]

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)