openmeetings-user-russian mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maxim Solodovnik <solomax...@gmail.com>
Subject Re: Вопрос с кодировкой
Date Tue, 04 Oct 2016 14:06:26 GMT
https://issues.apache.org/jira/browse/OPENMEETINGS-1483

On Tue, Oct 4, 2016 at 8:56 PM, Maxim Solodovnik <solomax666@gmail.com>
wrote:

> день добрый,
> такое чувство что MSSQL не любитимя колонки "key"
> я сейчас поправлю
> сможете поправить билд 388+ отсюда: https://builds.apache.
> org/view/M-R/view/OpenMeetings/job/Openmeetings%203.1.x/ ?
>
> On Tue, Oct 4, 2016 at 8:11 PM, Осадчий Артём Вячеславович <
> Osadchy_AV@bytechs.by> wrote:
>
>> Добрый День!
>>
>> Возникла следующая ситуация. После установки
OpenMeetings, на этапе
>> настройки, я пытаюсь подключить его к MS SQL бд.
При проверке всё
>> нормально, однако, когда нажимаю <Завершить>,
выскакивает ошибка,
>> приведённая ниже.
>> MS SQL 2014
>> Кодировка БД: Cyrillic_General_CI_AI
>> Джарку закинул
>>
>>
>> Ошибка
>>
>> org.springframework.transaction.CannotCreateTransactionException: Could
>> not open JPA EntityManager for transaction; nested exception is
>> <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.springframework.orm.jpa.Jp
>> aTransactionManager.doBegin(JpaTransactionManager.java:431)
>>                 at org.springframework.transactio
>> n.support.AbstractPlatformTransactionManager.getTransaction(
>> AbstractPlatformTransactionManager.java:373)
>>                 at org.springframework.transactio
>> n.interceptor.TransactionAspectSupport.createTransactionIfNe
>> cessary(TransactionAspectSupport.java:426)
>>                 at org.springframework.transactio
>> n.interceptor.TransactionAspectSupport.invokeWithinTransacti
>> on(TransactionAspectSupport.java:275)
>>                 at org.springframework.transactio
>> n.interceptor.TransactionInterceptor.invoke(TransactionInter
>> ceptor.java:96)
>>                 at org.springframework.aop.framew
>> ork.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvoc
>> ation.java:179)
>>                 at org.springframework.aop.framew
>> ork.CglibAopProxy$DynamicAdvisedInterceptor.intercept(
>> CglibAopProxy.java:655)
>>                 at org.apache.openmeetings.db.dao
>> .basic.NavigationDao$$EnhancerBySpringCGLIB$$4d110381.
>> addGlobalStructure(<generated>)
>>                 at org.apache.openmeetings.instal
>> lation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
>>                 at org.apache.openmeetings.instal
>> lation.ImportInitvalues.loadSystem(ImportInitvalues.java:517)
>>                 at org.apache.openmeetings.instal
>> lation.ImportInitvalues.loadAll(ImportInitvalues.java:533)
>>                 at org.apache.openmeetings.web.pa
>> ges.install.InstallWizard$InstallProcess.run(InstallWizard.java:642)
>>                 at java.lang.Thread.run(Thread.java:745)
>> 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.M
>> appingTool.record(MappingTool.java:561)
>>                 at org.apache.openjpa.jdbc.meta.M
>> appingTool.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.Abst
>> ractBrokerFactory.newBroker(AbstractBrokerFactory.java:208)
>>                 at org.apache.openjpa.kernel.Dele
>> gatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:154)
>>                 at org.apache.openjpa.persistence
>> .EntityManagerFactoryImpl.createEntityManager(EntityManagerF
>> actoryImpl.java:226)
>>                 at org.apache.openjpa.persistence
>> .EntityManagerFactoryImpl.createEntityManager(EntityManagerF
>> actoryImpl.java:153)
>>                 at org.apache.openjpa.persistence
>> .EntityManagerFactoryImpl.createEntityManager(EntityManagerF
>> actoryImpl.java:59)
>>                 at org.springframework.orm.jpa.Jp
>> aTransactionManager.createEntityManagerForTransaction(
>> JpaTransactionManager.java:449)
>>                 at org.springframework.orm.jpa.Jp
>> aTransactionManager.doBegin(JpaTransactionManager.java:369)
>>                 ... 12 more
>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: 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.lib.jdbc.Lo
>> ggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218)
>>                 at org.apache.openjpa.lib.jdbc.Lo
>> ggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:202)
>>                 at org.apache.openjpa.lib.jdbc.Lo
>> ggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58)
>>                 at org.apache.openjpa.lib.jdbc.Lo
>> ggingConnectionDecorator$LoggingConnection$LoggingStatement.
>> executeUpdate(LoggingConnectionDecorator.java:913)
>>                 at org.apache.openjpa.lib.jdbc.De
>> legatingStatement.executeUpdate(DelegatingStatement.java:118)
>>                 at org.apache.openjpa.jdbc.schema
>> .SchemaTool.executeSQL(SchemaTool.java:1272)
>>                 at org.apache.openjpa.jdbc.schema
>> .SchemaTool.createTable(SchemaTool.java:1017)
>>                 at org.apache.openjpa.jdbc.schema
>> .SchemaTool.buildSchema(SchemaTool.java:573)
>>                 at org.apache.openjpa.jdbc.schema
>> .SchemaTool.add(SchemaTool.java:481)
>>                 at org.apache.openjpa.jdbc.schema
>> .SchemaTool.add(SchemaTool.java:368)
>>                 at org.apache.openjpa.jdbc.schema
>> .SchemaTool.run(SchemaTool.java:343)
>>                 at org.apache.openjpa.jdbc.meta.M
>> appingTool.record(MappingTool.java:507)
>>                 ... 23 more
>>
>>
>> Persistence
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <!--
>>   Licensed to the Apache Software Foundation (ASF) under one
>>   or more contributor license agreements.  See the NOTICE file
>>  distributed with this work for additional information
>>   regarding copyright ownership.  The ASF licenses this file
>>   to you under the Apache License, Version 2.0 (the
>>   "License"); you may not use this file except in compliance
>>   with the License.  You may obtain a copy of the License at
>>
>>       http://www.apache.org/licenses/LICENSE-2.0
>>
>>   Unless required by applicable law or agreed to in writing,
>>   software distributed under the License is distributed on an
>>   "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
>>   KIND, either express or implied.  See the License for the
>>   specific language governing permissions and limitations
>>   under the License.
>>
>> -->
>> <!-- persistence.xml schema -->
>> <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="
>> http://www.w3.org/2001/XMLSchema-instance"
>>         xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
>> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
>> version="2.0">
>>         <persistence-unit name="openmeetings"
>> transaction-type="RESOURCE_LOCAL">
>>                 <provider>org.apache.openjpa.p
>> ersistence.PersistenceProviderImpl</provider>
>>                 <class>org.apache.openmeetings
>> .db.entity.basic.Configuration</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.basic.ErrorValue</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.server.LdapConfig</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.basic.MailMessage</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.basic.Naviglobal</class>
>>                 <class>org.apache.openmeetings.db.entity.basic.Navimain</
>> class>
>>                 <class>org.apache.openmeetings
>> .db.entity.server.Sessiondata</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.server.SOAPLogin</class>
>>                 <class>org.apache.openmeetings.db.entity.server.Server</
>> class>
>>                 <class>org.apache.openmeetings.db.entity.calendar.
>> Appointment</class>
>>                 <class>org.apache.openmeetings.db.entity.calendar.
>> MeetingMember</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.basic.ChatMessage</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.user.Group</class>
>>                 <class>org.apache.openmeetings.db.entity.user.GroupUser</
>> class>
>>                 <class>org.apache.openmeetings
>> .db.entity.record.Recording</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.record.RecordingLog</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.record.RecordingMetaData</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.record.RecordingMetaDelta</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.room.Invitation</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.log.ConferenceLog</class>
>>                 <class>org.apache.openmeetings.db.entity.room.RoomPoll</
>> class>
>>                 <class>org.apache.openmeetings
>> .db.entity.room.RoomPollAnswer</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.room.Client</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.room.RoomModerator</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.room.Room</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.room.Whiteboard</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.room.WhiteboardItem</class>
>>                 <class>org.apache.openmeetings.db.entity.room.RoomGroup</
>> class>
>>                 <class>org.apache.openmeetings.db.entity.user.Address</
>> class>
>>                 <class>org.apache.openmeetings
>> .db.entity.user.PrivateMessage</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.user.PrivateMessageFolder</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.user.UserContact</class>
>>                 <class>org.apache.openmeetings.db.entity.user.Userdata</
>> class>
>>                 <class>org.apache.openmeetings
>> .db.entity.user.User</class>
>>                 <class>org.apache.openmeetings.db.entity.file.FileItem</
>> class>
>>                 <class>org.apache.openmeetings
>> .db.entity.file.FileExplorerItem</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.user.AsteriskSipUser</class>
>>                 <class>org.apache.openmeetings
>> .db.entity.server.OAuthServer</class>
>>                 <exclude-unlisted-classes>fals
>> e</exclude-unlisted-classes>
>>                 <properties>
>>                         <property name="openjpa.RuntimeUnenhancedClasses"
>> value="unsupported" />
>>                         <property name="openjpa.ConnectionDriverName"
>> value="org.apache.commons.dbcp2.BasicDataSource" />
>>                         <property name="openjpa.ConnectionProperties"
>>                                 value="DriverClassName=com.mic
>> rosoft.sqlserver.jdbc.SQLServerDriver
>>                                         , Url=jdbc:sqlserver://1.1.1.1:1
>> 433;databaseName=OpenMeetings;autoReconnect=true;useUnicode=
>> true;createDatabaseIfNotExist=true&amp;characterEncoding=utf-8
>>                                         , Username=user
>>                                         , Password=111" />
>>                         <property name="openjpa.jdbc.SynchronizeMappings"
>> value="buildSchema" />
>>                         <property name="openjpa.Log"
>> value="DefaultLevel=WARN, Runtime=INFO" />
>>                         <property name="openjpa.DataCache" value="true" />
>>                         <property name="openjpa.QueryCache" value="true"
>> />
>>                         <property name="openjpa.jdbc.DBDictionary"
>> value="batchLimit=100" />
>>                         <property name="openjpa.jdbc.QuerySQLCache"
>> value="false" />
>>                 </properties>
>>         </persistence-unit>
>> </persistence>
>>
>>
>>
>>
>>
>>
>
>
> --
> WBR
> Maxim aka solomax
>



-- 
WBR
Maxim aka solomax

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message