hibernate query result to a predefined object?

Question

It is possible in hibernate to get a result of a query to a mapped db object.

Is it possible to create a non-persistent object and get the query result into this object?

for example

session.createSQLQuery(select a,b,c from table).list.addEntity(myclass.class)

if myclass is:

public class myclass{

private int a;

private int b;

private int c; 
.
.
.
}

axtavt · Accepted Answer · 2011-05-18 13:28:57Z

4

You can use AliasToBeanResultTransformer:

session.createSQLQuery("select a,b,c from table")
    .setResultTransformer(new AliasToBeanResultTransformer(myclass.class))
    .list();

answered May 18, 2011 at 13:28

axtavt

243k42 gold badges518 silver badges486 bronze badges

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

3 Comments

AAaa Over a year ago

how can i do it if 'a' is a column with a foreign key to another table, and i want that table's records fetched into an object, but the object is also a non-persistent object?

axtavt Over a year ago

@dan: I think you'll need to create a custom ResultTransformer.

tomasb Over a year ago

this doesn't work for me, trying "select x as someValue ..." and i get exception telling no SOMEVALUE setter found, traced down discovered it really looks for setSOMEVALUE case sensitive :(

matt b · Accepted Answer · 2011-05-18 13:28:18Z

0

No, Hibernate will only work with classes that are mapped ahead of time.

answered May 18, 2011 at 13:28

matt b

140k66 gold badges287 silver badges352 bronze badges

Collectives™ on Stack Overflow

hibernate query result to a predefined object?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related