Failed to convert from type [java.lang.Object[]] to type HashMap＜String, String＞的解决方法

转x33g5p2x  于2022-07-20 转载在 Java  
字(15.0k)|赞(0)|评价(0)|浏览(946)

【现象】

  1. 2022-07-10 15:27:02 [http-nio-9000-exec-2] ERROR c.g.e.handler.GlobalExceptionHandler - org.springframework.core.convert.ConversionFailedException: Failed to convert from type [java.lang.Object[]] to type [@org.springframework.data.jpa.repository.Query java.util.HashMap<java.lang.String, java.lang.String>] for value '{实验中学校区, 912}'; nested exception is org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [java.lang.String] to type [@org.springframework.data.jpa.repository.Query java.util.HashMap<java.lang.String, java.lang.String>]
  2. 	at org.springframework.core.convert.support.ConversionUtils.invokeConverter(ConversionUtils.java:47)
  3. 	at org.springframework.core.convert.support.GenericConversionService.convert(GenericConversionService.java:191)
  4. 	at org.springframework.core.convert.support.CollectionToCollectionConverter.convert(CollectionToCollectionConverter.java:89)
  5. 	at org.springframework.core.convert.support.ConversionUtils.invokeConverter(ConversionUtils.java:41)
  6. 	at org.springframework.core.convert.support.GenericConversionService.convert(GenericConversionService.java:191)
  7. 	at org.springframework.core.convert.support.GenericConversionService.convert(GenericConversionService.java:212)
  8. 	at org.springframework.data.repository.core.support.QueryExecutionResultHandler.postProcessInvocationResult(QueryExecutionResultHandler.java:166)
  9. 	at org.springframework.data.repository.core.support.QueryExecutionResultHandler.postProcessInvocationResult(QueryExecutionResultHandler.java:77)
  10. 	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:605)
  11. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  12. 	at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80)
  13. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  14. 	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
  15. 	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  16. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  17. 	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  18. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  19. 	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
  20. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  21. 	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
  22. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  23. 	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  24. 	at com.sun.proxy.$Proxy207.getSchoolDeviceOrder(Unknown Source)
  25. 	at com.greeble.modules.app.service.impl.AppTableServiceImpl.getSchoolDeviceOrder(AppTableServiceImpl.java:35)
  26. 	at com.greeble.modules.app.rest.AppTableController.getSchoolDeviceOrder(AppTableController.java:39)
  27. 	at com.greeble.modules.app.rest.AppTableController$$FastClassBySpringCGLIB$$8a6cc644.invoke(<generated>)
  28. 	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  29. 	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
  30. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  31. 	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  32. 	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  33. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  34. 	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  35. 	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
  36. 	at com.greeble.aspect.LogAspect.logAround(LogAspect.java:68)
  37. 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  38. 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  39. 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  40. 	at java.lang.reflect.Method.invoke(Method.java:498)
  41. 	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
  42. 	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
  43. 	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  44. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  45. 	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  46. 	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
  47. 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  48. 	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  49. 	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
  50. 	at com.greeble.modules.app.rest.AppTableController$$EnhancerBySpringCGLIB$$5fdbe89a.getSchoolDeviceOrder(<generated>)
  51. 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  52. 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  53. 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  54. 	at java.lang.reflect.Method.invoke(Method.java:498)
  55. 	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  56. 	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  57. 	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  58. 	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
  59. 	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
  60. 	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  61. 	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  62. 	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  63. 	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  64. 	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  65. 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:626)
  66. 	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  67. 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
  68. 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  69. 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  70. 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  71. 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  72. 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  73. 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
  74. 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  75. 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  76. 	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
  77. 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  78. 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  79. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
  80. 	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
  81. 	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
  82. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  83. 	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)
  84. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  85. 	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  86. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  87. 	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  88. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  89. 	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)
  90. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  91. 	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  92. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  93. 	at com.greeble.modules.security.security.TokenFilter.doFilter(TokenFilter.java:90)
  94. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  95. 	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
  96. 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  97. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  98. 	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  99. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  100. 	at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92)
  101. 	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77)
  102. 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  103. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  104. 	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  105. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  106. 	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  107. 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  108. 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  109. 	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
  110. 	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
  111. 	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
  112. 	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
  113. 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  114. 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  115. 	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  116. 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  117. 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  118. 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  119. 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  120. 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  121. 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  122. 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
  123. 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  124. 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  125. 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  126. 	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
  127. 	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  128. 	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  129. 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
  130. 	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  131. 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  132. 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  133. 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  134. 	at java.lang.Thread.run(Thread.java:748)
  135. Caused by: org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [java.lang.String] to type [@org.springframework.data.jpa.repository.Query java.util.HashMap<java.lang.String, java.lang.String>]
  136. 	at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:321)
  137. 	at org.springframework.core.convert.support.GenericConversionService.convert(GenericConversionService.java:194)
  138. 	at org.springframework.core.convert.support.ArrayToObjectConverter.convert(ArrayToObjectConverter.java:68)
  139. 	at org.springframework.core.convert.support.ConversionUtils.invokeConverter(ConversionUtils.java:41)
  140. 	... 132 more

【解决方法】

  1. @Query(value="SELECT a.name AS 'schoolName',a.count AS 'Sum' FROM school a WHERE a.type=1 ORDER BY a.count DESC",nativeQuery = true)
  2.     List<HashMap<String,String>> getSchoolDeviceOrder();

修改为：

  1. @Query(value="SELECT a.name AS 'schoolName',a.count AS 'Sum' FROM school a WHERE a.type=1 ORDER BY a.count DESC",nativeQuery = true)
  2.     List<Map<String,String>> getSchoolDeviceOrder();

版权说明 : 本文为转载文章, 版权归原作者所有 版权申明

原文链接 : https://onefire.blog.csdn.net/article/details/125785730

内容来源于网络，如有侵权，请联系作者删除！

Java前端servlet

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com