Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Node.js in Action
this week in the
EJB and other Java EE Technologies
Joined: May 15, 2008
Oct 19, 2008 20:26:00
I want to create a named query, which will return all the names which starts with "ABC", similar to the query below:
select * from customer where name like 'ABC%'
or, if i the
'ABC' is stored in a variable, than above query becomes:
select * from customer where name like name+'%'
I write a named query like this:
select c from customer c where name like :name
its working, but its not waht i want, when i changed the above named query to below:
select c from customer c where name like :name%
Above query gives exception. How to do such thing?
Joined: Nov 24, 2005
Oct 19, 2008 21:56:00
You don't want to append the '%' directly to the name variable, when calling setParameter ?
All roads lead to JavaRanch
I agree. Here's the link:
subject: LIKE operator
How to do optional wildcard select in JPA named queries?
urgent help reqd
Conditions for dependent entites on fetching?
entity loading blues
listing hibernate named queries from java
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014