运行环境:netbean 数据库:oracle运行时出现下面错误:
Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: unexpected token: from near line 1, column 13 [select u.id from insert.Test u where u.name =:name]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at insert.TestBean.queryUser(TestBean.java:70)
TestBean.java:70 的代码为 Query query = session.createQuery(queryString);queryString在前面赋值为select u.id from Test u where u.name =:nameTest为类名,映射文件Test.hbm.xml,内容如下:
<hibernate-mapping>
<class name="insert.Test" table="TEST">
<id name="id" type="java.lang.Integer">
<column name="Id"/>
<generator class="sequence">
<param name="sequence">my_seq</param>
</generator>
</id>
<property name="name" type="java.lang.String">
<column length="50" name="NAME" not-null="false"/>
</property>
</class>
</hibernate-mapping>各位大哥救命啊,初学hibernate,对这个错误看了几天很不理解啊,求教各位大哥错误大概是出在哪里?
Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: unexpected token: from near line 1, column 13 [select u.id from insert.Test u where u.name =:name]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at insert.TestBean.queryUser(TestBean.java:70)
TestBean.java:70 的代码为 Query query = session.createQuery(queryString);queryString在前面赋值为select u.id from Test u where u.name =:nameTest为类名,映射文件Test.hbm.xml,内容如下:
<hibernate-mapping>
<class name="insert.Test" table="TEST">
<id name="id" type="java.lang.Integer">
<column name="Id"/>
<generator class="sequence">
<param name="sequence">my_seq</param>
</generator>
</id>
<property name="name" type="java.lang.String">
<column length="50" name="NAME" not-null="false"/>
</property>
</class>
</hibernate-mapping>各位大哥救命啊,初学hibernate,对这个错误看了几天很不理解啊,求教各位大哥错误大概是出在哪里?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货