Handling nested levels of Jooq POJOs

[Kannan Ekanath]

Hello,

We have a full blown project built on Jooq 3.13. We work with generated POJOs, DAOs and so on. The entities have in theory one to many mappings. So Level1EntityPOJO has many Level2EntityPOJO (mapped by a foreign key) which has many Level3EntityPOJO. All these POJOs are JOOQ generated. 

I have read the two links https://arnaudroger.github.io/blog/2017/02/27/jooq-one-to-many.html and https://arnaudroger.github.io/blog/2017/03/02/jooq-one-to-many-without-dto.html. 

Specifically I have three levels of entities I want to fetch in one go (I am okay with having a DTO). The first link only shows two levels with a DTO and the next link shows three levels without a DTO. 

I designed my DTO like below

class Level1EntityDTO {

    private Level1EntityPOJO level1EntityPOJO;

    private Collection<Level2EntityDTO> level2EntityDTOs;

}

class Level2EntityDTO {

    private Level2EntityPOJO level2EntityPOJO;

    private Collection<Level3EntityPOJO> level3EntityPOJOs; 

}

and then my service which looks like this 

SelectQueryMapper<FullPaymentSchedule> scheduleSelectQueryMapper = SelectQueryMapperFactory.newInstance().newMapper(Level1EntityDTO.class)

When I run this I get errors like

java.lang.ClassFormatError: Duplicate field name "factory_level2EntityDTOs" with signature "Lorg.simpleflatmapper.map.getter.ContextualGetterBiFunction;" in class file org/simpleflatmapper/reflect/generated/....

Is this something that can be easily addressed? (Or am I doing something wrong?)