hibernate native query mapping

Question

I am trying to make a native named query.I saw the link

<sql-result-set-mapping name="BookAuthorMappingXml">
   <entity-result entity-class="org.thoughts.on.java.jpa.model.Author">
    <field-result name="id" column="authorId"/>
    <field-result name="firstName" column="firstName"/>
    <field-result name="lastName" column="lastName"/>
    <field-result name="version" column="authorVersion"/>
</entity-result>

   <entity-result entity-class="org.thoughts.on.java.jpa.model.Book">
       <field-result name="id" column="id"/>
       <field-result name="title" column="title"/>
       <field-result name="author" column="author_id"/>
       <field-result name="version" column="version"/>
   </entity-result>
</sql-result-set-mapping>

the number of columns i have is more than 20.Is there is way to map all columns in one go

I am using hibernate 4.2

Are you looking for something like stackoverflow.com/a/17210746/2646526? — heenenee
– heenenee, Commented Apr 2, 2017 at 21:01
yes but using named queries and method like defined in question — coder25
– coder25, Commented Apr 3, 2017 at 4:13
something like this? github.com/kiegroup/jbpm/blob/master/jbpm-persistence/… — Alex Chernyshev
– Alex Chernyshev, Commented Apr 6, 2017 at 11:13
You could create a new Entity class that has all the fields you want and not bother describing each fieldresult. That way instead of an Object[] each row would give you a well-described class you won't even have to typecast. — coladict
– coladict, Commented Apr 7, 2017 at 10:23
I dont want to create a new entity class as the number of fields are too many and this will make me change the entire references — coder25
– coder25, Commented Apr 7, 2017 at 10:26

Abdul Rahman · Accepted Answer · 2017-04-07 10:17:16Z

2

+25

What you need is an hibernate mapping auto generation. You can follow the blog from mkyong

https://www.mkyong.com/hibernate/how-to-generate-code-with-hibernate-tools/

answered Apr 7, 2017 at 10:17

Abdul Rahman

4462 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

hibernate native query mapping

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related