hibernate sum求和（hql和sql）

今天使用hibernate计算某列的和出现错误ERROR:

ERROR: com.pbh.response.exception.exceptionhandler.ControllerAdviceHandler -  exception 
java.lang.NullPointerException
at org.hibernate.dialect.function.StandardAnsiSqlAggregationFunctions$SumFunction.determineJdbcTypeCode(StandardAnsiSqlAggregationFunctions.java:213)
at org.hibernate.dialect.function.StandardAnsiSqlAggregationFunctions$SumFunction.getReturnType(StandardAnsiSqlAggregationFunctions.java:171)
at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.findFunctionReturnType(SessionFactoryHelper.java:432)
at org.hibernate.hql.internal.ast.tree.AggregateNode.getDataType(AggregateNode.java:85)
at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:172)
at org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:937)
at org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:705)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:665)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1836)
at com.pbh.dao.impl.admin.OrderChargesDetailDaoImpl.getSum(OrderChargesDetailDaoImpl.java:26)
at com.pbh.service.impl.admin.CarOrderServiceImpl.getInterest(CarOrderServiceImpl.java:1214)
at com.pbh.service.impl.admin.CarOrderServiceImpl$$FastClassBySpringCGLIB$$9b6e97a3.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
at com.pbh.service.impl.admin.CarOrderServiceImpl$$EnhancerBySpringCGLIB$$b767b4b4.getInterest(<generated>)
at com.pbh.controller.admin.AdminPaymentInfoController.viewCarOrder(AdminPaymentInfoController.java:203)

由于对hibernate不熟查了半天资料才知道是什么原因

package com.pbh.dao.impl.admin;


import java.io.Serializable;
import java.math.BigDecimal;


import org.hibernate.Query;
import org.springframework.stereotype.Repository;


import com.pbh.dao.admin.IOrderChargesDetailDao;
import com.pbh.dao.impl.BaseDaoImpl;
import com.pbh.model.admin.OrderChargesDetail;


/**
 * 
 * <p>Title:OrderChargesDetailDaoImpl </p>
 * <p>Description: 利息和逾期</p>
 * @author PanBaihui
 * @time 2017年8月25日 下午3:09:55
 */
@Repository("OrderChargesDetailDao")
public class OrderChargesDetailDaoImpl extends BaseDaoImpl<OrderChargesDetail, Serializable> implements IOrderChargesDetailDao {


@Override
public BigDecimal getSum(String hql) {
hql = "select sum(new_interest) from OrderChargesDetail";
Query query = super.getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(hql);
return new BigDecimal(query.uniqueResult().toString());
}


}

将上述的创建query更改为创建sqlQuery就可以了

Query query = super.getHibernateTemplate().getSessionFactory().getCurrentSession().createSQLQuery(sql);

资料：http://www.myexception.cn/java-web/1470530.html