Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
[a] prom desciption
I am tryign to try out createSQLQuery
to access a colum from database.

I get invalid columname sql error.
I am not sure what's going worng here.

i wrote a simple query to get
uowstatus value form unitofwork table.

i mapped the hibernate column name.

session.createSQLQury(select uow.uowstatus as {uow.uowstatus} from
ngvUnitofwork {uow},
"uow",
ngvUnitofwork.class).list();

really appreciate your help inidentifyinght issue

Hibernate version: 2.1.7

Mapping documents:
<property
name="uowstatus"
type="java.lang.String"
column="UOWSTATUS"
length="15"
/>

Code between sessionFactory.openSession() and session.close():
session.createSQLQuery(
"select uow.uowstatus as {uow.uowstatus}" +
" FROM ngv_unitofwork {uow}" ,
"uow",
NgvUnitofwork.class) .list();

Full stack trace of any exception that occurs:
15:43:54,254 INFO [STDOUT] Hibernate: select uow.uowstatus as UOWSTATUS0_ FROM
ngv_unitofwork uow
15:43:54,254 WARN [JDBCExceptionReporter] SQL Error: 17006, SQLState: null
15:43:54,254 ERROR [JDBCExceptionReporter] Invalid column name
15:43:54,254 WARN [JDBCExceptionReporter] SQL Error: 17006, SQLState: null
15:43:54,254 ERROR [JDBCExceptionReporter] Invalid column name
15:43:54,254 ERROR [JDBCExceptionReporter] SQLException occurred
java.sql.SQLException: Invalid column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.j
ava:6240)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl
.java:1557)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:148
2)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResul
tSet.java:216)
at net.sf.hibernate.type.StringType.get(StringType.java:18)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
at net.sf.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:352)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:203)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
at net.sf.hibernate.loader.Loader.list(Loader.java:946)
at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92)
at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3802)
at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
at com.voxware.orm.dao.NgvUnitofworkDAO.getUserTruck(NgvUnitofworkDAO.ja
va:448)
at com.voxware.assignment.commands.SystemUow.doBusinessMethod(SystemUow.
java:121)
at com.voxware.framework.commands.SimpleEJBCommand.execute(SimpleEJBComm
and.java:305)
at com.voxware.framework.modules.EJBProcessor.process(EJBProcessor.java:
82)
at com.voxware.framework.modules.Executor.process(Executor.java:155)
at com.voxware.framework.workflow.presentation.conditions.ValidCommandCo
ndition.passesCondition(ValidCommandCondition.java:253)
at com.opensymphony.workflow.AbstractWorkflow.passesCondition(AbstractWo
rkflow.java:870)
at com.opensymphony.workflow.AbstractWorkflow.passesConditions(AbstractW
orkflow.java:904)
at com.opensymphony.workflow.AbstractWorkflow.passesConditions(AbstractW
orkflow.java:902)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1281)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.voxware.framework.workflow.SimpleWorkflow.doAction(SimpleWorkflow
.java:75)
at com.voxware.framework.workflow.HierarchicalWorkflow.traverseWorkflow(
HierarchicalWorkflow.java:178)
at com.voxware.framework.workflow.HierarchicalWorkflow.createAndTraverse
Workflow(HierarchicalWorkflow.java:116)
at com.voxware.framework.workflow.presentation.functions.TraverseSubsidi
aryWorkflow.execute(TraverseSubsidiaryWorkflow.java:88)
at com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWo
rkflow.java:1229)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1313)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.voxware.framework.workflow.SimpleWorkflow.doAction(SimpleWorkflow
.java:75)
at com.voxware.framework.workflow.HierarchicalWorkflow.traverseWorkflow(
HierarchicalWorkflow.java:178)
at com.voxware.framework.workflow.HierarchicalWorkflow.createAndTraverse
Workflow(HierarchicalWorkflow.java:116)
at com.voxware.framework.workflow.presentation.functions.TraverseSubsidi
aryWorkflow.execute(TraverseSubsidiaryWorkflow.java:88)
at com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWo
rkflow.java:1229)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1313)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.voxware.framework.workflow.SimpleWorkflow.doAction(SimpleWorkflow
.java:75)
at com.voxware.framework.workflow.HierarchicalWorkflow.traverseWorkflow(
HierarchicalWorkflow.java:178)
at com.voxware.framework.workflow.HierarchicalWorkflow.run(HierarchicalW
orkflow.java:71)
at java.lang.Thread.run(Thread.java:534)
15:43:54,264 INFO [STDOUT] net.sf.hibernate.JDBCException: SQLException occurre
d
at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3805)
at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
at com.voxware.orm.dao.NgvUnitofworkDAO.getUserTruck(NgvUnitofworkDAO.ja
va:448)
at com.voxware.assignment.commands.SystemUow.doBusinessMethod(SystemUow.
java:121)
at com.voxware.framework.commands.SimpleEJBCommand.execute(SimpleEJBComm
and.java:305)
at com.voxware.framework.modules.EJBProcessor.process(EJBProcessor.java:
82)
at com.voxware.framework.modules.Executor.process(Executor.java:155)
at com.voxware.framework.workflow.presentation.conditions.ValidCommandCo
ndition.passesCondition(ValidCommandCondition.java:253)
at com.opensymphony.workflow.AbstractWorkflow.passesCondition(AbstractWo
rkflow.java:870)
at com.opensymphony.workflow.AbstractWorkflow.passesConditions(AbstractW
orkflow.java:904)
at com.opensymphony.workflow.AbstractWorkflow.passesConditions(AbstractW
orkflow.java:902)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1281)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.voxware.framework.workflow.SimpleWorkflow.doAction(SimpleWorkflow
.java:75)
at com.voxware.framework.workflow.HierarchicalWorkflow.traverseWorkflow(
HierarchicalWorkflow.java:178)
at com.voxware.framework.workflow.HierarchicalWorkflow.createAndTraverse
Workflow(HierarchicalWorkflow.java:116)
at com.voxware.framework.workflow.presentation.functions.TraverseSubsidi
aryWorkflow.execute(TraverseSubsidiaryWorkflow.java:88)
at com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWo
rkflow.java:1229)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1313)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.voxware.framework.workflow.SimpleWorkflow.doAction(SimpleWorkflow
.java:75)
at com.voxware.framework.workflow.HierarchicalWorkflow.traverseWorkflow(
HierarchicalWorkflow.java:178)
at com.voxware.framework.workflow.HierarchicalWorkflow.createAndTraverse
Workflow(HierarchicalWorkflow.java:116)
at com.voxware.framework.workflow.presentation.functions.TraverseSubsidi
aryWorkflow.execute(TraverseSubsidiaryWorkflow.java:88)
at com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWo
rkflow.java:1229)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1313)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(Abstrac
tWorkflow.java:1520)
at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.
java:551)
at com.voxware.framework.workflow.SimpleWorkflow.doAction(SimpleWorkflow
.java:75)
at com.voxware.framework.workflow.HierarchicalWorkflow.traverseWorkflow(
HierarchicalWorkflow.java:178)
at com.voxware.framework.workflow.HierarchicalWorkflow.run(HierarchicalW
orkflow.java:71)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Invalid column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.j
ava:6240)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl
.java:1557)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:148
2)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResul
tSet.java:216)
at net.sf.hibernate.type.StringType.get(StringType.java:18)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
at net.sf.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:352)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:203)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
at net.sf.hibernate.loader.Loader.list(Loader.java:946)
at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92)
at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3802)

Name and version of the database you are using:
orcale 9

The generated SQL (show_sql=true):
15:43:54,254 INFO [STDOUT] Hibernate: select uow.uowstatus as UOWSTATUS0_ FROM
ngv_unitofwork uow

Debug level Hibernate log excerpt:
[code][/code][/i]