I want to bind a value to a parameter. But I just can't get it to work :

This code SUCCEEDS i.e I get 1 record out from the database :

hql = session.createQuery("SELECT f FROM com f WHERE f.id = '4028fb7a'" );
list = session.find(hql.getQueryString());

This code DOESN'T SUCCEED i.e I get 0 records from the database :

String key = "4028fb7a";
hql = session.createQuery("SELECT f FROM com f WHERE f.id = ':key'" );
hql.setParameter("key", key);
list = session.find(hql.getQueryString());

Could some please help me out why it doesn't work ? And more importantly, how to make it work ?

Regards

Dont put ' around the :key parameter

Sorry, but the quotes are not part of the query. I have removed them.
So the code look like :

String key = "4028fb7a";
hql = session.createQuery("SELECT f FROM com f WHERE f.id = :key" );
hql.setParameter("key", key);
list = session.find(hql.getQueryString());

But I get the following exception when running this code :

net.sf.hibernate.util.JDBCExceptionReporter - JZ0SA: Prepared Statement: Input parameter not set, index: 0.

net.sf.hibernate.util.JDBCExceptionReporter - Could not execute query

java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 0.

Ideas ?

The solution is as follows :

Instead of having :

String key = "4028fb7a";
hql = session.createQuery("SELECT f FROM com f WHERE f.id = :key" );
hql.setParameter("key", key);
list = session.find(hql.getQueryString());

it should be like this ( only last line of code changed )

String key = "4028fb7a";
hql = session.createQuery("SELECT f FROM com f WHERE f.id = :key" );
hql.setParameter("key", key);
list = hql.list();

The next question is just for curiousity, what is the difference between

1.list = session.find(hql.getQueryString()); // Returns nothing
2.list = hql.list(); // Returns what I want ( 1 record )

Oh my, I did not see this. session.find(hql.getQueryString()); is absolutely useless, do not do this. Just stick to the examples and use the query class like it is intended.