Hi!

First, I know that there is no way to map a class to multiple tables in Hibernate 2 (and I can't use Hib3, 'cause the managers fears the "beta" state of the release, too bad... ). So, I just wanted to know a way to write my mapping.

Here is a description:

My warrant has a name, an age, and a code associated with it. The code depends of the place where my warrant live.

The table of the warrant is:



the table with the codes is:



My POJO is:



Please, do you know any way to do this kind of mapping?

One of the difficulty is that the code depends on the placeId, and not the warrant id, so there is no one-to-one mapping between warrant table and code table.
The second difficulty is that I want to avoid, if possible, to create a class containing just the code, and the corresponding mapping. So a one-to-many mapping seems a bit too much for this problem, (since there is only one code, not a collection of codes, and since I need to create a wrapping object just containing the fields "id" and "code").
The last little thing is that I want to avoid putting the code directly in the warrant, because I already have the code table, and I can't change it.

It is like getting the property code from another table, depending on the value of the placeId.

I can change the warrant table , if there is a better database design for this problem, but I can't change the code table.

(Sorry for my bad english writing)

Thanks!
Cyril

I finally solve that by creating an object for the code, and a many-to-one association.

I'm still interested in a more elegant solution (something in the mapping of the warrant), but the creation and the mapping of this simple object is quite easy and straightforward:



I think this solution will be okay (but perhaps a one-to-many would be better).

Don't hesitate to post another solution for this problem, I would be glad to learn a new way of doing this kind of thing (a reference to another table from a table).

Cyril