Hi All,

We are facing the following problem in beta which is causing the application to stall and a server restart is needed make it work. Once server is restarted the application works fine for a few mins and the problem surfaces again. The server log is attached for reference:

2008-02-14 14:11:53,282 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session

org.hibernate.jdbc.BatchFailedException: Batch update failed: 0

at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:57)

at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)

at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)

at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)

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.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)

at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) ...........

The details of hibernate version and db are as follows:
Hibernate version:3.2.4.sp1
SQL Server 2005 Std Edition

Any inputs would be extremely helpfull.
Thanks in advance.