sum(sp.SUPP_PAY_AMOUNT) SUPP_PAY_AMOUNT,--此处报错
sum(DISTINCT(SUPP_PAY_INTEREST)) SUPP_PAY_INTEREST, --无错误
sum(DISTINCT(SUPP_PAY_FINDSOD)) SUPP_PAY_FINDSOD,--无错误
convert(bit,min(convert(int,SUPP_PAY_RESPONDENT))) SUPP_PAY_RESPONDENT,--无错误
convert(bit,min(convert(int,IN_SALARY))) SUPP_PAY_RESPONDENT,--无错误
hibernate 报错
exception javax.servlet.ServletException: java.lang.ArithmeticException: Rounding necessary
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
root cause java.lang.ArithmeticException: Rounding necessary
java.math.BigDecimal.divideAndRound(Unknown Source)
java.math.BigDecimal.setScale(Unknown Source)
org.hibernate.type.BigIntegerType.get(BigIntegerType.java:35)
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:139)
org.hibernate.loader.custom.CustomLoader.getResultColumnOrRow(CustomLoader.java:183)
org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:595)
org.hibernate.loader.Loader.doQuery(Loader.java:689)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2145)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111)
org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1655)
org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
我的查询结果是返回List < Object []> 对象。如果没有SUPP_PAY_AMOUNT 结果程序不报错。就在有数据的时候就提示类型转换错误。我这也没有绑定entity。请大家帮忙看看