Hibernate不能创建表 [英] Hibernate can't create table

问题描述

错误：HHH000388：不成功：创建表用户（id bigint不为null auto_increment，mail varchar（ 255），passwort varchar（255），主键（id））
错误：从存储引擎得到错误-1

这是我的映射类：

  package实体; 
 
 import javax.persistence.Column; 
 import javax.persistence.Entity; 
 import javax.persistence.GeneratedValue; 
 import javax.persistence.Id; 
 
 @实体
公共类用户
 {
私人长ID; 
私人字符串邮件; 
私人字符串密码; 
 
 @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; 
} 
 
 
} 
  

解决方案

我不知道为什么，但我有同样的问题。然后，我只需使用@Table（name =Users）注释来更改表的名称并开始工作。

因此，请尝试更改此
@Entity
public class User
{
}

to：

@Entity
@Table（name =Users）
public class User
{
}

I just started to user hibernate and i allways get this Error:

ERROR: HHH000388: Unsuccessful: create table User (id bigint not null auto_increment, mail varchar(255), passwort varchar(255), primary key (id)) ERROR: Got error -1 from storage engine

This is my mapped class:

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;
}


}

解决方案

I don't know why but I had same issue. Then I just change the name for table with @Table(name="Users") annotation and it started to work.

So try changing this @Entity public class User { }

to This:

@Entity @Table(name="Users") public class User { }

这篇关于Hibernate不能创建表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！