Hello,

I'm charged with a fairly simple task of moving all data from one database to an identical database at a different location, deleting the data from the source. I have done this by instantiating two sessions, one for each JDBC connection. When I try to save data that has associations, I run into problems.

If I try to save the data to the new table without calling evict() on the data with associations I get HibernateException: Illegal attempt to associate a collection with two open sessions . When I evict the data in question from the original session, the save works without error. However, once I try to commit the changes on the source data session, I get:

org.hibernate.AssertionFailure: possible nonthreadsafe access to session

Does anyone know how this can be avoided?

Thanks

Anybody? Bueller?

Are you passing sessions between threads?? Maybe you should post your code, and the full stack trace of the exception.