Springboot踩坑日记——spring data jap 使用@Query接收Map＜String,Integer＞结果集时取值时报错

刘彦青-Yannis

已于 2023-12-06 10:53:14 修改

阅读量673

点赞数

分类专栏： springboot爬坑日记 spring-boot踩坑日记文章标签： spring spring boot java

于 2022-11-03 16:53:08 首次发布

本文链接：https://blog.csdn.net/ityqing/article/details/127673662

版权

springboot爬坑日记同时被 2 个专栏收录

17 篇文章 0 订阅

订阅专栏

spring-boot踩坑日记

16 篇文章 0 订阅

订阅专栏

报错信息

2022-11-03 16:50:21.437 [http-nio-8081-exec-1 4d0aef19-62c9-42e4-a3f7-bece3d90090b] DEBUG org.springframework.orm.jpa.JpaTransactionManager - Committing JPA transaction on EntityManager [SessionImpl(1075052196<open>)]
2022-11-03 16:50:21.453 [http-nio-8081-exec-1 4d0aef19-62c9-42e4-a3f7-bece3d90090b] DEBUG org.springframework.orm.jpa.JpaTransactionManager - Not closing pre-bound JPA EntityManager after transaction
2022-11-03 16:50:21.455 [http-nio-8081-exec-1 4d0aef19-62c9-42e4-a3f7-bece3d90090b] DEBUG o.s.w.s.m.m.a.ExceptionHandlerExceptionResolver - Using @ExceptionHandler com.accor.dfc.adapter.interceptor.ExceptionControllerAdvice#exceptionHandler(Exception)
2022-11-03 16:50:21.458 [http-nio-8081-exec-1 4d0aef19-62c9-42e4-a3f7-bece3d90090b] ERROR c.a.d.a.interceptor.ExceptionControllerAdvice - class java.math.BigInteger cannot be cast to class java.lang.Integer (java.math.BigInteger and java.lang.Integer are in module java.base of loader 'bootstrap')
java.lang.ClassCastException: class java.math.BigInteger cannot be cast to class java.lang.Integer (java.math.BigInteger and java.lang.Integer are in module java.base of loader 'bootstrap')
	at com.accor.dfc.adapter.application.task.service.impl.AplusExpireNotifyServiceImpl.statistical(AplusExpireNotifyServiceImpl.java:281)
	at com.accor.dfc.adapter.application.task.service.impl.AplusExpireNotifyServiceImpl$$FastClassBySpringCGLIB$$e03be8bf.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
	at com.accor.dfc.adapter.application.task.service.impl.AplusExpireNotifyServiceImpl$$EnhancerBySpringCGLIB$$51dbba9c.statistical(<generated>)
	at com.accor.dfc.adapter.application.task.TaskController.lambda$statistical$3(TaskController.java:88)
	at com.accor.dfc.logging.AbstractTemplate.invoke(AbstractTemplate.java:23)
	at com.accor.dfc.adapter.application.task.TaskController.statistical(TaskController.java:85)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at com.accor.dfc.adapter.interceptor.LoggingFilter.doFilterInternal(LoggingFilter.java:85)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)
