Hi,

I am using Hibernate 3.0 and oracle 9i DB.
I am trying to run this query below:

Query q = session.createQuery("from Users u where u.name = :i_name");
q.setString("name", i_name);

I keep getting this error:
Parameter name does not exist as a named parameter in [from Users u where u.name = :i_name].

My Users.hbm.xml has this 'name' parameter.
Is there anything wrong with my query or any setting I need to configure?

Thanks in advance.

the name of the parameter is "i_name", not "name".

The name of the variable holding the parameter value is coincidentally i_name, but that is irrelevant.

Yes, I have change it, now I have encountered another problem.
If my input value is a string, no result is return. However, if I used another field is that integer, it can works. Is there different setting between 'setInteger' & 'setString' ? Thanks!

Not sure what is the problem that you are facing now but setString expects second parameter to be a string and setInteger expects that to be integer.

I tried 'setInteger' for integer field, it can works but
when I tried 'setString' for varchar field, it can't works...very weird?

I had exactly the same problem as you. It sounds very obvious - check that the value you are matching against is the same as the value you're passing as the parameter value, for example:

cn=someuser, ou=businessunit, dc=example, dc=com

is not the same as:

cn=someuser,ou=businessunit,dc=example,dc=com

In this case (which is based on the problem I experienced) it wasn't obvious to me that the first string had spaces where as the second one didn't.

I found that when the two values were exactly the same (as you would expect for an =) setString worked fine.