Hi guys I'm new to Hibernate and I will appreciate some help with some awkward behavior I just can't fix

I am using Oracle 9i and working with a table named users with a pk
char(16)
the thing is that when I request a List with one user with the next statements:

String id="Administrator";
List objects=session.find("from User as user where user.userId=?",id,Hibernate.STRING);

I get nothing, however if I change it to:

String id=" \'Administrator\' "; //look the \'
List objects=session.find("from User as user where user.userId="+id);

I do get the user but the most interesting thing is that if I change the id to meet the size of the table field like this;

String id="Administrator "; // look the blanks
List objects=session.find("from User as user where user.userId=?",id,Hibernate.STRING);

I do get the user. I am sure there is something I am doing wrong
and I can adjust my code to work like this but it seems awkward to me

some ideas?

change from CHAR to VARCHAR2.

thanks gavin I changed it but didn't work. Maybe it has something to do with Oracle?

was 'Administrator' fat-fingered into oracle?

if you mean done with Administrator role then yes it was

My mistake gavin you were right, I changed the first time to VARCHAR insted of VARCHAR2, now I fixed that and is working

thanks

I have the same problem. Environment is:
Oracle 9.2
Hibernate 2.1.1

In my case the column is CHAR(30).

The column in the database contains, say 'fred', padded out to 30 characters with spaces.

This works:
String name = "fred";
queues = session.find("select queue " +
" from Queue as queue " +
"where queue.name = '" + name + "'");

This does not:
String name = "fred";
queues = session.find("select queue " +
" from Queue as queue " +
"where queue.name = ?",
name, Hibernate.STRING);

If I go ahead and pad name out with spaces, then the parameter query will work.

In my case, changing the column definition is not an option. In that case, is there any way to have the parameter query work with an un-padded name ?