Mybatis reference sql from another mapper.xml file

Question

I have written a standard select and resultMap for a table/object in one mapper.xml file and am wondering if there is a method to use this select in another mapper.xml file via the "select" parameter on Associations, Collections, etc.

can you give an example of what you want to achieve?

Michał Rybak
– Michał Rybak

2013-10-29 17:02:13 +00:00
Commented Oct 29, 2013 at 17:02 — Michał Rybak
– Michał Rybak, Commented Oct 29, 2013 at 17:02

Roman-Stop RU aggression in UA · Accepted Answer · 2013-11-02 17:04:18Z

15

Elements defined in other mapper files can be used by fully qualified identifier which includes mapper namespace.

For example you have select in mapper1.xml:

<mapper namespace="com.foo.bar.mapper.Mapper1">

  <select id="getEntity1" resultType="Entity1">
    select * form entity1
  </select>
</mapper>

It can be used in mapper2.xml:

<mapper namespace="com.foo.bar.mapper.Mapper2">

  <resultMap id="entity2ResultMap" type="Entity2">
    <association property="entity1"
                 column="entity1_id" 
                 javaType="Entity1" 
                 select="com.foo.bar.mapper.Mapper1.getEntity1"/>
  </resultMap>

</mapper>

answered Nov 2, 2013 at 17:04

Roman-Stop RU aggression in UA

16k3 gold badges52 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

Mybatis reference sql from another mapper.xml file

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