今天运行程序时报了
sqlsession [org.apache.ibatis.session.defaults.defaultsqlsession@69d4fb43] was not registered for synchronization because synchronization is not active
[11:03:17]-closing non transactional sqlsession [org.apache.ibatis.session.defaults.defaultsqlsession@69d4fb43]
由于异常是集中处理的，所以报了这样的错误，查了半天，网上结果都是说配置文件出错的，可是我的项目配置文件肯定是没错的，因为项目都开发了好长时间了，只是我今天写了个方法才报的这个错误，所以排除配置文件出错，可是我写的方法应该没问题的，以前也这样写的呀。
网上查半天没找到原因，没办法，只能看看自己的程序了，把自己写的方法异常直接打印出来，先不集中处理，然后异常出来了：
org.mybatis.spring.mybatissystemexception: nested exception is org.apache.ibatis.reflection.reflectionexception: there is no getter for property named ‘departid‘ in ‘class java.lang.string‘
at org.mybatis.spring.mybatisexceptiontranslator.translateexceptionifpossible(mybatisexceptiontranslator.java:75)
at org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke(sqlsessiontemplate.java:371)
at com.sun.proxy.$proxy15.selectone(unknown source)
at org.mybatis.spring.sqlsessiontemplate.selectone(sqlsessiontemplate.java:163)
at org.apache.ibatis.binding.mappermethod.execute(mappermethod.java:68)
at org.apache.ibatis.binding.mapperproxy.invoke(mapperproxy.java:52)
at com.sun.proxy.$proxy125.selectcount(unknown source)
at com.sinog2c.service.impl.yzgl.tbyzscoreserviceimpl.selectcount(tbyzscoreserviceimpl.java:66)
at com.sinog2c.mvc.controller.yzgl.criminalexam.jifencontroller.getlastmonthscorelist(jifencontroller.java:76)
at sun.reflect.nativemethodaccessorimpl.invoke0(native method)
at sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39)
at sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25)
at java.lang.reflect.method.invoke(method.java:597)
at org.springframework.web.bind.annotation.support.handlermethodinvoker.invokehandlermethod(handlermethodinvoker.java:175)
at org.springframework.web.servlet.mvc.annotation.annotationmethodhandleradapter.invokehandlermethod(annotationmethodhandleradapter.java:446)
at org.springframework.web.servlet.mvc.annotation.annotationmethodhandleradapter.handle(annotationmethodhandleradapter.java:434)
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.doget(frameworkservlet.java:852)
at javax.servlet.http.httpservlet.service(httpservlet.java:617)
at org.springframework.web.servlet.frameworkservlet.service(frameworkservlet.java:837)
at javax.servlet.http.httpservlet.service(httpservlet.java:723)
at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:290)
at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206)
at com.alibaba.druid.support.http.webstatfilter.dofilter(webstatfilter.java:124)
at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235)
at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206)
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:235)
at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206)
at org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:233)
at org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:191)
at org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:127)
at org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:103)
at org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:109)
at org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:293)
at org.apache.coyote.http11.http11processor.process(http11processor.java:861)
at org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:606)
at org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:489)
at java.lang.thread.run(thread.java:662)
caused by: org.apache.ibatis.reflection.reflectionexception: there is no getter for property named ‘departid‘ in ‘class java.lang.string‘
at org.apache.ibatis.reflection.reflector.getgetinvoker(reflector.java:380)
at org.apache.ibatis.reflection.metaclass.getgetinvoker(metaclass.java:170)
at org.apache.ibatis.reflection.wrapper.beanwrapper.getbeanproperty(beanwrapper.java:152)
at org.apache.ibatis.reflection.wrapper.beanwrapper.get(beanwrapper.java:48)
at org.apache.ibatis.reflection.metaobject.getvalue(metaobject.java:116)
at org.apache.ibatis.scripting.xmltags.dynamiccontext$contextmap.get(dynamiccontext.java:97)
at org.apache.ibatis.scripting.xmltags.dynamiccontext$contextaccessor.getproperty(dynamiccontext.java:116)
at org.apache.ibatis.ognl.ognlruntime.getproperty(ognlruntime.java:1657)
at org.apache.ibatis.ognl.astproperty.getvaluebody(astproperty.java:92)
at org.apache.ibatis.ognl.simplenode.evaluategetvaluebody(simplenode.java:170)
at org.apache.ibatis.ognl.simplenode.getvalue(simplenode.java:210)
at org.apache.ibatis.ognl.astnoteq.getvaluebody(astnoteq.java:49)
at org.apache.ibatis.ognl.simplenode.evaluategetvaluebody(simplenode.java:170)
at org.apache.ibatis.ognl.simplenode.getvalue(simplenode.java:210)
at org.apache.ibatis.ognl.astand.getvaluebody(astand.java:56)
at org.apache.ibatis.ognl.simplenode.evaluategetvaluebody(simplenode.java:170)
at org.apache.ibatis.ognl.simplenode.getvalue(simplenode.java:210)
at org.apache.ibatis.ognl.ognl.getvalue(ognl.java:333)
at org.apache.ibatis.ognl.ognl.getvalue(ognl.java:413)
at org.apache.ibatis.ognl.ognl.getvalue(ognl.java:395)
at org.apache.ibatis.scripting.xmltags.ognlcache.getvalue(ognlcache.java:48)
at org.apache.ibatis.scripting.xmltags.expressionevaluator.evaluateboolean(expressionevaluator.java:32)
at org.apache.ibatis.scripting.xmltags.ifsqlnode.apply(ifsqlnode.java:33)
at org.apache.ibatis.scripting.xmltags.mixedsqlnode.apply(mixedsqlnode.java:32)
at org.apache.ibatis.scripting.xmltags.dynamicsqlsource.getboundsql(dynamicsqlsource.java:40)
at org.apache.ibatis.mapping.mappedstatement.getboundsql(mappedstatement.java:278)
at org.apache.ibatis.executor.cachingexecutor.query(cachingexecutor.java:75)
at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:108)
at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:102)
at org.apache.ibatis.session.defaults.defaultsqlsession.selectone(defaultsqlsession.java:66)
at sun.reflect.nativemethodaccessorimpl.invoke0(native method)
at sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39)
at sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25)
at java.lang.reflect.method.invoke(method.java:597)
at org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke(sqlsessiontemplate.java:358)
… 40 more
根据这个异常再查程序，发现问题出现在departid这个参数，再查源程序，发现原来我写的那个方法的sql在mapper.xml文件里引用了对参数departid进行判断是否为null或空，所以才报 there is no getter for property named ‘departid‘ in ‘class java.lang.string‘异常。
解决方法：一、在方法传参时，加param参数标识，如：countnum(@param(“departid”)string departid);
二、在方法传参时，把参数换成map或对象。
希望通过此文能解决这类问题，谢谢大家对本站的支持！