Guys

Let me explain you how the data is processed.

We are extracting records from Db2 using normal JDBC program and updating the result set into Oracle.

Since the Db2 connection is retained for more than 1 hr, we are facing deadlock situation in Db2. We are updating around 20 k records in this process.

Have a plan to use Hibernate to do the above. If I want to use Hibernate for the above situation, single mapping file is enough for both databases or I need to create a separate mapping file ie 2 files. one for DB2 and one for Oracle. How is the peroformance if I use hibernate.. ie around 20 k objects will be used.......

Has anobody met this type of situation....Pls share your ideas with me...

few days before there was a post about this open source product

http://www.enhydra.org/tech/octopus/index.html

It can help you.