Hibernate version:2.1.6

Hi;

This is my first question to this forum, since I had to do allot of reading before bothering people with questions :)

I have a strange reaction from hibernate, and I can't get it...

I have a class called "Shipment" it contains allot of info., another class called "ServiceAreaCode" that contain cities and so...

each Shipment contain 2 ServiceAreaCode objects, one is origin the other is destination...

simply... (This is a part of the map only)




now when I use only one ServiceAreaCode, it get eagerly fetched, but when I use both 2 calls are issued to the database, which make significant drop in performance.

Why? and how can I eagrly fetch these 2 objects? FetchMode doesn't work, I tried it.

I know some people would say that this is not a many-to-one relation ship, since there is 2 links to ServiceAreaCode, if my mapping is wrong, please correct me, but still I need the same logic.

i don't know exactly ... but you can try ;)

I think per default hibernate only fetchs one association eagerly ... if you want more, you need to set "hibernate.max_fetch_depth" to a value greater than 1 ...
If you set it to 2, then 2 associations will be included in the outer-join ...

But if that will work in your case, i don't now, sorry ...


gtx
curio

"hibernate.max_fetch_depth" is good if you have a tree relation, I mean if you have table->table->table...

What I want is

TableA has 2 references in tableB, but not in a collection, each is an object by itself.