You need to set the server-character-set to utf8 drop the tables and rerun the installer.
Sebastian Am 10.03.2011 18:15 schrieb "Lex Later" <[email protected]>: > I added > org.openmeetings.app.hibernate.utils.MySQL5MyISAMDialect < > and the situation has improved. (where was the indication of using > this new dialect? in the file mysql_hibernate have not seen it :( ). > > I have now successfully created 51 tables but after I launched an > exception: > --------------------------------------- > [WARN] [http-0.0.0.0-5080-1] org.hibernate.util.JDBCExceptionReporter > - SQL Erro > r: 1366, SQLState: HY000 > [ERROR] [http-0.0.0.0-5080-1] org.hibernate.util.JDBCExceptionReporter > - Incorre > ct string value: '\xD0\x9C\xD0\xBE\xD0\xB4...' for column 'value' at > row 1 > [ERROR] [http-0.0.0.0-5080-1] > org.hibernate.event.def.AbstractFlushingEventListe > ner - Could not synchronize database state with session > org.hibernate.exception.GenericJDBCException: Could not execute JDBC > batch updat > e > at > org.hibernate.exception.SQLStateConverter.handledNonSpecificException > (SQLStateConverter.java:140) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j > ava:128) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp > er.java:66) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: > 275) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.event.def.AbstractFlushingEventListener.performExecutio > ns(AbstractFlushingEventListener.java:321) [hibernate3.jar: > 3.6.1.Final] > at > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus > hEventListener.java:51) [hibernate3.jar:3.6.1.Final] > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) > [hibernat > e3.jar:3.6.1.Final] > at > org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) [hi > bernate3.jar:3.6.1.Final] > at > org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java > :133) [hibernate3.jar:3.6.1.Final] > at > org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAn > dLanguage(Fieldmanagment.java:343) [openmeetings.jar:na] > at > org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages( > ImportInitvalues.java:724) [openmeetings.jar:na] > at > org.openmeetings.servlet.outputhandler.Install.handleRequest(Install. > java:226) [openmeetings.jar:na] > at > org.apache.velocity.tools.view.servlet.VelocityViewServlet.doRequest( > VelocityViewServlet.java:541) [velocity-tools-view-1.3.jar:1.3] > at > org.apache.velocity.tools.view.servlet.VelocityViewServlet.doPost(Vel > ocityViewServlet.java:517) [velocity-tools-view-1.3.jar:1.3] > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > 637) [javaee- > api-5.1.1.jar:5.1.1] > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > 717) [javaee- > api-5.1.1.jar:5.1.1] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl > icationFilterChain.java:290) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF > ilterChain.java:206) [catalina-6.0.24.jar:na] > at > org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilte > r(ServletRequestExFilter.java:35) [openmeetings.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl > icationFilterChain.java:235) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF > ilterChain.java:206) [catalina-6.0.24.jar:na] > at > org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.jav > a:87) [red5.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl > icationFilterChain.java:235) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF > ilterChain.java:206) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV > alve.java:233) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextV > alve.java:191) [catalina-6.0.24.jar:na] > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica > torBase.java:465) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j > ava:127) [catalina-6.0.24.jar:na] > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j > ava:102) [catalina-6.0.24.jar:na] > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: > 555) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal > ve.java:109) [catalina-6.0.24.jar:na] > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav > a:298) [catalina-6.0.24.jar:na] > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java > :852) [tomcat-coyote-6.0.24.jar:na] > at org.apache.coyote.http11.Http11Protocol > $Http11ConnectionHandler.proce > ss(Http11Protocol.java:588) [tomcat-coyote-6.0.24.jar:na] > at org.apache.tomcat.util.net.JIoEndpoint > $Worker.run(JIoEndpoint.java:48 > 9) [tomcat-coyote-6.0.24.jar:na] > at java.lang.Thread.run(Unknown Source) [na:1.6.0_24] > Caused by: java.sql.BatchUpdateException: Incorrect string value: > '\xD0\x9C\xD0\ > xBE\xD0\xB4...' for column 'value' at row 1 > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme > nt.java:2024) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java: > 1449) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr > oxyPreparedStatement.java:1723) [c3p0-0.9.1.jar:0.9.1] > at > org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav > a:70) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: > 268) [hibernate3.jar:3.6.1.Final] > -------------------------- > > I've stopped all. > What is? :( > My fault? > > > On 10 Mar, 17:21, "[email protected]" <[email protected]> > wrote: >> Lex, >> >> please download the latest version 1.6.2 >> >> You will see that in the hibernate.cfg.xml there is a new dialect: >> <property >> name="dialect">org.openmeetings.app.hibernate.utils.MySQL5MyISAMDialect</property> >> >> That is only available starting with OpenMeetings 1.6.2 >> >> Sebastian >> >> 2011/3/10 Lex Later <[email protected]> >> >> >> >> >> >> > Hi everyone, >> > I'm tryng to install Openmeetings in a VM with Windows7, MySQL 5.5.8, >> > JRE6 (path JAVA_HOME ok) but after I think 10 try I have every time >> > the same problem. >> > I hope this piece of error log can be useful. >> > ----------------------- >> > 2011-03-10 16:54:53,195 [Launcher:/openmeetings] ERROR >> > o.h.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table >> > appointmentremindertyps (typ_id bigint not null, name varchar(255), >> > user_id bigint, starttime datetime, updatetime datetime, deleted >> > varchar(255), comment_field varchar(255), primary key (typ_id)) >> > type=MyISAM >> > 2011-03-10 16:54:53,205 [Launcher:/openmeetings] ERROR >> > o.h.tool.hbm2ddl.SchemaUpdate - You have an error in your SQL syntax; >> > check the manual that corresponds to your MySQL server version for the >> > right syntax to use near 'type=MyISAM' at line 1 >> > 2011-03-10 16:54:53,205 [Launcher:/openmeetings] ERROR >> > o.h.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table >> > appointments (appointment_id bigint not null, user_id bigint, >> > appointmentname varchar(255), location varchar(255), >> > appointment_starttime datetime, appointment_endtime datetime, >> > description varchar(255), category_id bigint, remind_id bigint, >> > starttime datetime, updatetime datetime, deleted varchar(255), >> > comment_field varchar(255), isweekly bit, ismonthly bit, isyearly bit, >> > isdaily bit, room_id bigint, icalId varchar(255), language_id bigint, >> > is_password_protected bit, password varchar(255), is_connected_event >> > bit, primary key (appointment_id)) type=MyISAM >> > [...] >> > ----------------------- >> >> > This my hibernate conf file >> > --------------------- >> > <hibernate-configuration> >> >> > <!-- a SessionFactory instance listed as /jndi/name --> >> > <session-factory> >> >> > <!-- User / Password --> >> > <property name="connection.username">root</property> >> > <property name="connection.password"></property> >> >> > <!-- Database Settings --> >> > <property >> > name="connection.driver_class">com.mysql.jdbc.Driver</ >> > property> >> > <!-- for performance reasons changed to MyISAM from >> > org.hibernate.dialect.MySQLInnoDBDialect --> >> > <property >> > name="dialect">org.hibernate.dialect.MySQLMyISAMDialect</ >> > property> >> > <property >> > name="connection.url">jdbc:mysql://localhost/openmeetings? >> >> > autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8</ >> > property> >> > [...] >> > --------------------- >> >> > Username and password (blank) are tested and working >> > the installation process appears to connect successfully to the >> > database since it can create a new one called OpenMeetings >> > (createDatabaseIfNotExist=true) but no tables are created.... damn... >> > what is the problem? :( >> >> > -- >> > You received this message because you are subscribed to the Google Groups >> > "OpenMeetings developers" group. >> > To post to this group, send email to [email protected]. >> > To unsubscribe from this group, send email to >> > [email protected]. >> > For more options, visit this group at >> >http://groups.google.com/group/openmeetings-dev?hl=en. >> >> -- >> Sebastian Wagnerhttp://www.webbase-design.dehttp://openmeetings.googlecode.comhttp:// www.wagner-sebastian.com >> [email protected] Nascondi testo citato >> >> - Mostra testo citato - > > -- > You received this message because you are subscribed to the Google Groups "OpenMeetings developers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to [email protected]. > For more options, visit this group at http://groups.google.com/group/openmeetings-dev?hl=en. > -- You received this message because you are subscribed to the Google Groups "OpenMeetings developers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/openmeetings-dev?hl=en.
