How do I create an object for Hibernate's query response?

Question

Using an object that extends HibernateDaoSupport, I ran a query using this right here:

List<Object> trialList2 = getSession().createSQLQuery(trialQuery2).list();

Where trialQuery2 is just some query that returned a single row. I got back a list with one Object on it, which when inspected in Eclipse looks like this:

[some, random, data]

I'd like to create an Object that can accommodate what I got back from the query, but a simple Javabean object that can has those fields doesn't seem to work. Does anyone know what kind of object I would have to make to be able to access those values?

kosa · Accepted Answer · 2012-12-29 18:26:39Z

2

It would be actually Object[] not Object

List<Object[]> trialList2

Based on columns in your select query, you get values from index

Let us say, if your query is select firstname, lastname from employee;

Object[0] would be firstname

Object[1] would be lastname.

As per documentation :

These will return a List of Object arrays (Object[]) with scalar values for each column in the table

answered Dec 29, 2012 at 18:26

kosa

66.7k15 gold badges134 silver badges170 bronze badges

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

Comments

Ramaraj Karuppusamy · Accepted Answer · 2012-12-29 18:28:59Z

0

U can replace any class name for BEANCLASSNAME

List<BEANCLASSNAME> trialList2 = getSession().createSQLQuery(trialQuery2).setResultTransformer(new AliasToBeanResultTransformer(BEANCLASSNAME.class)).list();

answered Dec 29, 2012 at 18:28

Ramaraj Karuppusamy

2,3605 gold badges24 silver badges36 bronze badges

Collectives™ on Stack Overflow

How do I create an object for Hibernate's query response?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related