com.ibatis.common.beans.ProbeException: There is no READABLE property named 'baiduIndex' in class '

关注

转载最新推荐文章于 2026-03-24 12:51:41 发布 2.4k 阅读 AI 写同款· GEO 优化 ›

Python读取三菱PLC数据 3、支持自定义的数据读写操作。直接调用Read方法，可以读取到原生的byte数组，然后进行组合数据。1、每次的数据交互您都可以判断是否成功，如果您不判断，如果网络断开或是异常，会影响程序的执行。Qna3E协议的ascii类 MelsecMcAsciiNet。A兼容1E协议的二进制类 MelsecA1ENet。Qna3E协议的二进制类 MelsecMcNet。2、读写操作支持单个数和数组。阅读详情

com.ibatis.common.beans.ProbeException: There is no READABLE property named 'baiduIndex' in class 'j

标签： ibatis mysql

2016-04-18 11:08 193人阅读评论(0) 收藏举报

 
  分类：
 
  错误纠正（6）

 版权声明：本文为博主原创文章，转载请指明文章出处！

第一次使用ibatis，不是很熟悉，使用时sql报如下错误：

DEBUG 2016-04-18 10:45:41: [org.springframework.jdbc.support.SQLErrorCodesFactory.(175)getErrorCodes] - SQL error codes for ‘MySQL’ found
DEBUG 2016-04-18 10:45:41: [org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.(283)doTranslate] - Unable to translate SQLException with Error code ‘0’, will now try the fallback translator
ERROR 2016-04-18 10:45:41: [com.cmcf.web.controller.cms.SeoCikuKeywordsController.(139)queryCikuList] - 获取关键词列表异常！
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
— The error occurred in ibatis/SeoCikuKeywords.xml.
— The error occurred while preparing the mapped statement for execution.
— Check the com.cmcf.model.entity.cms.SeoCikuKeywordsEntity.queryCikuList_count.
— Check the parameter map.
— Cause: com.ibatis.common.beans.ProbeException: There is no READABLE property named ‘baiduIndex’ in class ‘Java.lang.Object’; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in ibatis/SeoCikuKeywords.xml.
— The error occurred while preparing the mapped statement for execution.
— Check the com.cmcf.model.entity.cms.SeoCikuKeywordsEntity.queryCikuList_count.
— Check the parameter map.
— Cause: com.ibatis.common.beans.ProbeException: There is no READABLE property named ‘baiduIndex’ in class ‘java.lang.Object’
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
…………

我的代码如下：

