错误日志 sql脚本
mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://img-blog.csdnimg.cn/20200519165927704.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTI2NTQyNw==,size_16,color_FFFFFF,t_70)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://img-blog.csdnimg.cn/20200519170021707.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTI2NTQyNw==,size_16,color_FFFFFF,t_70)
起初关于这个问题一直想通过错误码为入口进行问题排查，无奈源码阅读能力有限，一直没有弄明白错误码的生成原理，导致问题定位耗时较长。又苦于本地单元测试恰巧出问题，一直没发断点到源码追溯问题。纠结了一上午，加了日志查看执行sql前的list.传值。终于找到问题，是因为批量更新的脚本list传值为空，动态生成sql语句为空，mybatis报错!!!<update id="batchUpdateSql" parameterType="java util. List"> <foreach item ="item" index="index" collection="list" separator=";" open="" close=";end:"> update table t <set> t. OPERATOR =#{item.operator}, t.prop_show=#{item.propShow}, t.UPDATED_BY =user, t.DATE_UPDATED=sysdate </set> where t.code =#{item.code} and t.is_delete="N" </foreach> </update>
本网页所有视频内容由 imoviebox边看边下-网页视频下载, iurlBox网页地址收藏管理器 下载并得到。
ImovieBox网页视频下载器 下载地址: ImovieBox网页视频下载器-最新版本下载
本文章由: imapbox邮箱云存储,邮箱网盘,ImageBox 图片批量下载器,网页图片批量下载专家,网页图片批量下载器,获取到文章图片,imoviebox网页视频批量下载器,下载视频内容,为您提供.
阅读和此文章类似的: 全球云计算
官方软件产品操作指南 (170)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://csdnimg.cn/release/phoenix/template/new_img/tobarThumbUpactive.png)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://csdnimg.cn/release/phoenix/template/new_img/thumbUpWhite.png)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://csdnimg.cn/release/phoenix/template/new_img/commentWhite.png)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://csdnimg.cn/release/phoenix/template/new_img/shareWhite.png)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://csdnimg.cn/release/phoenix/template/new_img/collectWhite.png)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://csdnimg.cn/release/phoenix/template/new_img/tobarCollectionActive.png)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://csdnimg.cn/release/phoenix/template/new_img/mobileWhite.png)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://csdnimg.cn/release/phoenix/template/new_img/rewardWhite.png)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://csdnimg.cn/release/phoenix/template/new_img/CommentArrow.png)
![mybatis 之 uncategorized SQLException for SQL [: SQL state [99999]: error code [17104]javaweixin39265427的博客-](https://kunyu.csdn.net/1.png?p=58&a=386&c=0&k=&d=1&t=3&u=6a93f66970274f75b08e45d5139755be)