how to get data from alias

[jay lai]

I have a query need to get the score from the text search, since the score is just in the select statement, it is not part of the table columns?

First of all: the POJO represent the table
public class TableA
{
private String firstName;
//getter-setter method
 
private String location;
//getter-setter method
 
private String score;
//getter-setter method
}

Then I have a hibernate.hbm.xml

<hibernate-mapping>
<property name="firstName" column="FIRSTNAME" />
<property name="location" column="LOCATION" />

Then in my hibernateDAO
[code]
SQLquery query = session.createSQLQuery("select tableA.*, score(1) from tableA where contains (location, 'string', 1) > 0")
.addEntity(TableA.class);
[code]

It works but the score is NULL, how do I get the score back, I try to use the addScalar but It is not working

Thanks in advance if you can help!!!

[jay lai]

HI, can anyone please help, I really need this to be resolve

basically, I do a

SQLQuery = session.createSQLQuery(select table_name.*, score(1) as score from table_name where contains(column1, 'test', 1)>0
 
The score(1) is the extra value I need to get back from the query, but it is not part of the mapping xml to the table. 
 
How do I approach this? Please giving me some suggestion.