Herbarnate 的映射文件.hbm.xml自动生成表报错。

最新推荐文章于 2019-08-08 00:42:16 发布

wxinpeng

最新推荐文章于 2019-08-08 00:42:16 发布

阅读量213

点赞数

分类专栏： struts2随笔文章标签： XML Hibernate SQL Server MySQL SQL

struts2随笔专栏收录该内容

23 篇文章 0 订阅

订阅专栏

用hbm.xml映射文件自动生成表报错!

严重: Unsuccessful: create table alipay_table (id integer not null auto_increment, partner varchar(50), key varchar(50), seller_email varchar(50), createTime varchar(30), updateTime varchar(30), updateAdmin varchar(30), primary key (id))
2008-11-4 16:18:17 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: 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 'varchar(50), seller_email varchar(50), createTime varchar(30), updateTime varcha' at line 1

配置映射文件如下：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="org.deal.model">
	<class name="AliPay" table="alipay_table">
		<id name="id" column="id">
			<generator class="identity" />
		</id>
		<property name="partner" column="partner" type="string" length="50" />
		<property name="key" column="key" type="string" length="50" />
		<property name="seller_email" column="seller_email" type="string" length="50" />
		<property name="createTime" column="createTime" type="string" length="30" />
		<property name="updateTime" column="updateTime" type="string" length="30" />
		<property name="updateAdmin" column="updateAdmin" type="string" length="30" />
	</class>
</hibernate-mapping>

错误为：key 是关键字。所以生成的SQL不能执行！！报错。