How to Call Stored Procedures from SQL using MyBatis

Question

I've got a working program in Java which is using SQLServer as DB. I know how to use the 'normal' way of using MyBatis like:

<select id="getAllWeapons" resultType="String" parameterType="Map">
        select distinct weaponId 
        from WeaponTab;
</select>

However Im curious if Im able to call Stored Procedures existing in the SQL database that others wrote to make my life easier.

Any documentation or tips to the right direction will do.

I did some digging and saw this:

<select id = "callById" resultMap = "result" parameterType = "Student" statementType = "CALLABLE">
      {call read_record_byid(#{id, jdbcType = INTEGER, mode = IN})}
</select>

So does it mean the keyword to using Stored Procedures is call?

Here are executable demos : a simple one and a complex one.

ave
– ave

2019-10-29 15:23:32 +00:00
Commented Oct 29, 2019 at 15:23 — ave
– ave, Commented Oct 29, 2019 at 15:23

Kazuki Shimizu · Accepted Answer · 2019-10-29 15:27:58Z

1

Yes. It is definition as specification of JDBC(CallableStatement). See https://docs.oracle.com/javase/8/docs/api/java/sql/CallableStatement.html.

answered Oct 29, 2019 at 15:27

Kazuki Shimizu

4093 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Call Stored Procedures from SQL using MyBatis

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related