MySQLSyntaxErrorException

最新推荐文章于 2024-06-06 21:30:00 发布
最新推荐文章于 2024-06-06 21:30:00 发布
阅读量650 收藏
点赞数
分类专栏： jpa spring 文章标签： hibernate
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yanlici1249075710/article/details/78542627
版权 
2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO] Hibernate: select count(1) from (select new map(y.dictName as text1,y.dictCode as text2,y.dictValue as yan3) from Yan y where 1=1 ) a
 2017-11-15 15:12:10[org.hibernate.engine.jdbc.spi.SqlExceptionHelper]-[ERROR] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(y.dictName as text1,y.dictCode as text2,y.dictValue as yan3) from Yan y where 1' at line 1
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO] org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:242)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:417)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:131)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.sun.proxy.$Proxy111.findYanList(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.dianju.trustedSign.modules.yan.controllers.YanController.queryYanObjectPage(YanController.java:91)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.dianju.trustedSign.modules.yan.controllers.YanController$$FastClassBySpringCGLIB$$348198be.invoke(<generated>)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.dianju.trustedSign.core.modules.rbacOperation.OperationAspect.before(OperationAspect.java:56)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at java.lang.reflect.Method.invoke(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.dianju.trustedSign.modules.yan.controllers.YanController$$EnhancerBySpringCGLIB$$3c05f70f.queryYanObjectPage(<generated>)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at java.lang.reflect.Method.invoke(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:871)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:87)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at java.lang.Thread.run(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO] Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.Loader.doQuery(Loader.java:910)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.Loader.doList(Loader.java:2554)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.Loader.doList(Loader.java:2540)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.Loader.list(Loader.java:2365)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1909)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.dianju.trustedSign.core.modules.models.DaoUtilImpl.getPageResponseSql(DaoUtilImpl.java:68)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.dianju.trustedSign.modules.yan.models.YanDaoImpl.findYanList(YanDaoImpl.java:30)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at java.lang.reflect.Method.invoke(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:483)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:458)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:440)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  ... 79 more
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(y.dictName as text1,y.dictCode as text2,y.dictValue as yan3) from Yan y where 1' at line 1
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at java.lang.reflect.Constructor.newInstance(Unknown Source)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.Util.getInstance(Util.java:387)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
 2017-11-15 15:12:10[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO]  ... 111 more

错误的原因就是：这里写图片描述

正确的代码应该是：
这里写图片描述

