Hi,

Is there any possibility to map() instead of list?
What I need to have in the resulting Map is the Object with its primary key and the object itself for tables having primary key, not a composite primary key.

I used to do it in JDBC easily but when I started using Hibernate I always have to iterate the list and put the object with its primary key.

Thanks for any reply.

-N

So, you want a Map of object by their primary key eh?

You are probably using the map to find objects by their id, right? You should think about re-writing your code so you don't use Map to look up objects by their ids. This is redundant because Session.get() does this, and so should your DAOs. Map just isn't the right way to do this. I've had to refactor a lot of code that does things this way... it's really not a good idea.

Well, we cache the objects retrieved from the DB. So the code consults the cache first and if there is a miss then it quieries the db or executes session.get().
The thing is that we dont use hibernate's second level cache to cache objects. We have our own caching technique (implemented for local simple caches and in distributed caching environment, i.e. tangosol). Thats why I need to map objects since I don't have too many rows in DB, I thought it would be wise to fetch them all at once.

I think you should use the built-in cache of hibernate.
If you are going to cache the objects yourself, you'll have to remember to attach the objects to a new session, if the old one was closed. Also, updates from the DB have to be managed (cache timeout).
Hibernate already does that for you for you.