I have to select two columns from a table.
The query looks like this.
I just need to get the values of a and b.
I used the following in hibernate.
List results=session.createSQLQuery("select a as value,b as key from table")
.addScalar("value",Hibernate.STRING)
.addScalar("key",Hibernate.STRING).list();
Remember that the above query gives 3 rows.
what is that i get in results after the query is executed?
It is not a list of lists.I figured out that myself.
Thanks in advance.
Shrimon.
The query looks like this.
I just need to get the values of a and b.
I used the following in hibernate.
List results=session.createSQLQuery("select a as value,b as key from table")
.addScalar("value",Hibernate.STRING)
.addScalar("key",Hibernate.STRING).list();
Remember that the above query gives 3 rows.
what is that i get in results after the query is executed?
It is not a list of lists.I figured out that myself.
Thanks in advance.
Shrimon.