Hi,
I am having problems casting a query into a type (User). I have 2 methods, one for a known user id and one that doesn't know the user id:

1. public static User getUser (int user_id)
{
................
user = (User)session.load(test.User.class, userID);
....................
return user;
}
This works fine, but in my second method:

2.public static User getUser (String username)
{
................
user = (User)session.find("from User user where user.UserName = ?",username,Hibernate.STRING);
....................
return user;
}

This throws a class exception. How do I resolve this as I need the type of (User) returned?

many thanks in advance

We don't know, you haven't shown enough information to resolve this. Please read:

http://www.hibernate.org/160.html

Oh, I see. You are trying to cast a List to a User. Read the documentation and check uniqueResult().

works a treat. Thanks for your help ;-)