Forums Register Login

Hibernate Query...

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
It should be a List of Object arrays.
+Pie Number of slices to send: Send
how do i downcast that?
+Pie Number of slices to send: Send
Hi,

You should cast to the pojo that you have defined for that table.
For example for employee table you would have defined getters and setters in pojo/javabean. you need to cast it to that type.

Hope it helps
Oh. Hi guys! Look at this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1255 times.
Similar Threads
Using Scalars in Hibernate
Problem with Hibernate
problem with Hibernate and table named "users"
Hibernate query with Hardcoded result
can't cast the first element of an Object[] to String -- results of Hibernate Native SQL query
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 04:57:48.