Hibernate Community • View topic - createQuery like statement

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

createQuery like statement

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

AlyssaK

Post subject: createQuery like statement

Posted: Fri Jul 03, 2009 1:51 am

Beginner

Joined: Wed May 10, 2006 9:43 pm
Posts: 30
Location: Australia

Hi everyone,

I would like to extend the below query to check if product.id is like productSearchString. I have added an AND although an error exists. Haven't been able to find the syntax to support this, is it possible?

Query query = session.createQuery(
"from Product product where product.nameOfProductOrService like '%" + searchString + "%'");

Please post a response if you can help.

Thanks, Alyssa.

Top

pavol.zibrita

Post subject: Re: createQuery like statement

Posted: Fri Jul 03, 2009 3:21 am

Regular

Joined: Sun Sep 30, 2007 7:51 pm
Posts: 93

Try this:

Code:

Query query = session.createQuery(
"from Product product where product.nameOfProductOrService like :str").setString("str", "%" + searchString + "%");

It is not a good idea to construct SQL with parameters using concatenate.
Always try to use some of the Query.setParameter methods to set query parameters.

https://www.hibernate.org/hib_docs/v3/api/

You can also try to use the criterias. http://docs.jboss.org/hibernate/stable/core/reference/en/html/querycriteria.html

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum