Mybatis非配置原因,導(dǎo)致SqlSession was not registered for synchronization異常
今天運(yùn)行程序時(shí)報(bào)了
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]
由于異常是集中處理的,所以報(bào)了這樣的錯(cuò)誤,查了半天,網(wǎng)上結(jié)果都是說(shuō)配置文件出錯(cuò)的,可是我的項(xiàng)目配置文件肯定是沒(méi)錯(cuò)的,因?yàn)轫?xiàng)目都開(kāi)發(fā)了好長(zhǎng)時(shí)間了,只是我今天寫(xiě)了個(gè)方法才報(bào)的這個(gè)錯(cuò)誤,所以排除配置文件出錯(cuò),可是我寫(xiě)的方法應(yīng)該沒(méi)問(wèn)題的,以前也這樣寫(xiě)的呀。
網(wǎng)上查半天沒(méi)找到原因,沒(méi)辦法,只能看看自己的程序了,把自己寫(xiě)的方法異常直接打印出來(lái),先不集中處理,然后異常出來(lái)了:
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
根據(jù)這個(gè)異常再查程序,發(fā)現(xiàn)問(wèn)題出現(xiàn)在departid這個(gè)參數(shù),再查源程序,發(fā)現(xiàn)原來(lái)我寫(xiě)的那個(gè)方法的sql在mapper.xml文件里引用了對(duì)參數(shù)departid進(jìn)行判斷是否為null或空,所以才報(bào) There is no getter for property named ‘departid‘ in ‘class java.lang.String‘異常。
解決方法:一、在方法傳參時(shí),加param參數(shù)標(biāo)識(shí),如:countNum(@Param("departid")String departid);
二、在方法傳參時(shí),把參數(shù)換成map或?qū)ο蟆?/strong>
希望通過(guò)此文能解決這類(lèi)問(wèn)題,謝謝大家對(duì)本站的支持!
到此這篇關(guān)于Mybatis非配置原因,導(dǎo)致SqlSession was not registered for synchronization異常的文章就介紹到這了,更多相關(guān)Mybatis非配置原因出錯(cuò)內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
- SpringMVC+MyBatis聲明式事務(wù)管理
- MyBatis入門(mén)學(xué)習(xí)教程(一)-MyBatis快速入門(mén)
- 深入淺析mybatis oracle BLOB類(lèi)型字段保存與讀取
- Java的MyBatis框架中實(shí)現(xiàn)多表連接查詢(xún)和查詢(xún)結(jié)果分頁(yè)
- Java的MyBatis框架中Mapper映射配置的使用及原理解析
- MyBatis批量插入(insert)數(shù)據(jù)操作
- springboot與mybatis整合實(shí)例詳解(完美融合)
- mybatis中批量插入的兩種方式(高效插入)
- Mybatis分頁(yè)插件PageHelper的使用詳解
- Mybatis報(bào)錯(cuò): org.apache.ibatis.exceptions.PersistenceException解決辦法
- Mybatis Update操作返回值問(wèn)題
- Mybatis中使用updateBatch進(jìn)行批量更新
- Mybatis中傳遞多個(gè)參數(shù)的4種方法總結(jié)
- MyBatis中傳入?yún)?shù)parameterType類(lèi)型詳解
- 詳解Mybatis通用Mapper介紹與使用
- MyBatisPlus 自定義sql語(yǔ)句的實(shí)現(xiàn)
- 結(jié)合mybatis-plus實(shí)現(xiàn)簡(jiǎn)單不需要寫(xiě)sql的多表查詢(xún)
- MyBatis配置文件解析與MyBatis實(shí)例演示
相關(guān)文章
SQL Server存儲(chǔ)過(guò)程(數(shù)據(jù)庫(kù)引擎)使用詳解
存儲(chǔ)過(guò)程(Stored Procedure)是預(yù)編譯SQL語(yǔ)句集合,這些語(yǔ)句存儲(chǔ)在一個(gè)名稱(chēng)(存儲(chǔ)過(guò)程的名稱(chēng))下并作為單元來(lái)處理,存儲(chǔ)過(guò)程代替了傳統(tǒng)的逐條執(zhí)行SQL語(yǔ)句的方式,本文小編給大家介紹了SQL Server存儲(chǔ)過(guò)程(數(shù)據(jù)庫(kù)引擎)使用,需要的朋友可以參考下2023-11-11
mssql無(wú)數(shù)據(jù)庫(kù)日志文件恢復(fù)數(shù)據(jù)庫(kù)的方法
因各種原因我們需要注意恢復(fù)數(shù)據(jù)庫(kù),如果剛好有沒(méi)有數(shù)據(jù)庫(kù)日志文件,那就不妨用下面的方法2008-09-09
使用sqlserver存儲(chǔ)過(guò)程sp_send_dbmail發(fā)送郵件配置方法(圖文)
這篇文章用圖文的方式介紹了使用sqlserver存儲(chǔ)過(guò)程sp_send_dbmail發(fā)送郵件的方法,大家參考使用吧2014-01-01
Sql中將datetime轉(zhuǎn)換成字符串的方法(CONVERT)
這篇文章主要介紹了Sql中將datetime轉(zhuǎn)換成字符串的方法,需要的朋友可以參考下2014-04-04
SQL server查看各表的索引(sql語(yǔ)句大全)
使用Sql語(yǔ)句查看 SQL Server 數(shù)據(jù)庫(kù)中的索引,本文給大家介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值,需要的朋友參考下吧2023-12-12
java連接mysql數(shù)據(jù)庫(kù) java連接sql server數(shù)據(jù)庫(kù)
這篇文章主要為大家詳細(xì)介紹了java連接mysql數(shù)據(jù)庫(kù),以及java連接sql server數(shù)據(jù)庫(kù),具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2017-02-02
實(shí)例理解SQL中truncate和delete的區(qū)別
這篇文章主要介紹了實(shí)例理解SQL中truncate和delete的區(qū)別,truncate和delete兩者易混,本文就為大家進(jìn)行區(qū)分兩者的異同,感興趣的小伙伴們可以參考一下2016-02-02
SQL Server使用Merge語(yǔ)句當(dāng)源表數(shù)據(jù)集為空時(shí),無(wú)法進(jìn)行查詢(xún)的問(wèn)題
今天使用Merge語(yǔ)句時(shí)遇到了一個(gè)問(wèn)題,當(dāng)源表數(shù)據(jù)集為空時(shí),merge就不工作了。2009-07-07

