hibernate问题，请各位大侠帮忙看下！谢了
tomcat提示错误：
javax.servlet.ServletException: net.sf.hibernate.exception.SQLGrammarException: Could not execute query
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
testService.java:
/*
* Created on 2005-10-2
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Style - Code Templates
*/
package com.test.hibernate;
import net.sf.hibernate.*;
import net.sf.hibernate.HibernateException;
import java.util.List;
/**
* @author xie
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class TestService {
private static TestService instance = null;
private TestService(){}
/**
* 得到TestService的单态实例
* @return <code>TestService</code> singleton.
*/
public static synchronized TestService getInstance(){
if (instance == null)
{
instance = new TestService();
}
return instance;
}
public List findAllProduct(){
Session session = null;
try{
session = SessionFactory.currentSession();
Query query = session.createQuery("select c from Product as c");
return query.list();
}catch(HibernateException e){
throw new RuntimeException(e);
}
}
}
Product.html.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<!-- Created Sun Oct 02 14:49:09 PDT 2005 -->
<hibernate-mapping package="com.test.hibernate">
<class name="Product" table="product">
<id name="id" column="id" type="java.lang.Integer">
<generator class="increment"/>
</id>
<property name="title" column="title" type="java.lang.String" />
<property name="comm" column="comm" type="java.lang.String" />
<property name="spic" column="spic" type="java.lang.String" />
<property name="dpic" column="dpic" type="java.lang.String" />
<property name="keys" column="keys" type="java.lang.String" />
<property name="publishName" column="publish_name" type="java.lang.String" />
<property name="publishUrl" column="publish_url" type="java.lang.String" />
<property name="publishDate" column="publish_date" type="java.util.Date" />
<property name="publishHot" column="publish_hot" type="java.lang.Byte" not-null="true" />
<property name="publish" column="publish" type="java.lang.Byte" not-null="true" />
<property name="hit" column="hit" type="java.lang.String" />
<property name="maxvalue" column="maxvalue" type="java.lang.Integer" />
<property name="shtml" column="shtml" type="java.lang.Byte" not-null="true" />
</class>
</hibernate-mapping>
Product.java:
/*
* Created Sun Oct 02 14:47:45 PDT 2005 by MyEclipse Hibernate Tool.
*/
package com.test.hibernate;
import java.io.Serializable;
/**
* A class that represents a row in the 'product' table.
* This class may be customized as it is never re-generated
* after being created.
*/
public class Product
extends AbstractProduct
implements Serializable
{
/**
* Simple constructor of Product instances.
*/
public Product()
{
}
/**
* Constructor of Product instances given a simple primary key.
* @param id
*/
public Product(java.lang.Integer id)
{
super(id);
}
/* Add customized code below */
}
问题点数：20、回复次数：3Top
1 楼keiy（）回复于 2005-10-02 18:55:54 得分 0
提示错误是不能执行查询:
首先检查你的数据库
有无Product表,它是否含c字段.最简单的,在数据库的SQL中执行
select c from ProductTop
2 楼mrcham（小平）回复于 2005-10-02 20:33:04 得分 0
hql写错了吧Top
3 楼wangdongzjk（东）回复于 2005-10-07 03:54:10 得分 0
from Product就可以了Top
相关问题
- servlet 调用hibernate报错?请各位帮帮忙.
- 烦请各位指点：关于spring,struts,hibernate的问题
- Hibernate的初级问题，请各位老大帮忙啊
- hibernate问题报错。。。。。。请各位大虾相助！有分贡上
- 有关hibernate的最简单问题，请各位帮忙！！！
- 请教各位做struts,spring,hibernate使用什么开发工具？
- 请教各位，谢谢!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 各位大虾：救命呀!我用spring+hibernate出错了，出错信息如下，请各位大虾救命!
- 急！请各位大虾帮忙解决！有关hibernate的！快快进！
- 初学hibernate，碰到的第一个问题，请各位达人指点迷津~~
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
