日期:2014-05-17 浏览次数:21262 次
select distinct pp.projectNo, pp.projectName, pp.applyNo
from PrpSprojectMain pp
where pp.projectNo in
(select distinct case
when ms.subjectType = 'C' then
(select distinct p.projectNo
from PrpSprojectMain p
where p.applyNo = ms.businessNo)
when ms.subjectType = 'R' then
(select distinct p.projectNo
from PrpSprojectMain p
where p.projectNo in
(select re.projectNo
from PrpSprojectRenew re
where re.renewNo = ms.businessNo))
when ms.subjectType = 'E' then
(select distinct p.projectNo
from PrpSprojectMain p
where p.applyNo in
(select en.applyNo
from PrpSprojectEndorMain en
where en.endorNo = ms.businessNo))
end
from MessageSubject ms
where ms.subject like '%临分编辑%')
]] Root cause of ServletException. java.lang.NullPointerException at org.hibernate.hql.ast.tree.CaseNode.getDataType(CaseNode.java:17) at org.hibernate.hql.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:143) at org.hibernate.hql.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:712) at org.hibernate.hql.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:536) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:645) Truncated. see log file for complete stacktrace >