error when putting too much text in the comment of a meeting room

on saving a meeting room with verbose text in the comment an unknown error
occurs.
log trace below, interesting part appears to be "Data truncation: Data too
long for column 'comment' at row 1"

2009-07-29 16:49:29,161 [NioProcessor-3] ERROR
o.o.a.d.conference.Roommanagement - [updateRoom] 
org.hibernate.exception.DataException: Could not execute JDBC batch update
    at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)
[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:168)
[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.conference.Roommanagement.updateRoom(Roommanagement.ja
va:885)
[openmeetings.jar:na]
    at
org.openmeetings.app.remote.ConferenceService.saveOrUpdateRoom(ConferenceService
.java:356)
[openmeetings.jar:na]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_13]
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[na:1.6.0_13]
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
a:25)
[na:1.6.0_13]
    at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_13]
    at org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:200)
[red5.jar:na]
    at org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:118)
[red5.jar:na]
    at org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:152)
[red5.jar:na]
    at org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:392)
[red5.jar:na]
    at
org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:14
6)
[red5.jar:na]
    at
org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.jav
a:129)
[red5.jar:na]
    at
org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived
(DefaultIoFilterChain.java:721)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(De
faultIoFilterChain.java:433)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilte
rChain.java:47)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceive
d(DefaultIoFilterChain.java:801)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush
(ProtocolCodecFilter.java:375)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFi
lter.java:229)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(De
faultIoFilterChain.java:433)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilte
rChain.java:47)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceive
d(DefaultIoFilterChain.java:801)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter
.java:119)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(De
faultIoFilterChain.java:433)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(Defaul
tIoFilterChain.java:425)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoPr
ocessor.java:603)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingI
oProcessor.java:563)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingI
oProcessor.java:552)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPolli
ngIoProcessor.java:56)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPo
llingIoProcessor.java:891)
[mina-core-2.0.0-M6.jar:na]
    at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
[mina-core-2.0.0-M6.jar:na]
    at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:8
86)
[na:1.6.0_13]
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[na:1.6.0_13]
    at java.lang.Thread.run(Thread.java:619) [na:1.6.0_13]
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long
for column 'comment' 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]
    ... 40 common frames omitted
Original issue reported on code.google.com by alanbell...@gmail.com on 29 Jul 2009 at 4:46
Neseek77 / openmeetings

error when putting too much text in the comment of a meeting room #835
