三大架構整合 提示 不能進行查詢錯誤

這是拋出來的提示資訊：

HTTP Status 500 - could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

type Exception report

message could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute queryorg.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:613)org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

提示是無法進行查詢，我們可以把他產生的sql 複製在sql editer中去運行下，你就會發現錯誤了

很有可能是因為表名 或者欄位名 是sql的關鍵字引起的。

在bean的hbm.xml 檔案中給欄位 或者 表名加上迴避符就可以了。[表名]

附上一段我報錯的設定檔，修複正確的：

<?xml version="1.0" encoding="utf-8"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><!--     Mapping file autogenerated by MyEclipse Persistence Tools--><hibernate-mapping>    <class name="com.shop.bean.Order" table="[Order]" schema="dbo" catalog="Shop" dynamic-insert="true" dynamic-update="true">        <id name="id" type="java.lang.Integer">            <column name="Id" />            <generator class="native" />        </id>        <many-to-one name="product" class="com.shop.bean.Product" fetch="select">            <column name="ProductId" not-null="true" />        </many-to-one>        <many-to-one name="user" class="com.shop.bean.User" fetch="select">            <column name="UserId" not-null="true" />        </many-to-one>        <many-to-one name="convey" class="com.shop.bean.Convey" fetch="select">            <column name="ConveyId" not-null="true" />        </many-to-one>        <property name="price" type="java.lang.Double">            <column name="[Price]" scale="4" not-null="true" />        </property>        <property name="count" type="java.lang.Integer">            <column name="[Count]" not-null="true" />        </property>        <property name="money" type="java.lang.Double">            <column name="[Money]" scale="4" not-null="true" />        </property>        <property name="shipments" type="java.lang.Boolean">            <column name="Shipments" />        </property>        <property name="address" type="java.lang.String">            <column name="[Address]" not-null="true" />        </property>        <property name="receive" type="java.lang.Boolean">            <column name="Receive" />        </property>        <property name="addTime" type="java.sql.Timestamp">            <column name="AddTime" length="23" />        </property>    </class></hibernate-mapping>