问题描述

hql 根据id字符串 查找对象对象

hql = FROM Member T where 1=1 AND T.usid in ( SELECT REGEXP_SUBSTR('424，640,790', '[^,]+', 1, LEVEL, 'i') AS STR FROM DUAL CONNECT BY LEVEL <= LENGTH('424,640,790') - LENGTH(REGEXP_REPLACE('424,640,790', ',', '')) + 1)；

List results = this.getHibernateTemplate().find(hql);

报错：
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: BY near line 1, column 119

在线等，非常感激

解决方案

HQL不支持CONNECT BY，用SQL直接写吧。