yesyesyes just done :) Tnx a lot Sebastian! On 10 Mar, 18:56, "[email protected]" <[email protected]> wrote: > You need to set the server-character-set to utf8 drop the tables and rerun > the installer.... > > leggi tutto > > 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- Nascondi testo citato > > - Mostra testo citato -- Nascondi testo citato > > - Mostra testo citato -- 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.
