Hi,
I am running the quick start example. But a exception with description "column not found: x0_0_ ". I check the query string is mangled to "select cat0_.CAT_ID as x0_0_ from CAT cat0_" from "select cat from Cat as cat". What setting I make is wrong? The following is part of the exception:

Hibernate: insert into CAT (NAME, sex, weight, CAT_ID) values (?, ?, ?, ?)
Hibernate: select cat0_.CAT_ID as x0_0_ from CAT cat0_
00:25:14,832 ERROR JDBCExceptionReporter:37 - Could not execute query
java.sql.SQLException: Column not found: x0_0_
at org.hsqldb.jdbcDriver.sqlException(Unknown Source)
at org.hsqldb.jdbcDriver.sqlException(Unknown Source)
at org.hsqldb.jdbcResultSet.findColumn(Unknown Source)
at org.hsqldb.jdbcResultSet.getString(Unknown Source)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResul
tSet.java:155)
at net.sf.hibernate.type.StringType.get(StringType.java:14)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:59)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:51)
at net.sf.hibernate.type.ManyToOneType.hydrate(ManyToOneType.java:52)
at net.sf.hibernate.type.EntityType.nullSafeGet(EntityType.java:109)
at net.sf.hibernate.impl.IteratorImpl.postNext(IteratorImpl.java:57)
at net.sf.hibernate.impl.IteratorImpl.<init>(IteratorImpl.java:43)
at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:806
)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1409)
at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:64)
at net.sf.hibernate.examples.quickstart.TestServlet.selectAllCats(TestSe
rvlet.java:85)
at net.sf.hibernate.examples.quickstart.TestServlet.doGet(TestServlet.ja
va:39)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche
rValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22
3)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:601)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:619)
at java.lang.Thread.run(Thread.java:536)


Regards,
Rice