use HQL in Criteria

slothink · **Joined:** Tue Apr 03, 2007 5:42 am **Posts:** 13

How can you do use hql by criteria?

for example,
DB schema is
+--------------------------+
| Glossary |
+--------------------------+
| gls_no int primary key |
| gls_name varchar(16) |
+--------------------------+

session.createCritera(Glossa.class)
.add(Restricionts.sqlRestrictions("name like 'H%'"))
.list();

this example occured error!

because sqlRestrictions use native sql, so then name is unkown field.

========
I must do criteria method.
How can you solve this problem?

dharmendra.pandey · **Posted:** Tue Apr 03, 2007 11:31 pm

Hi slothink,

try

session.createCritera(Glossa.class)
.add(Restricionts.like("name", "H%"))
.list();

Note . Name should be property of Glossa

slothink · **Joined:** Tue Apr 03, 2007 5:42 am **Posts:** 13

sorry, dharmendra.pandey.

your answer is great!

but, my fault that just easy question.
sorry about that.

because, i want to use the 'instr' function.

for example. 1. correct code.

Code:

List list = session.createQuery("from Category c where path like :searchPath and instr(c.path, '/', 1, :searchCount) = 0")
            .setParameter("searchPath", topEntry.getPath()+"%")
            .setParameter("searchCount", new Integer(searchCount))
            .list();

2. my purpose code

Code:

List list = session.createCriteria(Category.class)
where path like :searchPath and instr(c.path, '/', 1, :searchCount) = 0")
            .add(Restirctions.eq(path, topEntry.getPath(), MatchMode.END))
            .add(Restrictions.sqlRestriction("instr(path, '/', 1, "+searchCount+")) = 0")
            .list();

HQL can parse 'instr' function.
but, 'Restrictions' is not support 'instr' function. so that, i use sqlRestrictions.
but sqlRestrcitons use nativieSql, so hibernate recognized 'path' is not unknow field.

please, give me the answer, repeat.

Thank you.