Hi,

I'm new to Hibernate Shards. So I thougt I can use Hibernate Shards to solve the following problem.

In database A is a table called Invoice. It has InvoiceID and several other fields. It also has a field called customerID.
In this field customerID is the ID from the customer who belongs to the invoice. But the table customer is in database B. So you can imagine, that there is a foreign-key-relation. Of course there is not a real foreign-key-relation, because I think that it is not possible to do so about several databases.

Now I want to load and store the object invoice from database A table invoice, where it is necessary to load or store the customer belonging to the invoice in database B table customer.

Is this possible with Hibernate Shards???

If not, do you know a good object oriented way to solve this issue?

Thank you very much!!

Cheers,
Steffen

Shards does not support cross-shard relationship, so you will have to break the object relationship. One way to do it is to only store customerId in your invoice object, and do a request (session.get(Customer.class, customerId)) to load it.