Hi there,

i am fairly new to hibernate and have to work into an spring/hibernate application structure which should be used in future in addition to an existing php application.

Now, the problem is, we have tables which have a primary key called 'autoid' and a "real" primary key which is a combination of two columns 'id' and 'endstempel_id'.

I have a Unternehmen Entity:


and the adresse table:


Now, when i load an Unternehmen entity hibernate also loads the adresse entity, despite the fact i told it to lazy load.
I found out that our primary combination is the problem here.
If i use:


then everything works as expected.

How can i get around this?

When i load all Unternehmen from the database it loads every related entity and fires one single sql for every entity, which puts a heavy load onto the server.

Thanks in Advance
Sven

Inbetween i found out that i can use multiple @Ids in one Entity and reference them.
This way lazy loading does work, but it offers us another problem.

In our tables we have the composition of two fields: 'id' and 'endstempel_id'. They are our primary key now.
We use these columns for history saving, and the latest entry is always the one with id:x and endstempel_id: 3999999999.

What i have to do, to make lazy loading work, is to add a foreign key column for every other table i reference too.

For my example this means i have to add a adresse_endstempel_id column in the unternehmen table, which defaults to (and always is): 3999999999.
This seems stupid to me, but this is the only thing i found so far.

And what seems worse is that, for every relation i have in my table (another adress, user, etc.) i have to add another foreign key column, which always has the entry 3999999999, which just causes my DB to get filled up with useless data.

This is the code i have now:


and


Is there a way to work around this? What i imagine is to tell hibernate that the

is our fixed 3999999999 value.

Greetings
Sven