Nested mapping of object using annotations in Mybatis

Question

I have a POJO like this

 public class Application
{
  private String dcn;
  private Party applicant;
  private Date createdDateTime;
  private NamedValue[] flags;
  // containing getter and setters
  }
public class Party
{
  private String lastName;
  private String rfc;
  // containing getter and setters..
  }

And my table columns are..

dcn,applicantLastName,applicantRFC,createdDateTime,flag

all are varchar type. I am using annotations to get data from the above table and set it to POJO using below Query.

@Select("SELECT dcn,applicantLastName,applicantRFC,createdDateTime,flag FROM DnA_Application WHERE dcn=#{dcn}")
  List<Application> getByProc(int proc);

I am not getting data for Party bean from table using above config .Please help.

Roman-Stop RU aggression in UA · Accepted Answer · 2018-12-10 10:35:53Z

3

There's no way to map the result of the join using annotations. This is not supported in mybatis. Here's a quotation from the documentation:

You will notice that join mapping is not supported via the Annotations API. This is due to the limitation in Java Annotations that does not allow for circular references

One way to do mapping is to define a result map in the xml and reference it via @ResultMap.

mapper.xml:

<resultMap id="ApplicationResultMap" type="Application" autoMapping="true">
   <id property="dcn" column="dcn"  />
   <association property="party" javaType="Party" resultMap="PartyResultMap" columnPrefix="applicant"/>
</resultMap>

In mapper interface:

@Select("SELECT dcn,applicantLastName,applicantRFC,createdDateTime,flag FROM DnA_Application WHERE dcn=#{dcn}")
@ResultMap("ApplicationResultMap")
List<Application> getByProc(int proc);

answered Dec 10, 2018 at 10:35

Roman-Stop RU aggression in UA

16k3 gold badges52 silver badges59 bronze badges

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

2 Comments

user10759930 Over a year ago

Thanks a lot for your reponse .

Pino Over a year ago

@AtulSingh, if this answer solves your problem you should formally accept it: see stackoverflow.com/help/someone-answers

Collectives™ on Stack Overflow

Nested mapping of object using annotations in Mybatis

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related