Hi!

I'm using hibernate with annotations.

I have two classes. Player and Club. A Player object has to contain a clubId and a Club object has to contain a list of playerIds.

Additionally a Club object should contain a transient list of players and a Player object should contain a transient Club object.

Each of the Classes has a controller. The controller should have two methods to load a class object. One method simply creates objects without related objects (with only ids of the related objects), the other method additionally loads the related objects.

What in hell do I have to do?

As you see, I'm a greenhorn with hibernate.

A helpful answer would be great!
Thx!

Eventhorizon

Why do you want to keep a list of IDs instead of actual objects?


Farzad-

Hi farzad!

Because of sometimes I need a list of players with clubs and sometimes I do not need the club information.

I always want to handle as compact data as possible.

Greetings
EH

You could always get the list of objects and for your performance concerns you could use a second level cache. That works nicely and the performance will be surprisingly good.



Farzad-

Okay. I'll try it out.

But initially I will have the following structure:

Club 1-* Player *-* Team *-* Match 1-* Game 1-* Result

So I do not know how the select queries will behave. I told hibernate to fetch a depth-level of 3. In my opinion the actual problem is that I do not really understand how the hibernate engine will handle a lot of such data sets.

For now I will try to create such a database structure with simple hibernate annotations.

I assume that the db-structure hibernate will generate looks as follows:

Club 1-* Player 1-* PlayerTeam *-1 Team 1-* TeamMatch *-1 Match 1-* Game 1-* Result

I would accept any further help in thanks! :-) (<- That does not look like an acceptable english sentence, does it?)

Thx, EH

Okay, made a step forward.

I Have defined all my bean classes and the structure nearly looks like what I expected to look like (have to check this in depth later on).

For my next Problem, I'll create a new topic.