[
https://issues.apache.org/jira/browse/OPENMEETINGS-126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13245101#comment-13245101
]
SebastianWagner commented on OPENMEETINGS-126:
----------------------------------------------
This is already done:
https://svn.apache.org/repos/asf/incubator/openmeetings/branches/video-components/src/META-INF/mysql_persistence.xml
However this does not influence how MySQL will create the database with, it
only influences the type of connection the connection itself. There is no
parameter for setting the default character set while creating the database
with the parameter "createDatabaseIfNotExist"
http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html
> Error during the installation when MySQL is used for persistence
> ----------------------------------------------------------------
>
> Key: OPENMEETINGS-126
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-126
> Project: Openmeetings
> Issue Type: Bug
> Reporter: Michaël Mathieu
> Priority: Blocker
>
> If I install with Derby, I have no error.
> I followed this tuto:
> http://code.google.com/p/openmeetings/wiki/Configuration_Mysql
> I got this exception:
> DEBUG 04-02 17:10:59.451 ImportInitvalues.java 257924 709
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> Languages ADDED
> DEBUG 04-02 17:10:59.451 ImportInitvalues.java 257924 777
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> loadInitLanguages lang: {id=1, name=english, rtl=false, code=en}
> loadInitLanguages rtl from xml: false
> DEBUG 04-02 17:11:07.427 ImportInitvalues.java 265900 824
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> Lang ADDED: {id=1, name=english, rtl=false, code=en}
> DEBUG 04-02 17:11:07.428 ImportInitvalues.java 265901 777
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> loadInitLanguages lang: {id=2, name=deutsch, rtl=false, code=de}
> loadInitLanguages rtl from xml: false
> DEBUG 04-02 17:11:10.472 ImportInitvalues.java 268945 824
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> Lang ADDED: {id=2, name=deutsch, rtl=false, code=de}
> DEBUG 04-02 17:11:10.472 ImportInitvalues.java 268945 777
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> loadInitLanguages lang: {id=3, name=deutsch (studIP), rtl=false, code=de}
> loadInitLanguages rtl from xml: false
> DEBUG 04-02 17:11:12.927 ImportInitvalues.java 271400 824
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> Lang ADDED: {id=3, name=deutsch (studIP), rtl=false, code=de}
> DEBUG 04-02 17:11:12.928 ImportInitvalues.java 271401 777
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> loadInitLanguages lang: {id=4, name=french, rtl=false, code=fr}
> loadInitLanguages rtl from xml: false
> DEBUG 04-02 17:11:16.326 ImportInitvalues.java 274799 824
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> Lang ADDED: {id=4, name=french, rtl=false, code=fr}
> DEBUG 04-02 17:11:16.327 ImportInitvalues.java 274800 777
> org.openmeetings.app.installation.ImportInitvalues [http-0.0.0.0-5080-1] -
> loadInitLanguages lang: {id=5, name=italian, rtl=false, code=it}
> loadInitLanguages rtl from xml: false
> ERROR 04-02 17:11:18.438 Fieldmanagment.java 276911 326
> org.openmeetings.app.data.basic.Fieldmanagment [http-0.0.0.0-5080-1] -
> [getConfKey]:
> org.apache.openjpa.persistence.PersistenceException: The transaction has been
> rolled back. See the nested exceptions for details on the errors that
> occurred.
> at
> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2316)
> ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2153)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2051)
> ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1822)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:609)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.StateManagerImpl.assignField(StateManagerImpl.java:696)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1608)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1591)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.pcGetfieldlanguagesvalues_id(Fieldlanguagesvalues.java)
> ~[openmeetings.jar:na]
> at
> org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.getFieldlanguagesvalues_id(Fieldlanguagesvalues.java:44)
> ~[openmeetings.jar:na]
> at
> org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAndLanguage(Fieldmanagment.java:322)
> ~[openmeetings.jar:na]
> at
> org.openmeetings.app.data.basic.Fieldmanagment$$FastClassByCGLIB$$fd1196f9.invoke(<generated>)
> [cglib-2.2.2.jar:na]
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
> [cglib-2.2.2.jar:na]
> at
> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
> [org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> [org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
> [org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> [org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
> [org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.openmeetings.app.data.basic.Fieldmanagment$$EnhancerByCGLIB$$7fe049d4.addFieldValueByFieldAndLanguage(<generated>)
> [cglib-2.2.2.jar:na]
> at
> org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java:820)
> [openmeetings.jar:na]
> at
> org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java:328)
> [openmeetings.jar:na]
> at
> org.apache.velocity.tools.view.VelocityViewServlet.doRequest(VelocityViewServlet.java:217)
> [velocity-tools-view-2.0.jar:2.0]
> at
> org.apache.velocity.tools.view.VelocityViewServlet.doPost(VelocityViewServlet.java:192)
> [velocity-tools-view-2.0.jar:2.0]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> [javaee-api-5.1.2.jar:5.1.2]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> [javaee-api-5.1.2.jar:5.1.2]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:35)
> [openmeetings.jar:na]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:78)
> [red5.jar:na]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
> [tomcat-coyote-6.0.32.jar:6.0.32]
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
> [tomcat-coyote-6.0.32.jar:6.0.32]
> at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> [tomcat-coyote-6.0.32.jar:6.0.32]
> at java.lang.Thread.run(Thread.java:679) [na:1.6.0_22]
> Caused by: org.apache.openjpa.persistence.PersistenceException: Incorrect
> string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1
> {prepstmnt 2107496226 INSERT INTO fieldlanguagesvalues (deleted,
> fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?, ?,
> ?, ?, ?) [params=?, ?, ?, ?, ?, ?]} [code=1366, state=HY000]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:143)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:742)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:661)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> ~[openjpa-2.1.0.jar:2.1.0]
> ... 44 common frames omitted
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Incorrect
> string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1
> {prepstmnt 2107496226 INSERT INTO fieldlanguagesvalues (deleted,
> fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?, ?,
> ?, ?, ?) [params=?, ?, ?, ?, ?, ?]} [code=1366, state=HY000]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:257)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1199)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:267)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:118)
> ~[openjpa-2.1.0.jar:2.1.0]
> ... 56 common frames omitted
> ERROR 04-02 17:11:18.450 Install.java 276923 398
> org.openmeetings.servlet.outputhandler.Install [http-0.0.0.0-5080-1] -
> Install:
> org.springframework.orm.jpa.JpaSystemException: The transaction has been
> rolled back. See the nested exceptions for details on the errors that
> occurred.; nested exception is <openjpa-2.1.0-r422266:1071316 fatal general
> error> org.apache.openjpa.persistence.PersistenceException: The transaction
> has been rolled back. See the nested exceptions for details on the errors
> that occurred.
> FailedObject:
> org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues@6f7b847c
> at
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:311)
> ~[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)
> ~[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:471)
> ~[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
> ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
> ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
> ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
> ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
> ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.openmeetings.app.data.basic.Fieldmanagment$$EnhancerByCGLIB$$7fe049d4.addFieldValueByFieldAndLanguage(<generated>)
> ~[cglib-2.2.2.jar:na]
> at
> org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java:820)
> ~[openmeetings.jar:na]
> at
> org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java:328)
> ~[openmeetings.jar:na]
> at
> org.apache.velocity.tools.view.VelocityViewServlet.doRequest(VelocityViewServlet.java:217)
> [velocity-tools-view-2.0.jar:2.0]
> at
> org.apache.velocity.tools.view.VelocityViewServlet.doPost(VelocityViewServlet.java:192)
> [velocity-tools-view-2.0.jar:2.0]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> [javaee-api-5.1.2.jar:5.1.2]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> [javaee-api-5.1.2.jar:5.1.2]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:35)
> [openmeetings.jar:na]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:78)
> [red5.jar:na]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
> [tomcat-coyote-6.0.32.jar:6.0.32]
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
> [tomcat-coyote-6.0.32.jar:6.0.32]
> at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> [tomcat-coyote-6.0.32.jar:6.0.32]
> at java.lang.Thread.run(Thread.java:679) [na:1.6.0_22]
> Caused by: org.apache.openjpa.persistence.PersistenceException: The
> transaction has been rolled back. See the nested exceptions for details on
> the errors that occurred.
> at
> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2316)
> ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2153)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2051)
> ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1822)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:609)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.StateManagerImpl.assignField(StateManagerImpl.java:696)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1608)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1591)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.pcGetfieldlanguagesvalues_id(Fieldlanguagesvalues.java)
> ~[openmeetings.jar:na]
> at
> org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.getFieldlanguagesvalues_id(Fieldlanguagesvalues.java:44)
> ~[openmeetings.jar:na]
> at
> org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAndLanguage(Fieldmanagment.java:322)
> ~[openmeetings.jar:na]
> at
> org.openmeetings.app.data.basic.Fieldmanagment$$FastClassByCGLIB$$fd1196f9.invoke(<generated>)
> ~[cglib-2.2.2.jar:na]
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
> ~[cglib-2.2.2.jar:na]
> at
> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
> ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
> ~[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> ... 29 common frames omitted
> Caused by: org.apache.openjpa.persistence.PersistenceException: Incorrect
> string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1
> {prepstmnt 2107496226 INSERT INTO fieldlanguagesvalues (deleted,
> fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?, ?,
> ?, ?, ?) [params=?, ?, ?, ?, ?, ?]} [code=1366, state=HY000]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:143)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:742)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:661)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> ~[openjpa-2.1.0.jar:2.1.0]
> ... 44 common frames omitted
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Incorrect
> string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1
> {prepstmnt 2107496226 INSERT INTO fieldlanguagesvalues (deleted,
> fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?, ?,
> ?, ?, ?) [params=?, ?, ?, ?, ?, ?]} [code=1366, state=HY000]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:257)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1199)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:267)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:118)
> ~[openjpa-2.1.0.jar:2.1.0]
> ... 56 common frames omitted
> [ERROR] [http-0.0.0.0-5080-1]
> org.apache.catalina.core.ContainerBase.[red5Engine].[0.0.0.0].[/openmeetings].[Install]
> - Servlet.service() for servlet Install threw exception
> java.lang.NullPointerException: null
> at
> org.apache.velocity.tools.view.VelocityView.performMerge(VelocityView.java:942)
> ~[velocity-tools-view-2.0.jar:2.0]
> at
> org.apache.velocity.tools.view.VelocityView.merge(VelocityView.java:902)
> ~[velocity-tools-view-2.0.jar:2.0]
> at
> org.apache.velocity.tools.view.VelocityViewServlet.mergeTemplate(VelocityViewServlet.java:318)
> ~[velocity-tools-view-2.0.jar:2.0]
> at
> org.apache.velocity.tools.view.VelocityViewServlet.doRequest(VelocityViewServlet.java:220)
> ~[velocity-tools-view-2.0.jar:2.0]
> at
> org.apache.velocity.tools.view.VelocityViewServlet.doPost(VelocityViewServlet.java:192)
> ~[velocity-tools-view-2.0.jar:2.0]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> ~[javaee-api-5.1.2.jar:5.1.2]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> ~[javaee-api-5.1.2.jar:5.1.2]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> ~[catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> ~[catalina-6.0.32.jar:6.0.32]
> at
> org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:35)
> ~[openmeetings.jar:na]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> ~[catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> ~[catalina-6.0.32.jar:6.0.32]
> at
> org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:78)
> ~[red5.jar:na]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> ~[catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> ~[catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> ~[catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> [catalina-6.0.32.jar:6.0.32]
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
> [tomcat-coyote-6.0.32.jar:6.0.32]
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
> [tomcat-coyote-6.0.32.jar:6.0.32]
> at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> [tomcat-coyote-6.0.32.jar:6.0.32]
> at java.lang.Thread.run(Thread.java:679) [na:1.6.0_22]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
