Hibernate Community • View topic - How to write Externalized native sql query in hibernate

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to write Externalized native sql query in hibernate

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

dil.ravuri

Post subject: How to write Externalized native sql query in hibernate

Posted: Wed May 25, 2011 1:03 am

Newbie

Joined: Tue May 24, 2011 8:12 am
Posts: 2

HI All,
I have table with 30 columns and I mapped those to one entity value object. Now I need to get only three columns from that table. For that I had written One externalized native sql query in hbm file. I need to get these result in to my customized another value object, that value object having those properties only.

How to write the externalized query in hbm file and how execute in DAO class.

Any way I need to return my customized Value object.

Can any one help me Plz.....

Thanks in Advance
Dileep

Top

glenpeterson

Post subject: Re: How to write Externalized native sql query in hibernate

Posted: Wed May 25, 2011 10:38 am

Beginner

Joined: Mon Jul 28, 2008 4:36 pm
Posts: 24

Why would you map 30 columns to one data value if you want to retrieve data from those columns individually? I'd be inclined to map them individually, then write a little routine in Java:

Code:

public String concat30Values() {
    StringBuilder sB = new StringBuilder();
    sB.append(col1);
    sB.append(col2);
    ...
    return sB.toString();
}

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum