caused by:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Query was empty

1 Error description

At Org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest (Invocablehandlermethod.java :) at Org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle ( SERVLETINVOCABLEHANDLERMETHOD.JAVA:104) at Org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod ( requestmappinghandleradapter.java:749) at Org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal ( requestmappinghandleradapter.java:689) at Org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle ( abstracthandlermethodadapter.java:83) at Org.springframework.web.servlet.DispatcherServlet.doDispatch ( dispatcherservlet.java:938) at Org.springframework.web.servlet.DispatcherServlet.doService ( dispatcherservlet.java:870) at Org.springframework.web.servlet.FrameworkServlet.processRequest ( frameworkservlet.java:961) at Org.springframework.web.servlet.FrameworkServlet.doPost (frameworkservlet.java:863) at Javax.servlet.http.HttpServlet.service (httpservlet.java:646) at Org.springframework.web.servlet.FrameworkServlet.service (frameworkservlet.java:837) at Javax.servlet.http.HttpServlet.service (httpservlet.java:727) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:303) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Org.apache.tomcat.websocket.server.WsFilter.doFilter (wsfilter.java:52) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:241) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Com.sc.oa.filter.TranscationFilter.doFilter (transcationfilter.java:32) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:241) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Com.sc.oa.filter.ContentFilter.doFilter (Contentfilter.java:69) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (Applicationfilterchain.java : 241) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal (characterencodingfilter.java:88) at Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:107) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:241) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter (proxiedfilterchain.java:61) at Org.apache.shiro.web.servlet.AdviceFilter.executeChain (advicefilter.java:108) at Org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal (advicefilter.java:137) at Org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter (onceperrequestfilter.java:125) at Org.apache.shiro.web.servlet.ProxiedFilterChain.doFiltER (proxiedfilterchain.java:66) at Org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain ( abstractshirofilter.java:449) at Org.apache.shiro.web.servlet.abstractshirofilter$1.call ( abstractshirofilter.java:365) at Org.apache.shiro.subject.support.SubjectCallable.doCall (subjectcallable.java:90 ) at Org.apache.shiro.subject.support.SubjectCallable.call (subjectcallable.java:83) at Org.apache.shiro.subject.support.DelegatingSubject.execute (delegatingsubject.java:383) at Org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal (abstractshirofilter.java:362) at Org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter (onceperrequestfilter.java:125) at Org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate (delegatingfilterproxy.java:344) at Org.springframework.web.filter.DelegatingFilterProxy.doFilter (delegatingfilterproxy.java:261) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:241) at Org.apache.catalina.core.ApplicationFilterChAin.dofilter (applicationfilterchain.java:208) at Org.apache.catalina.core.StandardWrapperValve.invoke ( standardwrappervalve.java:220) at Org.apache.catalina.core.StandardContextValve.invoke (Standardcontextvalve.java : 122) at Org.apache.catalina.authenticator.AuthenticatorBase.invoke (authenticatorbase.java:503) at Org.apache.catalina.core.StandardHostValve.invoke (standardhostvalve.java:170) at Org.apache.catalina.valves.ErrorReportValve.invoke (errorreportvalve.java:103) at Org.apache.catalina.valves.AccessLogValve.invoke (accesslogvalve.java:950) at Org.apache.catalina.core.StandardEngineValve.invoke (standardenginevalve.java:116) at Org.apache.catalina.connector.CoyoteAdapter.service (coyoteadapter.java:421) at Org.apache.coyote.http11.AbstractHttp11Processor.process (abstracthttp11processor.java:1070) at Org.apache.coyote.abstractprotocol$abstractconnectionhandler.process (abstractprotocol.java:611) at Org.apache.tomcat.util.net.aprendpoint$socketprocessor.dorun (aprendpoint.java:2466) at ORG.APACHE.TOMCAt.util.net.aprendpoint$socketprocessor.run (aprendpoint.java:2455) at Java.util.concurrent.ThreadPoolExecutor.runWorker (threadpoolexecutor.java:1145) at Java.util.concurrent.threadpoolexecutor$worker.run (threadpoolexecutor.java:615) at Org.apache.tomcat.util.threads.taskthread$wrappingrunnable.run (taskthread.java:61) at Java.lang.Thread.run ( thread.java:745) caused By:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Query was Emptyat Sun.reflect.NativeConstructorAccessorImpl.newInstance0 (Native Method) at Sun.reflect.NativeConstructorAccessorImpl.newInstance (nativeconstructoraccessorimpl.java:57) at Sun.reflect.DelegatingConstructorAccessorImpl.newInstance (delegatingconstructoraccessorimpl.java:45) at Java.lang.reflect.Constructor.newInstance (constructor.java:526) at Com.mysql.jdbc.Util.handleNewInstance ( util.java:411) at Com.mysql.jdbc.Util.getInstance (util.java:386) at Com.mysql.jdbc.SQLError.createSQLException ( sqlerror.java:1053) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (Mysqlio.java: 4074) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (mysqlio.java:4006) at Com.mysql.jdbc.MysqlIO.sendCommand ( mysqlio.java:2468) at Com.mysql.jdbc.MysqlIO.sqlQueryDirect (mysqlio.java:2629) at Com.mysql.jdbc.ConnectionImpl.execSQL (connectionimpl.java:2719) at Com.mysql.jdbc.PreparedStatement.executeInternal (preparedstatement.java:2155) at Com.mysql.jdbc.PreparedStatement.executeQuery (preparedstatement.java:2318) at Org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery (delegatingpreparedstatement.java:92) at Com.sc.oa.base.dao.impl.basedaoimpl$2.execute (basedaoimpl.java:148) at com.sc.oa.base.dao.impl.basedaoimpl$2. Execute (basedaoimpl.java:1) at Org.hibernate.jdbc.WorkExecutor.executeReturningWork (workexecutor.java:72) at Org.hibernate.internal.sessionimpl$3.accept (sessionimpl.java:2052) at Org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork (jdbccoordinatorimpl.java:313) ... Bayi moreorg.springframework.web.util.NestedServletException:Request processing failed; Nested ExceptiOn was code is 9998;desc is query failed exception is org.hibernate.exception.SQLGrammarException:error executing Workat org.sprin Gframework.web.servlet.FrameworkServlet.processRequest (frameworkservlet.java:973) at Org.springframework.web.servlet.FrameworkServlet.doPost (frameworkservlet.java:863) at Javax.servlet.http.HttpServlet.service (httpservlet.java:646) at Org.springframework.web.servlet.FrameworkServlet.service (frameworkservlet.java:837) at Javax.servlet.http.HttpServlet.service (httpservlet.java:727) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:303) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Org.apache.tomcat.websocket.server.WsFilter.doFilter (wsfilter.java:52) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:241) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Com.sc.oa.filter.TranscationFilter.doFilter (transcationfilter.java:32) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter ( applicationfilterchain.java:241) at Org.apache.catalina.core.ApplicationFilterChain.doFilter ( applicationfilterchain.java:208) at Com.sc.oa.filter.ContentFilter.doFilter (contentfilter.java:69) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:241) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal (characterencodingfilter.java:88) at Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:107) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:241) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter (proxiedfilterchain.java:61) at Org.apache.shiro.web.servlet.AdviceFilTer.executechain (advicefilter.java:108) at Org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal ( advicefilter.java:137) at Org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter (Onceperrequestfilter.java : (proxiedfilterchain.java:66) at Org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter Org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain (abstractshirofilter.java:449) at Org.apache.shiro.web.servlet.abstractshirofilter$1.call (abstractshirofilter.java:365) at Org.apache.shiro.subject.support.SubjectCallable.doCall (subjectcallable.java:90) at Org.apache.shiro.subject.support.SubjectCallable.call (subjectcallable.java:83) at Org.apache.shiro.subject.support.DelegatingSubject.execute (delegatingsubject.java:383)

2 Error Reason

In public queries, no corresponding query content is written, resulting in an empty query

Case 33:

3 Solutions

In the query public implementation class, add the query method for the previous module

Case 33:

Sql.append ("Select T.user_id,t.user_name from T_user_tab");

Sql.append ("where 1=1");

if (Stringutils.isnotblank (User.getuserid ())

{

}

caused by:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Query was empty