can getter of an entity be used in hql for filter

prabuittkd · **Posted:** Thu Mar 19, 2009 7:44 am

Hi,

Can a getter method of an entity be used in hql for filter in where condition ?

like following one

Code:

class Something{
private Long id;

public Long getId(){
return id;
}

public void setId(Long id){
this.id=id;
}

[b]public String getValue(){
return "test";
}[/b]
}

for the above entity can i use following hql ?

from Something s where s.value="test"

plz hlp

nordborg · **Posted:** Thu Mar 19, 2009 9:53 am

Seems ok, assuming that you have mapped the getValue() method to a database column.

prabuittkd · **Posted:** Thu Mar 19, 2009 10:24 am

i dont have a DB column mapped...

and this is not working.

we say Hibernate is OO then i would realy except it to work all i have is a valid getter. I think Hibernate can include this for there enhancement.

nordborg · **Posted:** Thu Mar 19, 2009 10:46 am

Hibernate is an Object-Relational Mapping (ORM) tool. HQL queries are converted to SQL and processed by a relational database. The result is parsed and put together by Hibernate to build an Object representation of the data.

There is also some kind of mode that maps to XML documents, but I have zero experience with that.