Hello,

One project has so much OLTP data (increasing daily by millions of rows) that they have to be stored across multiple database servers (they don't want use the single Starfire-type of DB server, which can be a single point of failure). some tables (e.g. daily order/sales) are so large that have to be split across multiple servers.

How can Hibernate being used in this enviornment, if we want to hide physical database layout from business logic?

Thx
Chuck

Maybe you can use this: http://c-jdbc.objectweb.org/

Thx for the reply. But I have large tables split across several DB servers, e.g. DB server1 table X holds data for rows with PK _ID = 1 to 1,000,000,000. DB server2 table X holds data for rows with PK_ID = 1,000,000,001 to 2,000,000,000. It does not appear C-JDBC helps in this case. Any other solutions?

Thx
chuck