File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes How to get a single database query? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "How to get a single database query?" Watch "How to get a single database query?" New topic

How to get a single database query?

Adam Kreiss
Ranch Hand

Joined: Sep 12, 2005
Posts: 35
Hi everyone,

I'm trying to set up the mappings between a number of tables. I'd like to be able to retrieve them (or large sections of them) with one call to the database instead of one call for each relationship. Is there any way to get Hibernate to do this?


- Adam
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16618

Well, that's what "eager" fetching is all about. Hibernate prefers "lazy" fetches, because complex tables with lots of relationships can potentially drag in the world and its dog and load all of it into memory at once. However, you can tweak the fetch process if you know that certain relationships will always go together.

Customer surveys are for companies who didn't pay proper attention to begin with.
I agree. Here's the link:
subject: How to get a single database query?