错误信息是这样的
16:21:52,671 ERROR JDBCExceptionReporter:78 - 关键字 'order' 附近有语法错误。
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute queryCaused by: org.hibernate.exception.SQLGrammarException: could not execute queryCaused by: com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 'order' 附近有语法错误方法就这么一个:
public List findAllTest() {
log.error("com.viven.test.dao.TestDAOHibernate.findAllTest()");
List list = getHibernateTemplate().find("from Order");
return list;
}POJO类:
public class Order implements java.io.Serializable { // Fields private Integer orderId;
private Integer cusomerId;
private String ordername;配置信息: <class name="com.viven.test.domain.Order" table="order" schema="dbo" catalog="fjl">
<id name="orderId" type="java.lang.Integer">
<column name="order_id" />
<generator class="identity" />
</id>
<property name="cusomerId" type="java.lang.Integer">
<column name="cusomer_id" not-null="true" />
</property>
<property name="ordername" type="java.lang.String">
<column name="ordername" length="50" />
</property>
</class>请各位看看到底是什么错啊..弄了半天了..郁闷死了..谢谢各位了.
16:21:52,671 ERROR JDBCExceptionReporter:78 - 关键字 'order' 附近有语法错误。
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute queryCaused by: org.hibernate.exception.SQLGrammarException: could not execute queryCaused by: com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 'order' 附近有语法错误方法就这么一个:
public List findAllTest() {
log.error("com.viven.test.dao.TestDAOHibernate.findAllTest()");
List list = getHibernateTemplate().find("from Order");
return list;
}POJO类:
public class Order implements java.io.Serializable { // Fields private Integer orderId;
private Integer cusomerId;
private String ordername;配置信息: <class name="com.viven.test.domain.Order" table="order" schema="dbo" catalog="fjl">
<id name="orderId" type="java.lang.Integer">
<column name="order_id" />
<generator class="identity" />
</id>
<property name="cusomerId" type="java.lang.Integer">
<column name="cusomer_id" not-null="true" />
</property>
<property name="ordername" type="java.lang.String">
<column name="ordername" length="50" />
</property>
</class>请各位看看到底是什么错啊..弄了半天了..郁闷死了..谢谢各位了.
你查询的是Order
不过你对HIBERNATE的配置好象不熟吧,table是指定表的名称
我的表是order表,这是对的,schema也是dbo, catalog="fjl"指定数据库名为fjl都是对的
我的数据库是fjl
"from Order",请再仔细看下我贴出来的..谢谢