hibernate - gathering multiple rows single column for two queries

[manish ahuja]

Hi there,

I have a scenario where in there are two queries in Hibernate something like this
i) select coldata from tablename where id=1 and ind='ABC'
ii) select coldata from tablename where id=1 and ind='XYZ'

Each will have a different output

Currently I have two queries hitting the database. Is there a way where i can reduce this to 1 query and grab both the details in one go

Let me know is there a way to better this.

[Reehan Lalkhanwar]

    
select * from (
select coldata from tablename where id=1 and ind='ABC' 
or
select coldata from tablename where id=1 and ind='XYZ' 
)

[Javid Jamae]

Maybe this:

select coldata from tablename where id=1 and ind='ABC' or ind='XYZ' 

But if you're using Hibernate, you're not selecting column data and you're not querying tables. The whole point of Hibernate is to pull back objects. You probably just want to do an HQL query that looks something like:

from MyClass where ...

[manish ahuja]

Thanks Javid,

-----------
But if you're using Hibernate, you're not selecting column data and you're not querying tables. The whole point of Hibernate is to pull back objects. You probably just want to do an HQL query that looks something like:
-----------

Yes exactly thats what I have in place. Now my question here is how do you iterate the results and identify which value I got for the query parameter "ABC" and for "XYZ" as i need to use them differently

[Javid Jamae]

Yes exactly thats what I have in place. Now my question here is how do you iterate the results and identify which value I got for the query parameter "ABC" and for "XYZ" as i need to use them differently

This is just basic Java. You get the collection back from your query and then you loop over the data.

for(MyThing myThing : resultsOfHibernateQuery)
{
  if (myThing.getSomeParameter().equals("ABC"))
  {
     ...
  }
  else
  {
    ...
  }
}