2.1.6
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping SYSTEM "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>
<class name="lyo.test.bean.Trade" table="tradetest">
<id name="trade_id" column="trade_id">
<generator class="native"/>
</id>
<property name="trade_name" column="trade_name"/>
<property name="trade_desc" column="trade_desc"/>
</class>
</hibernate-mapping>
Configuration cfg=new Configuration().configure();
sf=cfg.buildSessionFactory();
new SchemaExport(cfg).create(true,true);
2004-8-31 10:11:20 net.sf.hibernate.connection.DriverManagerConnectionProvider c
onfigure
信息: connection properties: {user=yashnoo, password=yashnoo}
drop table if exists tradetest
create table tradetest (
trade_id varchar(255) not null auto_increment,
trade_name varchar(255),
trade_desc varchar(255),
primary key (trade_id)
)
2004-8-31 10:11:20 net.sf.hibernate.tool.hbm2ddl.SchemaExport execute
seve: Unsuccessful: create table tradetest (trade_id varchar(255) not null auto_
increment, trade_name varchar(255), trade_desc varchar(255), primary key (trade_
id))
2004-8-31 10:11:20 net.sf.hibernate.tool.hbm2ddl.SchemaExport execute
severity: Invalid argument value: Incorrect column specifier for column 'trade_id'
2004-8-31 10:11:20 net.sf.hibernate.tool.hbm2ddl.SchemaExport execute
info: schema export complete
2004-8-31 10:11:20 net.sf.hibernate.connection.DriverManagerConnectionProvider c
lose
info: cleaning up connection pool: jdbc:mysql://localhost:3306/powersql
3.23.56
info
JavaBean PO is:
Code:
package lyo.test.bean;
public class Trade{
private String trade_id;
private String trade_name;
private String trade_desc;
public String getTrade_id(){
return this.trade_id;
}
public void setTrade_id(String trade_id){
this.trade_id=trade_id;
}
public void setTrade_name(String trade_name){
this.trade_name=trade_name;
}
public String getTrade_name(){
return this.trade_name;
}
public void setTrade_desc(String trade_desc){
this.trade_desc=trade_desc;
}
public String getTrade_desc(){
return this.trade_desc;
}
}
Hi everyone:
I want to create table use Hibernate SchemaExport . But I found that If I use native generator create string id hibernate can't create table. And it report error.
The problem is exactly as the same as this:
http://opensource.atlassian.com/projects/hibernate/browse/HB-1113
Mysql "native" id generator fails if id's type is String. Why? It hibernate 2.1.6's bug?
Help!