You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by "Daniele Trovato (dtrovato)" <dt...@cisco.com> on 2007/09/05 14:32:37 UTC

Problem posting new Entry.

Often posting a nex Entry , specially cut and pasting text or  html
objects froma another source, the following error appear:
 
      org.apache.roller.RollerException
 at
org.apache.roller.business.hibernate.HibernatePersistenceStrategy.flush(
HibernatePersistenceStrategy.java:228)
 at
org.apache.roller.business.hibernate.HibernateRollerImpl.flush(Hibernate
RollerImpl.java:109)
 at
org.apache.roller.ui.authoring.struts.actions.WeblogEntryFormAction.save
(WeblogEntryFormAction.java:321)
 at sun.reflect.GeneratedMethodAccessor475.invoke(Unknown Source)
 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.j
ava:276)
 at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196
)
 at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:421)
 at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226)
 at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
 at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:290)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.RequestFilter.doFilter(RequestFilter.j
ava:83)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.rendering.filters.RequestMappingFilter.doFilter(Req
uestMappingFilter.java:140)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.InitFilter.doFilter(InitFilter.java:71
)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.PersistenceSessionFilter.doFilter(Pers
istenceSessionFilter.java:60)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:264)
 at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterS
ecurityInterceptor.java:107)
 at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Filte
rSecurityInterceptor.java:72)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTransl
ationFilter.java:110)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter
(AnonymousProcessingFilter.java:125)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilt
er(SecurityContextHolderAwareRequestFilter.java:81)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(Channel
ProcessingFilter.java:138)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Reme
mberMeProcessingFilter.java:142)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessin
gFilter.java:217)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(H
ttpSessionContextIntegrationFilter.java:229)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:1
48)
 at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java
:98)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.SchemeEnforcementFilter.doFilter(Schem
eEnforcementFilter.java:121)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.StrutsCharEncodingFilter.doFilter(Stru
tsCharEncodingFilter.java:90)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.CharEncodingFilter.doFilter(CharEncodi
ngFilter.java:81)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:233)
 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:175)
 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:128)
 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:102)
 at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:109)
 at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:2
63)
 at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84
4)
 at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(
Http11Protocol.java:584)
 at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Thread.java:619)
--- ROOT CAUSE ---
org.hibernate.exception.DataException: Could not execute JDBC batch
update
 at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
:75)
 at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.
java:43)
 at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202
)
 at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
 at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
 at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
AbstractFlushingEventListener.java:296)
 at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEv
entListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
 at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
 at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:10
6)
 at
org.apache.roller.business.hibernate.HibernatePersistenceStrategy.flush(
HibernatePersistenceStrategy.java:222)
 at
org.apache.roller.business.hibernate.HibernateRollerImpl.flush(Hibernate
RollerImpl.java:109)
 at
org.apache.roller.ui.authoring.struts.actions.WeblogEntryFormAction.save
(WeblogEntryFormAction.java:321)
 at sun.reflect.GeneratedMethodAccessor475.invoke(Unknown Source)
 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.j
ava:276)
 at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196
)
 at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:421)
 at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226)
 at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
 at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:290)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.RequestFilter.doFilter(RequestFilter.j
ava:83)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.rendering.filters.RequestMappingFilter.doFilter(Req
uestMappingFilter.java:140)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.InitFilter.doFilter(InitFilter.java:71
)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.PersistenceSessionFilter.doFilter(Pers
istenceSessionFilter.java:60)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:264)
 at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterS
ecurityInterceptor.java:107)
 at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Filte
rSecurityInterceptor.java:72)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTransl
ationFilter.java:110)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter
(AnonymousProcessingFilter.java:125)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilt
er(SecurityContextHolderAwareRequestFilter.java:81)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(Channel
ProcessingFilter.java:138)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Reme
mberMeProcessingFilter.java:142)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessin
gFilter.java:217)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(H
ttpSessionContextIntegrationFilter.java:229)
 at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
 at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:1
48)
 at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java
:98)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.SchemeEnforcementFilter.doFilter(Schem
eEnforcementFilter.java:121)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.StrutsCharEncodingFilter.doFilter(Stru
tsCharEncodingFilter.java:90)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.roller.ui.core.filters.CharEncodingFilter.doFilter(CharEncodi
ngFilter.java:81)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:233)
 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:175)
 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:128)
 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:102)
 at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:109)
 at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:2
63)
 at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84
4)
 at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(
Http11Protocol.java:584)
 at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long
for column 'text' at row 1
 at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.
java:1257)
 at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943
)
 at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingS
tatement.java:297)
 at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5
8)
 at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195
)
 ... 76 more
 
  It happens both using Xinha and using simple text editor and is quite
difficult understand which kind of  input is cause of the problem...
 
D.

Re: Problem posting new Entry.

Posted by Dave <sn...@gmail.com>.
On 9/5/07, Daniele Trovato (dtrovato) <dt...@cisco.com> wrote:
> Often posting a nex Entry , specially cut and pasting text or  html
> objects froma another source, the following error appear:
>
>       org.apache.roller.RollerException
>
> Caused by: java.sql.BatchUpdateException: Data truncation: Data too long
> for column 'text' at row 1

> It happens both using Xinha and using simple text editor and is quite
> difficult understand which kind of  input is cause of the problem...

Hmm... "Data too long" but the weblogentry.text field should be of
unlimited size. I'm not sure how that could happen. Did you guys make
any changes to the Roller database schema?  Will you please login to
MySQL and then do a "describe weblogentry" command so we can see the
table definition that you are using?

- Dave