Hi,

I am using Hibernate criteria for search purposes. I have an option to search the objects using its id.(primary key). This id search should be like search and not exact search. i.e If i give 1, then all objects having key start with 1 should be displayed. In my pojo this id is Long. (if i concat % to this key and add it in expression , i got error)
So how can i do this?

Thank you,
Regards,
K.Siva

In SQL it would be, for numbers starting with 1:
select id from table t
where cast(t.id as char(10)) like '1%'

so I guess the Criteria expression would be:

.add (Restrictions.sqlRestriction( "cast((alias).ID as char(10)) like '?%', firstNum, Hibernate.LONG);

I'm cribbing from JPwH, pg. 669 here.

hi,

thanks for your coding. But i have some issues over it.

how to give alias name. Now iam hard coded as this_.id. Is it ok?
If i use that code then i got error like invalid parameter 2.

I coded like this and its working.

add(Restrictions.sqlRestriction("(this_.ID) like '"+ aVO.getId()+"%'"));

to ignorecase , use ilike

hi dinesh,

Since the id is long in the pojo class, if you do like this it will throw exception. (may be class cast)

Thanks for your reply.

hmmm.. I didn't see you mention that..the other example will work, but don't try it in production quality code, or a large table.