Hello,

I use Hibernate and EHCache.

Imagine I have the following entities : Team, Player and a many-to-many relationship stored in Team_x_Player

I would like to load in Cache everything at startup.
I can do a
From Team
From Player
From Team_x_Player

if I put lazy="false" into my relationship, I will have as many jdbc requests as I've got team or players ;o(
And if I put lazy to true, then when I do myteam.getPlayers(), it still does a jdbc request although all data should be in cache...

any idea ??

use "fetch join" clause in your HQL.

first, thank you very much !

I don't want to make you loose your time..
but can you explain more ?
If I do at startup the correct HQL request, all will be in cache ?

how do I have to do for this kind of relationships (A is an entity, AxA stores the parent/child relationship for A, and A_info is a one-to-many relationship for A). Is there a way to load this at once ?
Where can I have more help on HQL syntax and examples ?

A
=====
id
name

AxA
=======
parent_A_id
child_A_id
type

A_info
=======
A_id
param1
param2

I've spent the whole day trying to load all my objects at startup..

it works if I load them with lazy=false BUT
it loads them one by one... so it takes 2 minutes for my 10,000 objects ;o(

it should last at maximum 10 seconds for this if I would do it in one time
(select id, name from A, select parent_A_id, child_A_id from B, select A_id, value from C) .. and them association..

if anyone has a solution....

I was said to use fetch join

but with no success ;o(

it does the correct request, but after, when I load an object, it does not use the cache at all..

thank you

which release are you using? fetch join is done for this!
show hql you've written