We are using hibernate 3.0.5.

I have the following property defined in my hibernate configuration file:
<property name="hibernate.query.substitutions">true 'Y', false 'N', yes 'Y', no 'N'</property>

Instances of User class are persisted using hibernate. active is an instance variable of the User class and its hibernate type is "yes_no" and its java type is java.lang.Boolean. In the database, it is stored as a CHAR(1) ('Y' or 'N'). So, the following HQL works fine:

"select user from User user where user.active=true"

Executing the above query works as expected (true is "changed" to 'Y' by hibernate). We do get the number of expected results. However, the following does not work (I get no results back):

String str = "select user from User user where user.active=:activeState";
Query query = session.createQuery(str);
query.setParameter("activeState", new Boolean(true));

Executing this query gives me no results back. We also tried the following with no luck:

String str = "select user from User user where user.active=:activeState";
Query query = session.createQuery(str);
query.setBoolean("activeState", true);

We got same behavior: no results back.

Am I missing something here or this is just not supposed to work? Thanks.

I am still having the problem desribed above... Has any one come across this problem or am I just missing something here?

Aren't query substitutions supposed to work when using query parameters?

String str = "select user from User user where user.active=:activeState";
Query query = session.createQuery(str);
query.setParameter("activeState", new Boolean(true));

No.