Native SQL(written in xml) result set mapping to POJO(annotation based)

Question

I'm working on a Spring MVC legacy project and currently, we are upgrading the spring(2) and hibernate(2) to latest version. Previously in the project there are sql-query and entity mappings are done in the XML files and we are upgrading the entity mapping from XML to annotation based. The problem is occurring for the entity mappings that are done on the basis of the result set of a query. I want to keep the query in the XML files only(as these are very very big queries performing joins on 4-5 tables) and just change the entity mapping. Previously the entity mapping is done like this

<class name="ClassName" table="x" mutable="false">
    <id name="id" column="id_col">
        <generator class="assigned" />
    </id>
        <property name="linkId"  ....

</class>

How will I annotate table='x' in the annotation based mapping?

P.S table="x" is not an example it is written in that way only in XML mapping and there is no table named x in DB

Could you perhaps try to add some more context as it's not very clear what the issue is. What troubles do you have when mapping the entities? — Nico Van Belle, Jun 26 '18 at 07:52
Sorry but there is not sufficient info to fix a NPE with the information given — Nico Van Belle, Jun 26 '18 at 12:18

score -1 · Answer 1 · answered Jun 26 '18 at 08:22

-1

you can use like this

@Entity
@Table(name = "X")
public class ClassName {
}

In native Query in xml

<sql-query name="findQuery">
   <return alias="ClassName" class="ClassName"/>
   select * from x
</sql-query>

answered Jun 26 '18 at 08:22

Chamly Idunil

1,848
1
18
33

Native SQL(written in xml) result set mapping to POJO(annotation based)

1 Answers1