Forums Register Login

Problem in Query By Example (Hibernate)

+Pie Number of slices to send: Send
Hi
I am using hibernate3 in my application. When executing the below code
Product exampleProduct=new Product();
exampleProduct.setPrice(22);
Example example=Example.create(exampleProduct);
Criteria criteria=session.createCriteria(Product.class);
criteria.add( example );
List results = criteria.list();

it works fine. Lists all the objects with the price is 22. when modified the code as below

Product exampleProduct=new Product();
exampleProduct.setName("Product 2");

Example example=Example.create(exampleProduct);
Criteria criteria=session.createCriteria(Product.class);
criteria.add( example );
List results = criteria.list();

returns the empty list but the database has few products with the name "Product 2". When I checked the query generated,
Hibernate: select this_.id as id0_0_, this_.name1 as name2_0_0_, this_.description as descript3_0_0_, this_.price as price0_0_, this_.supplierId as supplierId0_0_ from product2 this_ where (this_.name1=? and this_.price=?)

the where condition sets parameter value for price. I have executed this code with different properties of the product object but the generated query always adds price parameter value set and returns empty list.

Is it a bug and is it overcomed in the latest version of hibernate or do I need to set any property for proper working of this code..
+Pie Number of slices to send: Send
There are settings for not ignoring null or not ignoring zeros. Maybe it's seeing a zero and doing a query based on it?





Using the Criteria API from Hibernate: Tutorial

-Cameron McKenzie
+Pie Number of slices to send: Send
Can you post your hbm and the Hibernate POJO for Product.

If you have defined the "price" field in "Product" as "int", you should change it so that it is an "Integer" and then test the criteria query.
+Pie Number of slices to send: Send
Thanks Cameron and Rahul. Both the solutions have worked out for the query.
This guy is skipping without a rope. At least, that's what this tiny ad said:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 3787 times.
Similar Threads
Clarification needed in usuage of Example criteria.
Hibernate Search using Criteria with OR condition.
Searching using multiple field
Problem with Hibernate Criteria, Query by Example and "nullable=false"
How to get the all results using HQL
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 02:58:54.