1249075710
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
解决问题：Failed to convert from type [java.lang.Object[]] to type
Soulmate_Min
09-18 1万+
报错信息：org.springframework.core.convert.ConversionFailedException: Failed to convert from type [java.lang.Object[]] to type 出现该错误的原因是因为在当前的***Repository中，查询了其他的实体. public interface InvoiceRepository ...
JPA错误之Failed to convert from type [java.lang.Object[]] to type
qq_36657997的博客
11-27 3056
问题背景 同事遇到一个奇怪的报错“Failed to convert from type [java.lang.Object[]] to type”，这个报错，百度上也是很少的，恰恰是这样的问题，引起我了解决的欲望。   org.springframework.core.convert.ConversionFailedException: Failed to convert from typ...
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException异常的解决方案
2301_79779756的博客
05-23 956
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException 异常是 MySQL JDBC 驱动在尝试执行 SQL 语句时，因为 SQL 语句中存在语法错误而抛出的异常。当 Java 程序通过 JDBC API 与 MySQL 数据库进行交互时，如果执行的 SQL 语句不符合 MySQL 的语法规则，MySQL 服务器会返回一个语法错误，这个错误随后会被 JDBC 驱动捕获并转换为 MySQLSyntaxErrorException 异常。
JPA的Failed to convert from type [java.lang.Object[]] to type
sssimo的博客
01-25 892
JPA的Failed to convert from type [java.lang.Object[]] to type 异常： org.springframework.core.convert.ConversionFailedException: Failed to convert from type [java.lang.Object[]] to type 解决办法： 可能是当前的Repository里查询了其他的实体导致的，比如我的： TaskRepository extends JpaRepos
bitronix 连接 MySQL 出现MySQLSyntaxErrorException 的解决方法
01-19
bitronix 连接 MySQL 出现MySQLSyntaxErrorException 的解决方法 1. 开发环境 hibernate 版本：5.1.0.Final Bitronix btm 版本：2.1.3 2 异常堆栈信息 Caused by: ...
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ….. this is incompatible with sq
12-14
1、写在开头 标题之前我想说一下Linux的mysql真的实在是太坑了。太坑了。总是会出现这样那样的你想不到的问题。崩溃了。首先来罗列一下我遇到过的一些问题吧。 1、大小写敏感 2、连接数超过系统最大连接数 ...
解决mysql导入新数据库大小写问题（Table ‘zup.Domain_System’ doesn’t exist）
12-14
问题 Table ‘zup.Domain_System’ doesn’t exist ...### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'zup.Domain_System' doesn't exist ; bad SQL grammar []; nested
Mysql错误：Every derived table must have its own alias
08-14
在MySQL数据库操作中，"Every derived table must have its own alias" 是一个常见的错误提示，意味着在你的SQL查询语句中，使用了派生表（也称为子查询）但没有为它们分配唯一的别名。这个错误通常发生在试图从子...
Failed to convert from type [java.lang.String] to type [@javax.persistence.Transient java.util.Date]
jerry_wzj_的博客
08-23 3968
Failed to convert from type [java.lang.String] to type [@javax.persistence.Transient java.util.Date] for value ‘2020-08-23’ 原因：springboot可以自动识别yyyy/MM/dd格式的时间字符串并注入Date类型的属性中，但不能识别yyyy-MM-dd等格式的字符串 解决方法：在属性上标注传入的格式 @DateTimeFormat(pattern = "yyyy-MM-dd") p
Failed to convert value of type ‘java.lang.String’ to required type ‘java.util.Date’; nested except
01-07
HTTP Status 500 – Internal Server Error Type 异常报告 消息 Failed to convert value of type 'java.lang.String' to required type 'java.util.Date'; nested exception is java.lang.IllegalStateException: Cannot convert value of type 'java.lang.String' to required type 'java.util.Date': no matching editors or co
Failed to convert from type [java.lang.String] to type [java.util.Date] 报错
weixin_45854715的博客
07-02 8126
出现这个错误的原因是，后台使用了 @RestController 前段传值过来的是json字符串，让要把字符串转换成时间格式的时候后台无法将字符串解析成时间格式对象， 解决方法： 在controller中加入@InitBinder注解的配置，配合参数转工具 WebDataBinder来进行参数转换 @RestController public class DiscussionController { @Autowired DiscussionService discussionServi
Failed to convert from type [java.lang.String] to type [java.util.Date] for value ‘1‘； nested except
最新发布
杨明金的博客
06-06 498
日志中的错误主要是由于类型转换失败造成的。在这种情况下，系统试图将一个字符串 “1” 转换为 java.util.Date 类型，但失败了，提示这种转换不是直接可行的。错误信息是由 Spring 框架在处理 HTTP 请求并尝试将请求参数绑定到一个 Java 对象时生成的。在一个名为 ywNsrcjxxReqVO 的对象的 ldrq 字段上。这个字段期望的是一个 Date 类型，但实际传入的是一个不符合日期格式的字符串。
Failed to convert from type [java.lang.String] to type [java.util.Date]
热门推荐
Halo333的博客
06-17 2万+
nested exception is org.springframework.core.convert.ConversionFailedException: Failed to convert from type [java.lang.String] to type [java.util.Date] for value ‘2019-05-30 14:47:24’; nested exceptio...
解决：Failed to convert from type [java.lang.String] to type [java.sql.Date]
我现在难受的一批的博客
11-15 3206
【代码】解决：Failed to convert from type [java.lang.String] to type [java.sql.Date]
Failed to convert from type java.lang.String to type java.util.Date for value解决办法
chengp919的博客
08-17 4594
在springMVC中如果表单属性的类型是日期类型时，从页面绑定字符串数据会出错，Failed to convert property value of type [java.lang.String] to required type [java.util.Date] for property 'expert.birthdate'; nested exception is java.lang.Il...
结构体转map[string]interface{}的方法
夜空中最亮的星
04-12 9332
在go语言中结构体转map[stirng]interface{}中有几种方法,但是也有一些小小的"坑",比如说我们在存储一些信息时有各种类型的,下面来看一个结构体:// UserInfo 用户信息 type UserInfo struct { Name string `json:"name"` Age int `json:"age"` } u1 := UserInfo{Name: ...
mysqlsyntaxerrorexception: procedure hd_public_resources_signature.procedure
09-03
MySQLSyntaxErrorException是MySQL中的一个异常类，用来表示在执行SQL语句时出现的语法错误。这个异常通常会出现在存储过程的执行过程中。 "procedure hd_public_resources_signature.procedure"是一个存储过程的名称，这里出现的异常信息表明在执行这个存储过程时发生了语法错误。 可能的原因有： 1. 存储过程名称错误：检查存储过程名称是否正确拼写，并且是否与创建存储过程时使用的名称一致。 2. 存储过程不存在：查询数据库中是否存在名为hd_public_resources_signature.procedure的存储过程。 3. 存储过程参数错误：检查调用存储过程时传入的参数是否与存储过程定义的参数匹配。 要解决这个问题，可以尝试以下步骤： 1. 确认存储过程名称正确无误，并且在数据库中存在。 2. 检查存储过程的定义语法，确保没有语法错误。 3. 检查存储过程的参数是否正确传入，并且与存储过程定义的参数匹配。 如果以上步骤都没有解决问题，可以尝试将问题的复现步骤提供给数据库管理员或开发团队，以便他们进一步调查和解决问题。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值