Hi all,

I have a quite simple question about the namedQueries in Hibernate. Lets say we use an Oracle Database, is there a performance gain if you use a name query strategy in your daos, instead of creating new (but same) query each time you hit the database and adding binded parameters to it?

I didn't find any straight answer around. The issue is that Hibernate seems to keep a SQL cache anyhow, while Oracle will keep a sql plan cache for all received sql request. This said, what is the performance gain of using named queries if there is one?

thanks and regards,

Etienne

Hope the discussion in below URL gives some idea.

http://forums.sun.com/thread.jspa?threadID=5436893