Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType.INT
Apache Error org int Builder ibatis CAUSE jdbcType
2023-09-27 14:21:59 时间
Spring boot ibatis调用存储过程
因为有个查询比较复杂,需要过渡几次,通过几个临时表才可以解决。
当然也有一次性查询的,分几次写,比较清晰,而且思路明确。
那就写个存储过程,帖个简单的:
CREATE DEFINER=`root`@`localhost` PROCEDURE `pGetSjRpt`( in year int, in code varchar(50), in id int) BEGIN select * from sj where year=year; END
那么如何才能够调起这个过程过程:
@Options(statementType = StatementType.CALLABLE) @Select( "call pGetSjRpt(#{year,mode=IN,jdbcType=INTEGER}," +"#{code,mode=IN,jdbcType=VARCHAR}," +"#{id,mode=IN,jdbcType=INTEGER})" ) @Results({ @Result(property = "id", column = "id"), @Result(property = "year", column = "year"), @Result(property = "name", column = "name"), @Result(property = "code", column = "code"), @Result(property = "zyme", column = "zyme"), @Result(property = "zyode", column = "zyode") }) List<SjInfo> getSjPage();
因为一开始写成
year,mode=IN,jdbcType=INT
INT,STRING这种是不认的。
其实看有没有方法很简单,找个方法里,随便输入一个就会有提示。
相关文章
- 启动hadoop报ERROR org.apache.hadoop.hdfs.server.namenode.FSImage: Failed to load image from FSImageFile
- Centos Apache安装eAccelerator
- 【Web网站服务器开发】Apache 和 Tomcat的区别及配置
- Apache POI 读取 Microsoft Office Excel 文档
- 在apache环境中使用 python stock 请求遇到error: [Errno 13] Permission denied
- ERROR Maven在Eclipse下 Could not resolve artifact org.apache.maven.archetype
- centos 6.4 Apache 配置 flv mp4.h264 流媒体拖动
- Messages: java.lang.NullPointerExceptionFile: org/apache/jsp/test_jsp.javaLine number: 23
- Apache Shiro 开源权限框架
- Error when sending message to topic test with key: null, value: 2 bytes with error: (org.apache.kafka.clients.producer.internals.ErrorLoggingCallback)
- apache安装错误error: APR not found解决办法