AnsweredAssumed Answered

'Could not execute JDBC batch update' error

Question asked by edgar on Jul 3, 2007
Latest reply on Jul 4, 2007 by kvc
When I try to all my changed resources in my Web Project through the default Web Site Submission workflow I get a "Could not execute JDBC batch update" error.

From the alfresco.log file:

13:54:23,782 ERROR [org.alfresco.web.ui.common.Utils] A system error happened during the operation: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused by:
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
   at org.alfresco.repo.avm.hibernate.AVMNodeDAOHibernate.flush(AVMNodeDAOHibernate.java:175)
   at org.alfresco.repo.avm.PlainDirectoryNodeImpl.putChild(PlainDirectoryNodeImpl.java:281)
   at org.alfresco.repo.avm.AVMStoreImpl.createSnapshot(AVMStoreImpl.java:234)
   at org.alfresco.repo.avm.AVMRepository.createSnapshot(AVMRepository.java:812)
   at org.alfresco.repo.avm.AVMServiceImpl.createSnapshot(AVMServiceImpl.java:620)
   at sun.reflect.GeneratedMethodAccessor496.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)

Admittedly, it is quite a large batch: 27MB in all (largely due to a number of PDF files). Could that be the problem?

This is in Alfresco 2.1.0RC1 on Windows with all default settings (HSQL).

regards,

Edgar

Outcomes