I am writing an application to replicate data between two data sources. I have written an interceptor that works great and the code works fine if we don't engage batching. Unfortunately, this application needs to support batching because of the amount of data. My current attempt fails because of ordering issues.

Can anyone please point me in the right direction so I can learn how hibernate orders the table for batch writes?

Hibernate verion 3.6.10
Java: 1.6 (64 bit)

An additional note, we are doing the replication using JDBC so that we can transport the primary keys, etc. I do have access to the metadata within the SessionFactory, so I can retrieve the information from there if it's available.

Thank you in advance.

Why do you need ordering when you replicate primary keys?

Good question. We do have the primary keys, however, it's the foreign keys that are the problem. I'm inserting a record into the database so any parent tables must be inserted first.