search

Neseek77 / openmeetings

Automatically exported from code.google.com/p/openmeetings
1 stars 0 forks source link

Incorrect SQL upon installation procedure #1239

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
When installation script creates database structure, the error log file
shows to many errors: "Incorrect string value:
'\xCE\x95\xCE\xBC\xCF\x86...' for column 'value' at row 1"
Chosed language: russian.
After installation, login screen contains "error" strings instead of
labels: username, email, password, ....

2010-06-05 05:56:37,699 [http-5080-1] ERROR
o.h.e.d.AbstractFlushingEventListener - Could not synchronize database
state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
update
    at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateCo
nverter.java:126)
[hibernate3.jar:na]
    at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
[hibernate3.jar:na]
    at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[hibernate3.jar:na]
    at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
[hibernate3.jar:na]
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
[hibernate3.jar:na]
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
[hibernate3.jar:na]
    at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(Abstract
FlushingEventListener.java:321)
[hibernate3.jar:na]
    at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListe
ner.java:50)
[hibernate3.jar:na]
    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
[hibernate3.jar:na]
    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
[hibernate3.jar:na]
    at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
[hibernate3.jar:na]
    at
org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAndLanguage(F
ieldmanagment.java:326)
[openmeetings.jar:na]
    at
org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitv
alues.java:497)
[openmeetings.jar:na]
    at
org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java:178)
[openmeetings.jar:na]
    at
org.apache.velocity.tools.view.servlet.VelocityViewServlet.doRequest(VelocityVie
wServlet.java:541)
[velocity-tools-view-1.3.jar:1.3]
    at
org.apache.velocity.tools.view.servlet.VelocityViewServlet.doPost(VelocityViewSe
rvlet.java:517)
[velocity-tools-view-1.3.jar:1.3]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
[javaee-api-5.1.0-RC3.jar:5.1.0-RC3]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
[javaee-api-5.1.0-RC3.jar:5.1.0-RC3]
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:290)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206)
[catalina-6.0.20-patched.jar:na]
    at
org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRe
questExFilter.java:35)
[openmeetings.jar:na]
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206)
[catalina-6.0.20-patched.jar:na]
    at
org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:70)
[red5.jar:na]
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
33)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
91)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.jav
a:433)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109
)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
[catalina-6.0.20-patched.jar:na]
    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:847)
[tomcat-coyote-6.0.20-patched.jar:na]
    at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Pr
otocol.java:583)
[tomcat-coyote-6.0.20-patched.jar:na]
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
[tomcat-coyote-6.0.20-patched.jar:na]
    at java.lang.Thread.run(Thread.java:619) [na:1.6.0_20]
Caused by: java.sql.BatchUpdateException: Incorrect string value:
'\xCE\x95\xCE\xBC\xCF\x86...' for column 'value' at row 1
    at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:169
3)
[mysql-connector-java-5.1.7-bin.jar:na]
    at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1108)
[mysql-connector-java-5.1.7-bin.jar:na]
    at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPrepared
Statement.java:1723)
[c3p0-0.9.1.jar:0.9.1]
    at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
[hibernate3.jar:na]
    at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
[hibernate3.jar:na]

Original issue reported on code.google.com by Dicr.Tarasov on 5 Jun 2010 at 3:03

GoogleCodeExporter commented 9 years ago 
When importing language from file openmeetings/languages/russian.xml got the 
same 
error. The source file is in utf-8 encoding, but SQL string contains escaped 
UTF-8 
chars instead of notmal chars.

Original comment by Dicr.Tarasov on 5 Jun 2010 at 4:23

GoogleCodeExporter commented 9 years ago 
This error occurs because of hibernate using UTF8 charset in connection, BUT 
tables
created by installation script withowt specify default charset. So it become 
latin1
as default. To fix this CREATE TABLE script in hibernate must use DEFAUL 
CHARSET=utf8

Original comment by Dicr.Tarasov on 5 Jun 2010 at 5:52

GoogleCodeExporter commented 9 years ago 
the problem is that you should set the default charset to UTF8 in MySQL. There 
is no option to create the database scheme with UTF8, this option is not 
available by the db-scheme auto creation.

Original comment by seba.wag...@gmail.com on 15 Jul 2010 at 4:52