SSH查询数据库时抛出SQLGrammarException: could not execute query异常，求指教！

Question

。。。。
<%
22: Session sessionHiberant=HibernateUtil.getSession();
23: sessionHiberant.beginTransaction();
24: ArrayList result=(ArrayList)sessionHiberant.createQuery("from StudentList").list();
25: %>
。。。

错误出在24: ArrayList result=(ArrayList)sessionHiberant.createQuery("from StudentList").list();这一行
因为我把列表换成其他的时候程序是不显示错误的，求指教

root cause

org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.loader.Loader.doList(Loader.java:2223)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
org.hibernate.loader.Loader.list(Loader.java:2099)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
.........
root cause

java.sql.SQLException: ORA-00904: "STUDENTLIS0_"."FK_STUDENTLISTS_ID": 标识符无效

oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta
........
StudentList.java的内容如下：

public class StudentList {
private Long stuListId;
private Long testListId;
private Long stuInfoId;
private Long stuScore;
private StudentInfo studentinfo;
private TestList testlist;
。。。

StudentList.hbm.xml的配置如下

<class name="hibernate.bean.StudentList" table="StudentList" lazy="true">
<id name="stuListId" type="java.lang.Long">
<column name="stuListId" length = "38"/>
<generator class="sequence">
<param name="sequence">STUDENTLIST_SEQ</param>
</generator>
</id>
<property name="testListId" type="java.lang.Long">
<column name="testListId" length = "38"/>
</property>

<property name="stuInfoId" type="java.lang.Long">
<column name="stuInfoId" length = "38"/>
</property>
。。。

<many-to-one name="studentinfo" class="hibernate.bean.StudentInfo" fetch = "select">
<column name="fk_StudentLists_id"/>
</many-to-one>
。。。

Answer 1

jlsajn