statementType错误收集(持续收集)

最新推荐文章于 2022-10-08 17:23:51 发布

老爸是程序员

最新推荐文章于 2022-10-08 17:23:51 发布

阅读量456

点赞数 1

分类专栏： mysql mybatis 文章标签： mybatis mysql

本文链接：https://blog.csdn.net/king101125s/article/details/104178606

版权

mysql 同时被 2 个专栏收录

10 篇文章 0 订阅

订阅专栏

mybatis

5 篇文章 0 订阅

订阅专栏

如需对statementType 进一步了解参考博文statementType：STATEMENT，PREPARED 或 CALLABLE

在使用 statementType=“CALLABLE” 做数据插入时报错，

org.springframework.dao.TransientDataAccessResourceException: 
### Error querying database.  Cause: java.sql.SQLException: Unable to retrieve metadata for procedure.
### The error may exist in org/minp/vhr/mapper/DepartmentMapper.xml
### The error may involve org.minp.vhr.mapper.DepartmentMapper.addDep
### The error occurred while executing a query
### SQL: call         addDep(?, ?,                    ?, ?,                    ?)
### Cause: java.sql.SQLException: Unable to retrieve metadata for procedure.
; Unable to retrieve metadata for procedure.; nested exception is java.sql.SQLException: Unable to retrieve metadata for procedure.

直接贴出修改前后的sql
修改前

<select id="deleteDepById" statementType="CALLABLE">
        call 
        deleteDep(#{id,mode=IN,jdbcType=INTEGER}, #{result,mode=OUT,jdbcType=INTEGER})
    </select>

修改后（可正常执行）

<select id="deleteDepById" statementType="CALLABLE">
        call deleteDep(#{id,mode=IN,jdbcType=INTEGER}, #{result,mode=OUT,jdbcType=INTEGER})
    </select>