The result has the topics populated with subtopics field null and when I call getSubtopics() i get the following exception
org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.callDisposition.dto.TopicDTO.subTopics#8]
Error: [IBM][CLI Driver][DB2] SQL0206N "SUBTOPICS0_.DSPS_TPC_TPY_ID" is not valid in the context where it is used. SQLSTATE=42703
this is the sql generated
select subtopics0_.DSPS_TPC_TPY_ID as DSPS11_1_, subtopics0_.DSPS_SBTPC_TYP_ID as DSPS1_1_, subtopics0_.DSPS_SBTPC_TYP_ID as DSPS1_55_0_, subtopics0_.DSPS_SBTPC_TYP_DSC as DSPS2_55_0_, subtopics0_.DSPS_TPC_TYP_ID as DSPS3_55_0_ from CRS3DEVL.DSPS_SBTPC_TYP subtopics0_ where subtopics0_.DSPS_TPC_TPY_ID=?