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.
