I have a test database and a production database (most of us do). I want to be able to take data exactly as it exists from my production database and save it into my test database. The hibernate configuration files and the POJOs are the same regardless of datasource. I want to know if it is possible to populate the POJOs while connected to the production datasource and then change my datasource on the fly and save the POJOs to my test datasource.
I am using Hibernate 3.
I am connecting to a Test DB2 environment and a Production DB2 environment.
I am still relatively new to Hibernate. So bear with me.
Thanks,
Christopher

you could set up a second session factory that connects to your test database and then copy from production POJOS to test POJOS. For instance if you have com.yourapp.model.PojoOne you will need a com.yourapp.model.test.PojoOne, then use BeanUtils to copy from
com.yourapp.model.PojoOne to com.yourapp.model.test.PojoOne and that it.good luck.

I am using Spring + Hibernate - sorry I didn't mention that in my earlier post.
I have defined a test sessionFactory in my applicationContext with a test DataSource. I have followed your advice and created a test POJO and placed its mapping in the list of mappingResources in the applicationContext. The only problem is that I feel like I am going to have to create two new test packages; com.yourapp.test.dao and com.yourapp.dao.test.hibernate to accomodate this strategy. It is certainly something I could do, but it would require a lot of duplicate code since both databases have the same schema and the corresponding methods in the test.dao and .dao would be the same.
Is there a way for me to retrieve the Production Pojo from the database using getHibernateTemplate().find() in the com.yourapp.dao.hibernate.PojoOneDaoHibernate class which is mapped to the production sessionFactory and then do a getHibernateTemplate().setSessionFactory(arg0) that programmatically sets the sessionFactory to the testSessionFactory that I have defined in the applicationContext? If I can programmatically change to the new sessionFactory then I could simply copy the production Pojos into test Pojos and call getHibernateTemplate.save() and they would be saved through the testSessionFactory and into the test datasource.

Hello, Sorry but I am not familiar with Spring yet, so I do not Know if what I am about to tell you could help you.
You want to copy from
com.yourapp.dao.hibernate.PojoOneDaoHibernate (production) to
com.yourapp.dao.test.PojoOneDaoHibernate (test) right.

What I used to do is create SessionFactoryManager class that stores statically (in some static Hashtable property) references to all org.hibernate.SessionFactory builded for my application.
For 2 databases I will need 2 different SessionFactory each one with a different Id, so I can call SessionFactoryManager.getSession(String id).

With this approach you can code something like this

Hello, Sorry but I am not familiar with Spring yet, so I do not Know if what I am about to tell you could help you.
You want to copy from
com.yourapp.dao.hibernate.PojoOneDaoHibernate (production) to
com.yourapp.dao.test.PojoOneDaoHibernate (test) right.

What I used to do is create SessionFactoryManager class that stores statically (in some static Hashtable property) references to all org.hibernate.SessionFactory builded for my application.
For 2 databases I will need 2 different SessionFactory each one with a different Id, so I can call SessionFactoryManager.getSession(String id).

With this approach you can code something like this



That is the idea, well you will need to code it right off course but this should work, as a matter of fact I have used it for copy from one database to another.
Hope it works!!, let me Know