SSM注解式開発ラベルはbugを使用しています.
mybatisで開発し、sqlでラベルを使うと、ifタグの変数使用エラーが原因で、直接変数名を使えばいいです.
org.mybatis.spring.MyBatis System Exception:neted exception is org.apache.ibatis.exceptions.Persistence Exception: ### Error querying database. Cause:java.lang.IllgalAgment Exception:invalid comprison:java.util.linkedHashMap and java.lang.String.Mavance. at org.mybatis.spring.MyBatis Exception Translate.tranlateException IfPossible(MyBatis Exception Translate.java:77) at org.mybatis.spring.Sql Session Template$Sql Session Interceptor.invoke(Sql Session Template.java:446) at comp.sun.proxy.$Proxy 15.5 selectList(Uniknown Source) at org.mybatis.spring.Sql Session Template.selectList(Sql Session Template.java:230) at org.apaache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137) at org.apaache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) at comp.sun.proxy.$Proxy 18 getVarequipment Code(Unknown Source) at comp.serviceImpl.DyeServiceImpl.getVare quipment Code(DyeServiceImpl.java:38) at comp.co ntroller.DyeController.get Curday Chemicats(DyeController.java:210) at sun.reflect.NativeMethodAccess orImpl.invoke 0(Native Method) at sun.reflect.NativeMethodAccess orImpl.invoke(NativeMethodAccess orImpl.java:62) at sun.reflegating.MethodAccess orImpl.invoke(Delegating MethodAccess orImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.springframe ebook.web.method.support.Invocable HandlerMethod.doInvoke(Invocable Handler Method.java:205) at org.springframe ebook.web.method.support.Invocable Handler Method.invokeForRequest(Invocable Handler Method.java:133) at org.springframe ebook.web.servlet.mvc.method.annotations.ServletInvocable Handler Method.invoke AndHandle(Servlet Invocable HandlerMethod.java:97) at org.springframe ework.web.servlet.mvc.method.annotations.Request MappingHandler.invoke Handler Method(Request Mappinghandler.java:849) at org.springframe ewark.web.servlet.mvc.method.annotations.Request MappingHandler.handler Internal(Request Mappinghandler.java:760) at org.springframe ework.web.servlet.mvc.method.AbstracthandlerMethodAdapter.handle(Abstracthandler MethodAdapter.java:85) at org.springframe ework.web.servlet.DisplatServlet.doDisplatch(DisplatServlet.java:967) at org.springframe ework.web.servlet.DisplatServlet.doService(DisplatServlet.java:901) at org.springframe ework.web.servlet.Frame ebook Servlet.processRequest(Fram ework Servlet.java:970) at org.springframe ework.web.servlet.Framew orkServlet.doGet(Frame ebork Servlet.java:861) at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) at org.springframe ework.web.servlet.Framew orkServlet.service(Frame ew orkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:231) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.apacthe.tomcat.websockett.server.Ws Filter.doFilter(Ws Filter.java:52) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:193) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.springframe ework.web.filter.HttpPutFormContentFilter.dofilter Internal(HttpPut FormContentFilter.java:109) at org.springframe ework.web.filter.OnecePerRequest Filter.doFilter(OnecePerRequest Filter.java:107) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:193) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.springframe ework.web.filter.HddenHttp MethodFilter.dofilter Internal(HddenHttp MethodFilter.java:93) at org.springframe ework.web.filter.OnecePerRequest Filter.doFilter(OnecePerRequest Filter.java:107) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:193) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.springframe ework.web.filter.character EncocdingFilter.dofilter Internal(CharcterEncodingFilter.java:197) at org.springframe ework.web.filter.OnecePerRequest Filter.doFilter(OnecePerRequest Filter.java:107) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:193) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.apache.cantalina.co.StandardWrapperValve.invoke(StanddardWrapperValve.java:198) at org.apache.aparaina.co.Standard ControtextValve.invoke(Standard Contect.Valve.java:96) at org.apaache.authenticator.Authenticators.invoke(Authenticators.java:493) at org.apache.catiina.co re.Standard HostValve.invoke(Standard HostValve.java:140) at org.apaache.atelina.valves.Error Report Valve.invoke(Errer Report Valve.java:81) at org.apaace.ccantalina.valves.AbstractAccess LogValve.invoke(AbstractAccess LogValve.java:650) at org.apache.cantalina.com re.Standard EntineValve.invoke(Standard Engine Valve.java:87) at org.apache.aparaina.co.nector.co yoteAdapter.service(CoyoteAdapter.java:342) at org.apache.co yote.http 11.Http 11 Processe.service(Http 11 Processe ore.java:800) at org.apacho.co yote.Abstract Processight.process(Abstract Process orlight.java:66) at org.apacho.co yote.AbstractProtocol$Connection Handler.process(Abstract Protocol.java:806) at org.apaache.tomcat.util.net.NioEndpoint$SocketProcess.doRun(NioEnd point.java:1498) at org.apaache.tomcat.util.net.SocketProcessorsorBase.run(SocketProcesssorBase.java:49) at java.util.co ncurrent.ThreadPool Exector.runWorker(ThreadPool Exector.java:1142) at java.util.co ncurrent.ThreadPool ExectorドルWorker.run(ThreadPool Exector.java:617) at org.apaache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)Caused by:org.apache.ibatis.exceptions.Persistence Exception: ### Error querying database. Cause:java.lang.IllgalAgment Exception:invalid comprison:java.util.linkedHashMap and java.lang.String.Mavance. at org.apache.ibatis.exceptions.Exception Factory.wrapException(Exception Factory.java:30) at org.apaache.ibatis.session.defaults.Default Sql Session.selectList(Default Sql Session.java:150) at org.apaache.ibatis.session.defaults.Default Sql Session.selectList(Default Sql Session.java:141) at sun.reflect.NativeMethodAccess orImpl.invoke 0(Native Method) at sun.reflect.NativeMethodAccess orImpl.invoke(NativeMethodAccess orImpl.java:62) at sun.reflegating.MethodAccess orImpl.invoke(Delegating MethodAccess orImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.mybatis.spring.Sql Session Template$Sql Session Interceptor.invoke(Sql Session Template.java:433) ... 59 more Caused by:java.lang.IllagalArgment Exception:invalid comprion:java.util.linkedHashMap and java.lang.String at org.apacthe.ibatis.ognl.OgnlOps.com are WithCoversion(OgnlOps.java:93) at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:143) at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:802) at org.apaache.ibatis.ognl.AST NotEq.getValueBody(AST NotEq.java:53) at org.apaache.ibatis.ognl.SimpleNode.evaluate GetValueBody(SimpleNode.java:212) at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) at org.apaache.ibatis.ognl.Ognl.getValue(Ognl.java:467) at org.apaache.ibatis.ognl.Ognl.getValue(Ognl.java:431) at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:44) at org.apacthe.ibatis.scripting.xmltags.ExpressitionEveralator.evaluate Boolean(ExpressitionEveralator.java:32) at org.apaache.ibatis.scripting.xmltags.IfSql Node.appply(IfSql Node.java:34) at org.apache.ibatis.scripting.xmltags.MixedSql Node.apple(MixedSql Node.java:33) at org.apache.ibatis.scripting.xmltags.DynamicSql Source.get BoundSql(DynamicSql Source.java:41) at org.apache.ibatis.mapping.Mapped Sttement.get BoundSql(Mapped Sttement.java:292) at org.apaache.ibatis.exector.Cector.query(Caching Exector.java:81) at org.apaache.ibatis.session.defaults.Default Sql Session.selectList(Default Sql Session.java:148) ... 65 more
AND LEFT(S.var_name, 1) = #{code}
org.mybatis.spring.MyBatis System Exception:neted exception is org.apache.ibatis.exceptions.Persistence Exception: ### Error querying database. Cause:java.lang.IllgalAgment Exception:invalid comprison:java.util.linkedHashMap and java.lang.String.Mavance. at org.mybatis.spring.MyBatis Exception Translate.tranlateException IfPossible(MyBatis Exception Translate.java:77) at org.mybatis.spring.Sql Session Template$Sql Session Interceptor.invoke(Sql Session Template.java:446) at comp.sun.proxy.$Proxy 15.5 selectList(Uniknown Source) at org.mybatis.spring.Sql Session Template.selectList(Sql Session Template.java:230) at org.apaache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137) at org.apaache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) at comp.sun.proxy.$Proxy 18 getVarequipment Code(Unknown Source) at comp.serviceImpl.DyeServiceImpl.getVare quipment Code(DyeServiceImpl.java:38) at comp.co ntroller.DyeController.get Curday Chemicats(DyeController.java:210) at sun.reflect.NativeMethodAccess orImpl.invoke 0(Native Method) at sun.reflect.NativeMethodAccess orImpl.invoke(NativeMethodAccess orImpl.java:62) at sun.reflegating.MethodAccess orImpl.invoke(Delegating MethodAccess orImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.springframe ebook.web.method.support.Invocable HandlerMethod.doInvoke(Invocable Handler Method.java:205) at org.springframe ebook.web.method.support.Invocable Handler Method.invokeForRequest(Invocable Handler Method.java:133) at org.springframe ebook.web.servlet.mvc.method.annotations.ServletInvocable Handler Method.invoke AndHandle(Servlet Invocable HandlerMethod.java:97) at org.springframe ework.web.servlet.mvc.method.annotations.Request MappingHandler.invoke Handler Method(Request Mappinghandler.java:849) at org.springframe ewark.web.servlet.mvc.method.annotations.Request MappingHandler.handler Internal(Request Mappinghandler.java:760) at org.springframe ework.web.servlet.mvc.method.AbstracthandlerMethodAdapter.handle(Abstracthandler MethodAdapter.java:85) at org.springframe ework.web.servlet.DisplatServlet.doDisplatch(DisplatServlet.java:967) at org.springframe ework.web.servlet.DisplatServlet.doService(DisplatServlet.java:901) at org.springframe ework.web.servlet.Frame ebook Servlet.processRequest(Fram ework Servlet.java:970) at org.springframe ework.web.servlet.Framew orkServlet.doGet(Frame ebork Servlet.java:861) at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) at org.springframe ework.web.servlet.Framew orkServlet.service(Frame ew orkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:231) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.apacthe.tomcat.websockett.server.Ws Filter.doFilter(Ws Filter.java:52) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:193) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.springframe ework.web.filter.HttpPutFormContentFilter.dofilter Internal(HttpPut FormContentFilter.java:109) at org.springframe ework.web.filter.OnecePerRequest Filter.doFilter(OnecePerRequest Filter.java:107) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:193) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.springframe ework.web.filter.HddenHttp MethodFilter.dofilter Internal(HddenHttp MethodFilter.java:93) at org.springframe ework.web.filter.OnecePerRequest Filter.doFilter(OnecePerRequest Filter.java:107) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:193) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.springframe ework.web.filter.character EncocdingFilter.dofilter Internal(CharcterEncodingFilter.java:197) at org.springframe ework.web.filter.OnecePerRequest Filter.doFilter(OnecePerRequest Filter.java:107) at org.apacthe.cantalina.co re.Appliation FilterChane.internal DFilter(Appplication Filter Char.java:193) at org.apache.cationa.co.re.Application FilterChain.dofilter(Appplication FilterChara.java:166) at org.apache.cantalina.co.StandardWrapperValve.invoke(StanddardWrapperValve.java:198) at org.apache.aparaina.co.Standard ControtextValve.invoke(Standard Contect.Valve.java:96) at org.apaache.authenticator.Authenticators.invoke(Authenticators.java:493) at org.apache.catiina.co re.Standard HostValve.invoke(Standard HostValve.java:140) at org.apaache.atelina.valves.Error Report Valve.invoke(Errer Report Valve.java:81) at org.apaace.ccantalina.valves.AbstractAccess LogValve.invoke(AbstractAccess LogValve.java:650) at org.apache.cantalina.com re.Standard EntineValve.invoke(Standard Engine Valve.java:87) at org.apache.aparaina.co.nector.co yoteAdapter.service(CoyoteAdapter.java:342) at org.apache.co yote.http 11.Http 11 Processe.service(Http 11 Processe ore.java:800) at org.apacho.co yote.Abstract Processight.process(Abstract Process orlight.java:66) at org.apacho.co yote.AbstractProtocol$Connection Handler.process(Abstract Protocol.java:806) at org.apaache.tomcat.util.net.NioEndpoint$SocketProcess.doRun(NioEnd point.java:1498) at org.apaache.tomcat.util.net.SocketProcessorsorBase.run(SocketProcesssorBase.java:49) at java.util.co ncurrent.ThreadPool Exector.runWorker(ThreadPool Exector.java:1142) at java.util.co ncurrent.ThreadPool ExectorドルWorker.run(ThreadPool Exector.java:617) at org.apaache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)Caused by:org.apache.ibatis.exceptions.Persistence Exception: ### Error querying database. Cause:java.lang.IllgalAgment Exception:invalid comprison:java.util.linkedHashMap and java.lang.String.Mavance. at org.apache.ibatis.exceptions.Exception Factory.wrapException(Exception Factory.java:30) at org.apaache.ibatis.session.defaults.Default Sql Session.selectList(Default Sql Session.java:150) at org.apaache.ibatis.session.defaults.Default Sql Session.selectList(Default Sql Session.java:141) at sun.reflect.NativeMethodAccess orImpl.invoke 0(Native Method) at sun.reflect.NativeMethodAccess orImpl.invoke(NativeMethodAccess orImpl.java:62) at sun.reflegating.MethodAccess orImpl.invoke(Delegating MethodAccess orImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.mybatis.spring.Sql Session Template$Sql Session Interceptor.invoke(Sql Session Template.java:433) ... 59 more Caused by:java.lang.IllagalArgment Exception:invalid comprion:java.util.linkedHashMap and java.lang.String at org.apacthe.ibatis.ognl.OgnlOps.com are WithCoversion(OgnlOps.java:93) at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:143) at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:802) at org.apaache.ibatis.ognl.AST NotEq.getValueBody(AST NotEq.java:53) at org.apaache.ibatis.ognl.SimpleNode.evaluate GetValueBody(SimpleNode.java:212) at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) at org.apaache.ibatis.ognl.Ognl.getValue(Ognl.java:467) at org.apaache.ibatis.ognl.Ognl.getValue(Ognl.java:431) at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:44) at org.apacthe.ibatis.scripting.xmltags.ExpressitionEveralator.evaluate Boolean(ExpressitionEveralator.java:32) at org.apaache.ibatis.scripting.xmltags.IfSql Node.appply(IfSql Node.java:34) at org.apache.ibatis.scripting.xmltags.MixedSql Node.apple(MixedSql Node.java:33) at org.apache.ibatis.scripting.xmltags.DynamicSql Source.get BoundSql(DynamicSql Source.java:41) at org.apache.ibatis.mapping.Mapped Sttement.get BoundSql(Mapped Sttement.java:292) at org.apaache.ibatis.exector.Cector.query(Caching Exector.java:81) at org.apaache.ibatis.session.defaults.Default Sql Session.selectList(Default Sql Session.java:148) ... 65 more