I am trying to execute the following piece of code, but hibernate reports an sql exception.

But when i execute the hibernate generated sql query in oracle, it works fine.
Any thoughts highly appreciated.

Hibernate version:
Hibernate 3.0.1
Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.starwood.valhalla.inventory.hibernate.schema">

<class name="SleepingRoomProduct" table="PROP_PRDT_SLPG_RM">

<id name="propPrdtId">
<column name="PROP_PRDT_ID" length="15" not-null="true"/>
</id>


<property name="slpgRmDfltInvBaseQty">
<column name="SLPG_RM_DFLT_INV_BASE_QTY" length="9" not-null="false" />
</property>
</class>

</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
String propPrdSlpgRmSql ="select " +
"p.SLPG_RM_DFLT_INV_BASE_QTY as {obj.slpgRmDfltInvBaseQty} " +
"from PROP_PRDT_SLPG_RM p " +
"where p.PROP_PRDT_ID=:propPrdtId ";

SQLQuery propPrdSlpRoomQry = session.createSQLQuery(propPrdSlpgRmSql);
propPrdSlpRoomQry.addEntity("obj",SleepingRoomProduct.class);
propPrdSlpRoomQry.setLong("propPrdtId",productVO.getProductID().productidPK);

Full stack trace of any exception that occurs:
Hibernate: select p.SLPG_RM_DFLT_INV_BASE_QTY as SLPG2_1_0_ from PROP_PRDT_SLPG_RM p where p.PROP_PRDT_ID=?

May 2, 2005 5:47:27 PM org.hibernate.util.JDBCExceptionReporter
WARNING: SQL Error: 17006, SQLState: null
May 2, 2005 5:47:27 PM org.hibernate.util.JDBCExceptionReporter
SEVERE: Invalid column name
e: could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1518)
at org.hibernate.loader.Loader.list(Loader.java:1498)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:103)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1340)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:151)
at com.starwood.valhalla.inventory.dao.ProductHibernateDAO.getSleepingRoomProduct(ProductHibernateDAO.java:497)
at com.starwood.valhalla.inventory.dao.ProductHibernateDAO.getProductDetails(ProductHibernateDAO.java:94)
at com.starwood.valhalla.inventory.dao.ProductHibernateDAO.main(ProductHibernateDAO.java:572)
Caused by: java.sql.SQLException: Invalid column name
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:3047)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1861)
at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1617)
at org.hibernate.type.LongType.get(LongType.java:26)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:77)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:68)
at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:691)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:280)
at org.hibernate.loader.Loader.doQuery(Loader.java:387)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:206)
at org.hibernate.loader.Loader.doList(Loader.java:1515)
... 7 more
Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

message is clear : invalid column name - it isn't hibernate problem
You haven't column SLPG_RM_DFLT_INV_BASE_QTY or column PROP_PRDT_ID
in table PROP_PRDT_SLPG_RM
maybe you set wrong schema (username) in cfg file

hi snpesnpe,

In that case hibernate generated query works on sql editor.

If the configuration file is wrong then the generated sql file also
should be wrong is it???

Um, addEntity() takes an entity (i.e. an instance of an entity). Not a class.

It does expects a class.
By the way what do you mean by entity in the current context
Please clarify

addEntity expects a alias name and a class or entity-name ..not an instance of an entity.

I tried that too, still the same....

go look at the doc for native sql queries.

you need to return ALL columns for a given entity/class when using addEntity.