Hibernate query help

[jaisai vijay]

Hi,

I have a situation where I need to check values against null. I have three columns(declared as NUMBER in database) need to write a select query in hql. I was trying set query strings some times there will be null value when there is a null value it throws me null pointer exception.

please help me in this.

Thanks,

[Pradeep Kumar]

Can you please update the code snippet?

[jaisai vijay]

Hi,

Here is the sample code and I declare id2 and id3 as null here for example some times there might be a value but my problem is in this scenario

 
boolean isExisted = false;
Long id1=2;
Long id2=null;
Long id3=null;

Query query = session.CreateQuery("select this_id from Combo where first_id= :id1 and second_id= :id2 and third_id= :id3 ");
query.setLong("id1",id1);
query.setLong("id2",id2);
query.setLong("id3",id3);

List list = query.list();

for(Iterator iter=list.iterator();iter.hasNext();){
     Object o = iter.next();
     if(o != null && o.length >0){
         isExisted = true;
     }else{
         isExisted = false;
}

return isExisted;
}

Please help me to solve this issue.