How to use stored procedure in ibatis?

Question

Please Refer http://loianegroner.com/2011/03/ibatis-mybatis-working-with-stored-procedures/ — Anver Sadhat, Jul 03 '12 at 05:18

score 2 · Answer 1 · answered Jul 21 '10 at 16:09

2

Like this:

<procedure id="getUserEmail"
  parameterClass="java.lang.String" resultClass="java.lang.String">
    {call SP_getUserEmail(#username#)}
</procedure>

answered Jul 21 '10 at 16:09

Enrique

9,920
7
47
59

score 0 · Answer 2 · answered Jan 12 '12 at 08:41

It should be something like this in mybatis 3:

<update id="myProcCall" parameterType="map" statementType="CALLABLE">
    {    
        call MY_PROC(#{param1, javaType=String, jdbcType=VARCHAR, 
         mode=IN},#{param2, javaType=String, jdbcType=VARCHAR, 
         mode=IN)
     }
</update>

How to use stored procedure in ibatis?

2 Answers2