ORM map a variable to a SQL query within Hibernate

Question

I've got a simple pojo which is filled thanks to hibernate. I would like to see a variable from this pojo being mapped to a very specific SQL query and I wonder if this is possible to create such a mapping in the hibernate.xml file ?

Thanks a lot

jpkroehling · Accepted Answer · 2012-06-25 06:55:51Z

1

There's no easy way in pure JPA to do that. The best would be to use Hibernate's @Formula annotation, on which you can specify a "SQL Fragment" that should be used to get the field's data.

answered Jun 25, 2012 at 6:55

jpkroehling

14.1k1 gold badge40 silver badges40 bronze badges

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

2 Comments

Farid Over a year ago

That seems nice, is it possible to do this in the xml mapping file rather than as an annotation ?

jpkroehling Over a year ago

Yes, see 5.1.4.2 on the documentation: docs.jboss.org/hibernate/core/4.0/manual/en-US/html_single/…

Rahul Agrawal · Accepted Answer · 2012-06-25 06:53:49Z

0

Are you looking for some thing like this

String sql = "SELECT a.id As id, CONCAT(a.firstName,' ',a.lastName) AS advisorName from tableAdvis";

List<CollectionReport> collectionList = (List<CollectionReport>) getSession().createSQLQuery(sql).setResultTransformer(Transformers.aliasToBean(CollectionReport.class)).list();

Here is my CollectionReport POJO looks like

public class CollectionReport {

    private BigInteger id;
    private String advisorCode;
    private String advisorName;    
   //Getter & Setter

}

ResultTransformer will get query result and based on property name in POJO, it assigns values to it.

answered Jun 25, 2012 at 6:53

Rahul Agrawal

8,97118 gold badges50 silver badges60 bronze badges

Collectives™ on Stack Overflow

ORM map a variable to a SQL query within Hibernate

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related