如何从MyBatis Java调用存储过程？(How to call a stored procedure from MyBatis Java?)

 我收到错误： 
 
 
 
 org.mybatis.spring.MyBatisSystemException：嵌套异常是org。 阿帕奇。 ibatis的。 exceptions.PersistenceException： 
 
 
 和 
 
 
 
 java.lang.IllegalArgumentException：映射语句集合不包含..的值。“ 
 
 
 当我使用Java从mybatis调用存储过程时。 
 
 我使用PostgreSQL作为数据库和Spring MVC框架。 为此，我的DAO类调用存储过程是： 
 
Orders orders=new Orders();
 
 值以编程方式设置为可变顺序。 
 
Integer insert= getSqlSession().insert("records",orders);**
 
 我的mybatis文件如下所示： 
 
<insert id="records" parameterType="Orders" statementType="CALLABLE">
 {call fn_records_tbl(#{rId,javaType=Integer,jdbcType=INTEGER,mode=IN},#{state,javaType=String,jdbcType=CHAR,mode=IN},#{uId,javaType=Integer,jdbcType=INTEGER,mode=IN},#{status,javaType=String,jdbcType=CHAR,mode=IN})}
</insert>
 
 我的存储过程的语法是： 
 
CREATE OR REPLACE FUNCTION fn_records_tbl(rId integer, state character,uId integer, status character)

RETURNS void AS

$BODY$
DECLARE

    -- my code
BEGIN

    -- my code
END

$BODY$

LANGUAGE plpgsql VOLATILE
COST 100;

ALTER FUNCTION fn_records_tbl(integer, character, integer, character)
OWNER TO mydba;
 
 和我的实体类传递参数是： 
 
 public class Orders implements Serializable {

  private static final long serialVersionUID = 267216928694677437L;
  private Integer uId;
  private Integer rId;
  private String status;
  private String state;

     // here are my setter and getter
 }

I am getting the error:
 
 
 
org.mybatis.spring.MyBatisSystemException: nested exception is org. apache. ibatis. exceptions.PersistenceException: 
 
 
and
 
 
 
java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for .." 
 
 
when I call stored procedure from mybatis using Java.
 
I am using PostgreSQL as a database and a Spring MVC framework. For this, my DAO class calling the stored procedure is: 
 
Orders orders=new Orders();
 
Values are set in orders variable programatically.
 
Integer insert= getSqlSession().insert("records",orders);**
 
My mybatis file looks like this:
 
<insert id="records" parameterType="Orders" statementType="CALLABLE">
 {call fn_records_tbl(#{rId,javaType=Integer,jdbcType=INTEGER,mode=IN},#{state,javaType=String,jdbcType=CHAR,mode=IN},#{uId,javaType=Integer,jdbcType=INTEGER,mode=IN},#{status,javaType=String,jdbcType=CHAR,mode=IN})}
</insert>
 
My stored procedure syntax is:
 
CREATE OR REPLACE FUNCTION fn_records_tbl(rId integer, state character,uId integer, status character)

RETURNS void AS

$BODY$
DECLARE

    -- my code
BEGIN

    -- my code
END

$BODY$

LANGUAGE plpgsql VOLATILE
COST 100;

ALTER FUNCTION fn_records_tbl(integer, character, integer, character)
OWNER TO mydba;
 
and my entity class for passing parameters is:
 
 public class Orders implements Serializable {

  private static final long serialVersionUID = 267216928694677437L;
  private Integer uId;
  private Integer rId;
  private String status;
  private String state;

     // here are my setter and getter
 }

原文：https://stackoverflow.com/questions/12257921