这是错误:
hibernate.QueryException: unexpected char: '{' [select {vw.*} from vw_ele_ask vw where vw.stuId='X1203001' union select {vw.*} from vw_ele_ask vw where vw.couId not in(select vw.couId from vw_ele_ask vw where vw.stuId='X1203001')group by vw.couId;]
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:204)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:839)这是查询语句:
hql="select {vw.*} from vw_ele_ask vw " +
"where vw.stuId='X1203001' union" +
" select {vw.*} from vw_ele_ask vw" +
" where vw.couId not in(select vw.couId from vw_ele_ask vw " +
"where vw.stuId='X1203001')group by vw.couId";
hibernate.QueryException: unexpected char: '{' [select {vw.*} from vw_ele_ask vw where vw.stuId='X1203001' union select {vw.*} from vw_ele_ask vw where vw.couId not in(select vw.couId from vw_ele_ask vw where vw.stuId='X1203001')group by vw.couId;]
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:204)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:839)这是查询语句:
hql="select {vw.*} from vw_ele_ask vw " +
"where vw.stuId='X1203001' union" +
" select {vw.*} from vw_ele_ask vw" +
" where vw.couId not in(select vw.couId from vw_ele_ask vw " +
"where vw.stuId='X1203001')group by vw.couId";
解决方案 »
- qingwen
- ant与junit结合时,想通过扩充ANT,通过读一个外部XML文件把文件中的值读到ANT已有的任务中
- hibernate插入数据
- webservice中,怎么样传递一个文件给服务器端
- 用过hsql的朋友请进,如何自己写一个java类来达到 自动启动hsql数据库啊,我们平时用的是run.bat
- 有谁改造过shark开源工作流引擎吗?30万行代码,如何着手呢.
- sql server 的JDBC驱动哪里下载啊??
- 2000下java怎么设置path和classpath?
- 感兴趣的都可以来讨论一下,究竟是技术重要还是一个好的idea重要?
- WebLogic7配置Oracle8i数据库连接池问题
- spring定时器问题
- 在用s2sh+mysql进行分页的时候出错了
因为要用到union,而hql又不支持只能用本地sql了,可是老报错
"where vw.stuId='X1203001' union" +
" select {vw.*} from vw_ele_ask vw" +
" where vw.couId not in(select vw.couId from vw_ele_ask vw " +
"where vw.stuId='X1203001')group by vw.couId";你这个语句是一坨屎么?