Hi there:

Maybe some of you can enlighten me, after having an app running for a
long time I ve got this errors in my log.

2007-05-01 21:55:01,523 3123042484 ERROR
[DefaultQuartzScheduler_Worker-9]
org.hibernate.event.def.AbstractFlushingEventListener - Could not
synchronize database state with session
org.hibernate.HibernateException: Unexpected row count: 0 expected: 1
at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:
32)
at
org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:
1982)
at
org.hibernate.persister.entity.BasicEntityPersister.updateOrInsert(BasicEntityPersister.java:
1909)
at
org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:
2149)
at
org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:
75)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:
223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:
137)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:
274)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:
27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:
86)
...

please do keep in mind that this section of the application runs very
often so I can only think in a data related issue, but I cant find
anything useful after a good google round.
any ideas?

Jo.

This can happen if you try to update/delete a not existing row.

You could try saveOrUpdate

edit: duh, I misread (expect 1, found 0) previous comment removed

??

I suppose in your Source there is something like

session.update(anyData);

But if the row associated to anyData doesnt exist (maybe because it wasnt inserted or because you deleted ist), you get this exception.

If anyData was deleted by any other thread or application, you have a problem, otherwise you can use

session.saveOrUpdate(anyData)

hi there:

actually the code is more like this

try
session.save(something);
catch
session.update(anyData);
....
....