Hi,
I am using
Hibernate version:Hibernate 3.2.0.CR1
Name and version of the database you are using:Oracle 10g


I want to ask that does Query By Example (using hibernate criteria api)
includes the primary key field as criteria?.

I tried running a peice of code which has primary key set on the example instance and execution proves that it does not include the primary key as criteria.

e.g. (i know its bad design but sometimes you do need to live with legacy databases) If the primary key of my table is a String (lets say user Name)
and i am searching for a user with his/her partial name then should not QBE include the primary key in searching criteria? I think that there should be a property enablinhg this to happen.

Regards,
Shoaib Akhtar

Query by partial primary key? That's a pretty weird situation. It might happen, but don't hold your breath.

You can map the primary key a second time, as a <property name="???" formula="primaryKeyColumn" insert="false" update="false"/> and use that for your searching.

Hi,
Thanks for u r answer. So its certain now that hibernate criteria api does not support this. I think that there is no harm in this case to treat the primary key as ordinary property. The thing u talked about is more of a workaround stuff. Anyways thanks for u r help atleast workaround is better than having nothing.
Long Live Hibernate ( a great framework). cheers,

Regards,
Shoaib Akhtar

There's a second option that I've just thought of: add an sqlRestriction:

Heh oops, sqlRestriction doesn't take named parameters, replace ":partialId" with "?"