First of all: We are using Hibernate since almost 2 years and are very happy with it!
We are now in the need of integrating a Master-Slave replication in our existing PostgreSQL server. For now we are still evaluating possible solutions and want to give
SkyTools a try.
Unfortunately SkyTools does not work with tables, consisting of multi column primary keys. We have approx. 5-10 tables that have primary keys with 2 or more columns and are mapped by Hibernate. To get rid of those multi column pks we'd add a new synthetic key (+ sequence) to the affected tables and switch the pk to the new synthetic key.
We rely on the second-level cache a lot and still want to benefit from it, after converting the existing tables. And therefore we'd like to know the following:
1. Does the second-level cache merely rely on the pk, set in the table?
2. If not, can Hibernate be configured to use other columns as the ones defined in the pk?