Hi,

I am a newbie. I write my SQl query in hbm.xml and the path of the hbm is defined in hibernate.cfg.xml. But the issue is, I have to mention all the column names even if I wish to use 2 of them.

sample of query in hbm.xml
Suppose there are only 2 columns in the table:

<sql-query name="fetchparameters">
<return alias="databasefile" class="src.DatabaseFile"/>
SELECT {databasefile}.ROLEID AS {databasefile.ROLEID }
,{databasefile}.ROLENAME AS {databasefile.ROLENAME}
FROM DatabaseFile{databasefile}
WHERE {databasefile}.ROLEID LIKE :ROLEID AND
{databasefile}.ROLENAME LIKE :ROLENAME
</sql-query>

DatabaseFile is a java file where all the getters/setters are present.

Now, if I want only 1 column, it gives me an error:


org.hibernate.exception.SQLGrammarException: could not execute query
Caused by: java.sql.SQLException: An undefined column name was detected.



Kindly guide me...