hibernate createQuery 错空指针

[yjyq61]

查询的是主表中的字段和子表中的字段




语句

Query query = session.createQuery("select bb.isBorrowing,bb.borrowDate,bb.backDate,bi.count(*) from BookBorrowInfo bb ,BookInfo bi where userID=? and bb.bookID=bi.Oid");
			query.setParameter(0, oid);

页面上的报错
java.lang.NullPointerException
org.hibernate.hql.antlr.HqlBaseParser.identPrimary(HqlBaseParser.java:4341)
org.hibernate.hql.antlr.HqlBaseParser.primaryExpression(HqlBaseParser.java:948)
org.hibernate.hql.antlr.HqlBaseParser.atom(HqlBaseParser.java:3750)
org.hibernate.hql.antlr.HqlBaseParser.unaryExpression(HqlBaseParser.java:3513)
org.hibernate.hql.antlr.HqlBaseParser.multiplyExpression(HqlBaseParser.java:3380)
org.hibernate.hql.antlr.HqlBaseParser.additiveExpression(HqlBaseParser.java:3073)
org.hibernate.hql.antlr.HqlBaseParser.concatenation(HqlBaseParser.java:632)
org.hibernate.hql.antlr.HqlBaseParser.relationalExpression(HqlBaseParser.java:2836)
org.hibernate.hql.antlr.HqlBaseParser.equalityExpression(HqlBaseParser.java:2692)
org.hibernate.hql.antlr.HqlBaseParser.negatedExpression(HqlBaseParser.java:2651)
org.hibernate.hql.antlr.HqlBaseParser.logicalAndExpression(HqlBaseParser.java:2562)
org.hibernate.hql.antlr.HqlBaseParser.logicalOrExpression(HqlBaseParser.java:2522)
org.hibernate.hql.antlr.HqlBaseParser.expression(HqlBaseParser.java:2283)
org.hibernate.hql.antlr.HqlBaseParser.aliasedExpression(HqlBaseParser.java:2470)
org.hibernate.hql.antlr.HqlBaseParser.selectedPropertiesList(HqlBaseParser.java:1593)
org.hibernate.hql.antlr.HqlBaseParser.selectClause(HqlBaseParser.java:1486)
org.hibernate.hql.antlr.HqlBaseParser.selectFrom(HqlBaseParser.java:1208)
org.hibernate.hql.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:774)
org.hibernate.hql.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:313)
org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:161)
org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:274)
org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:98)
org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1760)
com.books.dao.impl.BooksDAOImpl.queryMyBorrowing(BooksDAOImpl.java:242)
com.books.service.impl.BooksServiceImpl.queryMyBorrowing(BooksServiceImpl.java:55)
com.books.action.MyBorrowingAction.execute(MyBorrowingAction.java:23)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)

[Fly_m]

你传递的oid对象是空的吧。

[yjyq61]

oid对象有值

[敬敬11]

你的sql有问题加上group by

[yjyq61]

[Quote=引用 3 楼 hgj1024454508 的回复:]
你的sql有问题加上group by
[/Quote]
您帮我加一下 我不知道要怎么加 谢谢 小弟新手

[wudi1233]

query.setParameter(0, oid);

hibernate 恍惚中记得好像是从1开始的 你可是试试吧。 不知道对不对

[Spring89]

BooksDAOImpl.java:242
242行是什么？
query.setParameter(0, oid);
是从0开始的！
session是不是空的？
你就贴了一句代码，为空的只能是session
你好好检查下吧，看session是否为空！

[敬敬11]

比如说count sum这一类的函数就要用group by的就你的这个sql 我改改，我只负责你的语法
select bb.isBorrowing,bb.borrowDate,bb.backDate,bi.count(*) from BookBorrowInfo bb ,BookInfo bi where userID=? and bb.bookID=bi.Oid group by bb.isBorrowing,bb.borrowDate,bb.backDate
还有就是你以后写完sql之后再数据库里面执行成功之后再写到程序里面，你不验证的话，出错你要不知道什么错了