Hi,

Here's my code:
String sqlQuery = "select CE.* from table CE";
sqlQuery += " where name = :name1";
Query query = sess.createSQLQuery(sqlQuery,"CE",t1.class);
query.setParameter("name1", name1);

This throws an error :
net.sf.hibernate.exception.SQLGrammarException: error performing findBySQL


Is this because I am setting alias to table but in where clause I am directly using column name without the alias name. So is it compulsory to use the alias name while accessing the column?