Да, вроде, SQL_Latin1_General_CP1_CI_AS поддерживает -----Original Message----- From: Maxim Solodovnik [mailto:solomax...@gmail.com] Sent: Wednesday, October 5, 2016 1:39 PM To: user-russian@openmeetings.apache.org Subject: RE: Вопрос с кодировкой
Чтобы не было вопросов вместо русских букв надо установить кодировку базы в какую-нибудь совместимую с utf-8 WBR, Maxim (from mobile, sorry for the typos) On Oct 5, 2016 16:49, "Осадчий Артём Вячеславович" <osadchy...@bytechs.by> wrote: > Да, всё установилось!! Спасибо. Прошу простить, что не сразу отвечаю. > Только что установил. Проблемы с дефолтными комнатами (вопросиками), > но, после пересоздания - всё нормально. > > -----Original Message----- > From: Maxim Solodovnik [mailto:solomax...@gmail.com] > Sent: Wednesday, October 5, 2016 12:48 PM > To: user-russian@openmeetings.apache.org > Subject: Re: Вопрос с кодировкой > > получилось проверить? > > On Tue, Oct 4, 2016 at 9:09 PM, Maxim Solodovnik > <solomax...@gmail.com> > wrote: > > минут через 15 построится и можно пробовать :) > > > > On Tue, Oct 4, 2016 at 9:08 PM, Осадчий Артём Вячеславович > > <osadchy...@bytechs.by> wrote: > >> > >> Спасибо! Сейчас попробую > >> > >> -----Original Message----- > >> From: Maxim Solodovnik [mailto:solomax...@gmail.com] > >> Sent: Tuesday, October 4, 2016 5:06 PM > >> To: user-russian@openmeetings.apache.org > >> Subject: Re: Вопрос с кодировкой > >> > >> https://issues.apache.org/jira/browse/OPENMEETINGS-1483 > >> > >> On Tue, Oct 4, 2016 at 8:56 PM, Maxim Solodovnik > >> <solomax...@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...@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&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 > > > > > > > > > > -- > > WBR > > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax >
