DDL and data are in mysql database .
we need to migrate to hsqldb.
we are having correct hbm files.
we have successful created the DDL with the help of
<property name="hibernate.hbm2ddl.auto">create</property>
now we need data. so i planned to write a event
say when there is a load in mysql it will save it in hsqldb database.
but i get "org.hibernate.HibernateException: Illegal attempt to associate a collection with two open sessions"
please help me how to solve this problem.