<code class="hljs xml has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;"><span class="hljs-tag" style="color: rgb(0, 102, 102); box-sizing: border-box;"><<span class="hljs-title" style="box-sizing: border-box; color: rgb(0, 0, 136);">isNotEmpty</span> <span class="hljs-attribute" style="box-sizing: border-box; color: rgb(102, 0, 102);">prepend</span>=<span class="hljs-value" style="box-sizing: border-box; color: rgb(0, 136, 0);">"AND"</span> <span class="hljs-attribute" style="box-sizing: border-box; color: rgb(102, 0, 102);">property</span>=<span class="hljs-value" style="box-sizing: border-box; color: rgb(0, 136, 0);">"entity.baiduIndex"</span>></span>
                    <span class="hljs-tag" style="color: rgb(0, 102, 102); box-sizing: border-box;"><<span class="hljs-title" style="box-sizing: border-box; color: rgb(0, 0, 136);">isEqual</span> <span class="hljs-attribute" style="box-sizing: border-box; color: rgb(102, 0, 102);">property</span>=<span class="hljs-value" style="box-sizing: border-box; color: rgb(0, 136, 0);">"entity.baiduIndex"</span> <span class="hljs-attribute" style="box-sizing: border-box; color: rgb(102, 0, 102);">compareValue</span>=<span class="hljs-value" style="box-sizing: border-box; color: rgb(0, 136, 0);">"0"</span>></span>
                         <span class="hljs-cdata" style="color: rgb(0, 136, 0); box-sizing: border-box;"><![CDATA[
                            id  in (select typeAssociatedId  from tz_seo_ciku_article where content is  null or content="")
                         ]]></span>
                     <span class="hljs-tag" style="color: rgb(0, 102, 102); box-sizing: border-box;"></<span class="hljs-title" style="box-sizing: border-box; color: rgb(0, 0, 136);">isEqual</span>></span>
                      <span class="hljs-tag" style="color: rgb(0, 102, 102); box-sizing: border-box;"><<span class="hljs-title" style="box-sizing: border-box; color: rgb(0, 0, 136);">isEqual</span> <span class="hljs-attribute" style="box-sizing: border-box; color: rgb(102, 0, 102);">property</span>=<span class="hljs-value" style="box-sizing: border-box; color: rgb(0, 136, 0);">"entity.baiduIndex"</span> <span class="hljs-attribute" style="box-sizing: border-box; color: rgb(102, 0, 102);">compareValue</span>=<span class="hljs-value" style="box-sizing: border-box; color: rgb(0, 136, 0);">"1"</span>></span>
                          <span class="hljs-cdata" style="color: rgb(0, 136, 0); box-sizing: border-box;"><![CDATA[
                            id  in (select mainKeywordsId from tz_seo_ciku_keywords group by mainKeywordsId  having count(mainKeywordsId)<=3)
                          ]]></span>
                       <span class="hljs-tag" style="color: rgb(0, 102, 102); box-sizing: border-box;"></<span class="hljs-title" style="box-sizing: border-box; color: rgb(0, 0, 136);">isEqual</span>></span>
                       <span class="hljs-tag" style="color: rgb(0, 102, 102); box-sizing: border-box;"><<span class="hljs-title" style="box-sizing: border-box; color: rgb(0, 0, 136);">isEqual</span> <span class="hljs-attribute" style="box-sizing: border-box; color: rgb(102, 0, 102);">property</span>=<span class="hljs-value" style="box-sizing: border-box; color: rgb(0, 136, 0);">"entity.baiduIndex"</span> <span class="hljs-attribute" style="box-sizing: border-box; color: rgb(102, 0, 102);">compareValue</span>=<span class="hljs-value" style="box-sizing: border-box; color: rgb(0, 136, 0);">"2"</span>></span>
                           <span class="hljs-cdata" style="color: rgb(0, 136, 0); box-sizing: border-box;"><![CDATA[
                            id  in(select mainkeywordsid from tz_seo_ciku_keywords where link is null or link="" or link not like "%www.touzi.com%")
                           ]]></span>
                       <span class="hljs-tag" style="color: rgb(0, 102, 102); box-sizing: border-box;"></<span class="hljs-title" style="box-sizing: border-box; color: rgb(0, 0, 136);">isEqual</span>></span>
                <span class="hljs-tag" style="color: rgb(0, 102, 102); box-sizing: border-box;"></<span class="hljs-title" style="box-sizing: border-box; color: rgb(0, 0, 136);">isNotEmpty</span>></span></code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li><li style="box-sizing: border-box; padding: 0px 5px;">16</li><li style="box-sizing: border-box; padding: 0px 5px;">17</li></ul><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li><li style="box-sizing: border-box; padding: 0px 5px;">16</li><li style="box-sizing: border-box; padding: 0px 5px;">17</li></ul>

我的entity对象，以及xml文件里的resultMap entity对象都添加了相应的该属性，数据库和实体类属性都是baiduIndex，所以字段没有问题了。百度的很多都说是字段有问题…………
我的解决方法：
我对ibatis的isEqual标签不了解，但是我对sql有信心啊，所以我将我的代码改成如下：

<code class="hljs vhdl has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;"><isNotEmpty prepend=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"AND"</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">property</span>=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"entity.baiduIndex"</span>>
                    <![CDATA[
                        (<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">CASE</span> #<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">entity</span>.baiduIndex# <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">WHEN</span> <span class="hljs-literal" style="color: rgb(0, 102, 102); box-sizing: border-box;">'0'</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">THEN</span> id  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">in</span> (<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">select</span> typeAssociatedId  from tz_seo_ciku_article where content <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">is</span>  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">or</span> content=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">""</span>)
                        <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">WHEN</span> <span class="hljs-literal" style="color: rgb(0, 102, 102); box-sizing: border-box;">'1'</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">THEN</span> id  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">in</span> (<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">select</span> mainKeywordsId from tz_seo_ciku_keywords <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">group</span> by mainKeywordsId  having count(mainKeywordsId)<=<span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">3</span>)
                        <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">WHEN</span> '<span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">2</span>' <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">THEN</span> id  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">in</span>(<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">select</span> mainkeywordsid from tz_seo_ciku_keywords where link <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">is</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">or</span> link=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">""</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">or</span> link <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">not</span> like <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"%www.touzi.com%"</span>)
                         <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">END</span>)
                    ]]>
                </isNotEmpty></code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li></ul><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li></ul>

然后运行就可以了……至于原因，我也不清楚（T0T）……

收录于