2022-11-03 16:50:21.510 [http-nio-8081-exec-1 4d0aef19-62c9-42e4-a3f7-bece3d90090b] DEBUG o.s.w.s.m.m.a.RequestResponseBodyMethodProcessor - Using 'application/json', given [*/*] and supported [application/json, application/*+json, application/json, application/*+json]
2022-11-03 16:50:21.520 [http-nio-8081-exec-1 4d0aef19-62c9-42e4-a3f7-bece3d90090b] DEBUG o.s.w.s.m.m.a.RequestResponseBodyMethodProcessor - Writing [ExceptionControllerAdvice.ErrorResult(errorCode=SystemError, errorMessage=class java.math.BigInteger (truncated)...]
2022-11-03 16:50:21.539 [http-nio-8081-exec-1 4d0aef19-62c9-42e4-a3f7-bece3d90090b] DEBUG o.s.w.s.m.m.a.ExceptionHandlerExceptionResolver - Resolved [java.lang.ClassCastException: class java.math.BigInteger cannot be cast to class java.lang.Integer (java.math.BigInteger and java.lang.Integer are in module java.base of loader 'bootstrap')]
2022-11-03 16:50:21.540 [http-nio-8081-exec-1 4d0aef19-62c9-42e4-a3f7-bece3d90090b] DEBUG o.s.o.j.support.OpenEntityManagerInViewInterceptor - Closing JPA EntityManager in OpenEntityManagerInViewInterceptor
2022-11-03 16:50:21.549 [http-nio-8081-exec-1 4d0aef19-62c9-42e4-a3f7-bece3d90090b] DEBUG org.springframework.web.servlet.DispatcherServlet - Completed 500 INTERNAL_SERVER_ERROR
2022-11-03 16:50:23.428 [ConfigCacheSchedule ] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing SQL query [select name, value from config where released = '1';]
2022-11-03 16:50:23.428 [ConfigCacheSchedule ] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource

核心log

java.lang.ClassCastException: class java.math.BigInteger cannot be cast to class java.lang.Integer (java.math.BigInteger and java.lang.Integer are in module java.base of loader ‘bootstrap’)

错误代码

 @Query(value = "SELECT * FROM\n" +
            "(\n" +
            "\tSELECT COUNT(`status`) AS  ok_num FROM  task_aplus_expire WHERE task_id = ?1 AND `status` = 'OK'\n" +
            ")a INNER JOIN\n" +
            "(SELECT COUNT(`status`) AS  ko_num  FROM  task_aplus_expire WHERE task_id = ?1 AND `status` = 'KO') b INNER JOIN\n" +
            "( SELECT COUNT(`status`) AS  no_operation_num  FROM  task_aplus_expire WHERE task_id = ?1 AND `status` = 'NO_OPERATION') c ",nativeQuery = true)
    Map<String,Integer> statistical(Long taskId);

 		 Map<String, Integer> statistical = taskVipAExpireRepository.statistical(taskId);

        System.out.println(statistical.get("ko_num"));
        //OkNum 是Integer类型数据
 		result.setOkNum(statistical.get("ko_num"));

分析

根据日志信息，问题出在以下这一行：

java.lang.ClassCastException: class java.math.BigInteger cannot be cast to class java.lang.Integer

这表明在**代码中尝试将 BigInteger 类型的对象强制转换为 Integer 类型时发生了 ClassCastException。**在你的堆栈跟踪中，这个问题似乎出现在 AplusExpireNotifyServiceImpl 类的 statistical 方法的第 281 行：

at com.accor.dfc.adapter.application.task.service.impl.AplusExpireNotifyServiceImpl.statistical(AplusExpireNotifyServiceImpl.java:281)

解决这个问题的关键是检查你的代码，尤其是 AplusExpireNotifyServiceImpl 类的 statistical 方法的实现。在这个方法中，可能存在将 BigInteger 类型的对象转换为 Integer 类型的地方，而这是不允许的，因为它们是不同的数据类型。

可能的解决方法包括：

避免强制类型转换： 确保你在使用之前检查对象的实际类型，并使用适当的方法来处理 BigInteger 类型的对象。
使用适当的数据类型： 如果你需要处理大整数，确保在整个代码中都使用 BigInteger 而不是 Integer。
检查数据库字段类型： 如果数据是从数据库中检索的，确保数据库字段的类型与你的实体类中的属性类型相匹配。
检查配置文件： 如果有任何配置文件，确保其中的配置是正确的，不会导致类型不匹配的问题。

在解决问题之前，建议详细检查 AplusExpireNotifyServiceImpl 类的 statistical 方法，特别是在第 281 行周围的代码。找到可能导致类型不匹配的地方，并相应地修改代码以正确处理数据类型。

原因

    Map<String,Integer> statistical(Long taskId); 返回的真是类型是BigInteger 而不是Integer

解决

Map<String,Integer> statistical(Long taskId); 改为 Map<String,BigInteger> statistical(Long taskId);
result.setOkNum(statistical.get(“ko_num”).intValue());

刘彦青-Yannis

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
Springboot踩坑日记——spring data jap 使用@Query接收Map＜String,Integer＞结果集时取值时报错

【代码】Springboot踩坑日记——spring data jap 使用@Query接收Map结果集时取值时报错。
复制链接

扫一扫