java.lang.IllegalStateException异常问题

[Lsoxi2009]

String sql="from ProductOrdersInfo p where p.id in (select min(id) from ProductOrdersInfo po where po.memberInfo.id=? and po.state=? group by po.code) ";
这条sql语句有什么问题吗
运行时报：
警告: Unhandled Exception thrown: class java.lang.IllegalStateException
2008-6-29 15:23:49 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet action threw exception
java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.AggregateNode
\-[AGGREGATE] AggregateNode: 'min'
\-[IDENT] IdentNode: 'id' {originalText=id}

[老紫竹]

'id' 没有设置数据类型，去看看你的配置文件

[Lsoxi2009]

<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="identity"></generator>
</id>

有啊，，，

[Lsoxi2009]

<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="identity"> </generator>
</id>

有啊，，，

[zhj92lxs]

min(id)这个id也用 别名.id 试试

[Lsoxi2009]

sql语句我放在查询器执行是没问题的，，，在写在DAO的方法里就出问题了

[zfg2003]

String sql="from ProductOrdersInfo p where p.id in (select min(id) from ProductOrdersInfo po where po.memberInfo.id=? and po.state=? group by po.code) ";

这样？：
String sql="from ProductOrdersInfo p where p.id in (select min(po.id) from ProductOrdersInfo po where po.memberInfo.id=? and po.state=? group by po.code) ";

[Shine_Panda]

(select min(id) from
明确注明是那个对象的id

[bobor_2008]

No data type for node: org.hibernate.hql.ast.AggregateNode
\-[AGGREGATE] AggregateNode: 'min'
\-[IDENT] IdentNode: 'id' {originalText=id}



和楼上朋友的看法一样,你加上别名试试吧.

[tang52016639]

解决了没啊？这是什么原因？
我一遇到同样的问题
from Sysuser sy where sy.userid=(select MAX(cast(s.userid as int) ) from Sysuser s)
这句在HQL Editor中能执行，但加在DAO中就报错

javax.servlet.ServletException: No data type for node: org.hibernate.hql.ast.AggregateNode
\-[AGGREGATE] AggregateNode: 'MAX'
\-[METHOD_CALL] MethodNode: '('
+-[METHOD_NAME] IdentNode: 'cast' {originalText=cast}
\-[EXPR_LIST] SqlNode: 'exprList'
+-[DOT] DotNode: 'sysuser1_.USERID' {propertyName=userid,dereferenceType=4,propertyPath=userid,path=s.userid,tableAlias=sysuser1_,className=com.stategrid.aostar.web.model.Sysuser,classAlias=s}
| +-[ALIAS_REF] IdentNode: 'sysuser1_.USERID' {alias=s, className=com.stategrid.aostar.web.model.Sysuser, tableAlias=sysuser1_}
| \-[IDENT] IdentNode: 'userid' {originalText=userid}
\-[IDENT] IdentNode: 'int' {originalText=int}

[跑跑鱼]

回 帖

[fjbadm]

我也是java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.IdentNode
\-[IDENT] IdentNode: 'userName' {originalText=userName}