Hql has several minor issues.

 

1. Unable to locate appropriate constructor on class ....

Similar to "select new uservo (U. ID, U. Name) from user u where u. ID> 100"

In this case, uservo must have a constructor that matches the (ID, name) type.

2. Like Fuzzy match:

View plaincopy to clipboardprint?

1. Public list <user> findusersbyname (string username ){
2. String hql = "select * from user u where u. name like? "
3. List <user> result = gethibernatetemplate (). excutequery (hql, "%" + username + "% ");
4. Return result;
5. }

Public list <user> findusersbyname (string username) {<br/> string hql = "select * from user u where u. name like? "<Br/> List <user> result = gethibernatetemplate (). excutequery (hql, "%" + username + "%"); <br/> return result; <br/>} 

Note that "%" is passed in as a parameter rather than directly spelled in hql during like fuzzy match.

3. nested query:

Hql supports selct * From where xx in (select * from where ...)

However, hql does not support queries such as select * from (select * from.

1. Unable to locate appropriate constructor on class ....

Similar to "select new uservo (U. ID, U. Name) from user u where u. ID> 100"

In this case, uservo must have a constructor that matches the (ID, name) type.

2. Like Fuzzy match:

View plaincopy to clipboardprint?

1. Public list <user> findusersbyname (string username ){
2. String hql = "select * from user u where u. name like? "
3. List <user> result = gethibernatetemplate (). excutequery (hql, "%" + username + "% ");
4. Return result;
5. }

Public list <user> findusersbyname (string username) {<br/> string hql = "select * from user u where u. name like? "<Br/> List <user> result = gethibernatetemplate (). excutequery (hql, "%" + username + "%"); <br/> return result; <br/>} 

Note that "%" is passed in as a parameter rather than directly spelled in hql during like fuzzy match.

3. nested query:

Hql supports selct * From where xx in (select * from where ...)

However, hql does not support queries such as select * from (select * from.