Hi!

I have 4 websites that has it's own instance of hibernate but they all points to the same database. What should be my concerns here. Is there a better approach?

// Mathias

you should program in a way as "stateless" as possible, never storing table lengths or children, constantly re-retrieving as much as possible on every request.
Hibernate guarantees you that whatever comes from query.list() is the most current.