Hi!

This is my first post and I need some assistance. I could not find an answer searching or reading the documentation. (I am still "new" to hibernate, so please bear with me.)

I am using criteria to return limited results. I have no problems with criteria using fields that are varchar2, integer, or an instance of another class. My problem lies with trying to use criteria with a boolean field.

In my hbm.xml file, I have the field declared as such:
<property name="accredTeam" type="boolean" not-null="true">

In java, I get/set the field of:
private boolean accredTeam;

I have no problems, getting or setting this field. I just cannot create criteria with it.

This is what I last tried:
criteria.add(Restrictions.eq("accredTeam", new Boolean(true)));

Hibernate version: 3.0
Name and version of the database you are using: Oracle 9i

I would appreciate any help.
Thanks,
Lori

try using Object, not primitive type:

<property name="accredTeam" type="java.lang.Boolean" not-null="true">

any exception being thrown or what is the behaviour?

Thanks for the idea, but it did not work. Any other ideas?

I am not getting an error. I am just not getting the expected results, since the criteria listed above is returning all the records, not just the ones with "accredTeam" = true.

Hi,
could you please post the create-statement you have used to create your table.
did you use a numerical field for "accredTeam"?

simon

When I export the hibernate schema, the field is a number. In the code it is referenced as a boolean. Here is the create for the relevant table:

create table jam.cars_roles (
id number(19,0) not null,
usr_id number(19,0) not null,
name varchar2(255) not null,
appliesTo varchar2(255) not null,
changed date not null,
accredTeam number(1,0) not null,
primary key (id)
);

This is my revised hibernate mapping property:
<property name="accredTeam" type="java.lang.Boolean" not-null="true">