samshi

我在用hibernate對mysql進行分頁的方法
/**
  * 函數說明：獲得所有的信息
  * 參數說明：
  * 返回值：信息的集合
  */
 public List getProducts(final int pageSize, final int startRow) throws HibernateException { 
     return this.getHibernateTemplate().executeFind(new HibernateCallback(){

         public Object doInHibernate(Session session) throws HibernateException, SQLException {
        
             Query query=session.createQuery("FROM Products as p");
             query.setMaxResults(pageSize);
             query.setFirstResult(startRow);    
    
             List list = query.list();
       
             return list;
         }
        });

 }

運行時怎么老給出異常阿？請幫幫我看看好嗎？
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
java.sql.SQLException: Syntax error or access violation,  message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '40 products0_.game_id as game1_0_, products0_.game_name_en as game2_0_, products' at line 1"