I have a table that looks roughly like:

USERS
number(20) ID
varchar2(1024) EMAIL
...

ID in this case is the primary key, but EMAIL is also a unique key. As it turns out, I need to load a user by email (as a user enters their email into a form), but I don't want to use email as the primary key (as a user might change it).

Is there an efficient way to do this in Hibernate?

Right now, I'm using iterate. In particular,

String email = strutsFoo.getEmail();
Iterator users = session.iterate("from User user where user.email = ?", email, Hibernate.STRING);

My understanding, and looking at my DB logs, show that the iterate() call makes a call to the DB _EVERY_ time it is used to get the primary key for the User, and then looks at the cache to load the user data. I'd like to remove that call to the database if possible, and I'd like to do it using the Hibernate cache vs making my own. However, I haven't found something that looks like:

session.load(User, email, "User.email");

that will look in a Hibernate cache based on the unique key and then query the database with the trivial SELECT statement to get the data.

Thanks,
speed

For a start you should certainly use Session.find() rather than iterate().

And in Hibernate 2.1, enable the query cache and use

So, I'm thinking I'm not enabling the query cache, as what you suggested is generating a

java.lang.NoSuchMethodError: net.sf.hibernate.Query.setCacheable(Z)Lnet/sf/hibernate/Query

exception.

Is there a doc somewhere you can point me to? Or the two lines of code I need? I saw the JCS thing, but that looked to be a bit more advanced than what I want to do, which is simply cache a query. :)

Thanks!
speed

Actually, nevermind... I rebuild the hibernate2.jar file from the 2.1b6 source rather than use the hibernate2.jar file that came in the 2.1b6 distribution, and all is well now. JBuilder was whining that the src was out of sync with the lib, and now I see why. Don't think it was just me as I was pretty sure about the file I was using... might want to confirm that the hibernate2.jar is the right one for b6.

Cheers,
speed

Hi,

Is there any way to do the following query using criteria queries, ie, returning an unique result?

session.createQuery("from User user where user.email = :email")
.setString("email", email)
.setCacheable(true)
.uniqueResult();

Thanks,
Joao Rangel

Criteria queries do not currently support result set caching.