Hi there,

can you tell me what the circumstances under which I might get a "could not retrieve snapshot" might be?


Kind regards,

Aoife



Hibernate version:
Hibernate 3


Stack Trace:
org.hibernate.exception.SQLGrammarException: could not retrieve snapshot: [com.statestr.ssiil.axa.entity.PendingTrade#component[pendingRid]{pendingRid=3526297}]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1008)
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:304)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:460)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:84)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:520)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:513)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:509)
at com.statestr.ssiil.axa.dao.hibernate.PendingTradeDAO.saveListItemEntity(PendingTradeDAO.java:129)
at com.statestr.ssiil.axa.dao.hibernate.PendingTradeDAO.saveListItemEntity(PendingTradeDAO.java:113)
at com.statestr.ssiil.axa.dao.hibernate.BaseDAO.saveEntity(BaseDAO.java:344)
at com.statestr.ssiil.axa.job.EnvPendingTradeJob.process(EnvPendingTradeJob.java:342)
at com.statestr.ssiil.axa.job.EnvPendingTradeJob.run(EnvPendingTradeJob.java:91)
at com.statestr.ssiil.axa.threadpool.AxaPooledExecutor$Worker.runTask(AxaPooledExecutor.java:428)
at com.statestr.ssiil.axa.threadpool.AxaPooledExecutor$Worker.run(AxaPooledExecutor.java:292)
at java.lang.Thread.run(Thread.java:534)

Name and version of the database you are using:
Oracle

are you using saveOrUpdate()? try just save().