Hibernate无法创建表

Question

我刚开始使用hibernate，总是会遇到这样的错误：

错误:HHH000388:不成功：创建表用户（id bigint not null auto_increment,mail varchar（255）,passwort varchar（255）,primary key(id)）错误：从存储引擎获取错误-1

这是我的映射类：

package Entities;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;

@Entity
public class User 
{
private long id;
private String mail;
private String passwort;

@Id
@GeneratedValue  
@Column(name="id")
public long getId() {
    return id;
}

public void setId(long id) {
    this.id = id;
}

@Column(name="mail")
public String getMail() {
    return mail;
}

public void setMail(String mail) {
    this.mail = mail;
}

@Column(name="passwort")
public String getPasswort() {
    return passwort;
}

public void setPasswort(String passwort) {
    this.passwort = passwort;
}


}

Answer 1

以下是Hibernate配置：

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
    <hibernate-configuration>
      <session-factory>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull</property>
        <property name="hibernate.connection.username">root</property>
        <property name="connection.pool_size">1</property>
        <property name="show_sql">true</property>
        <property name="hbm2ddl.auto">update</property>
      </session-factory>
    </hibernate-configuration>