mysql sql field list_使用MySQL数据库出现Unknown table 'hibernate_sequence' in field list

异常信息：

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'hibernate_sequence' in field list

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)

... 84 more

生成SQL语句：

Hibernate:

select

hibernate_sequence.nextval

from

dual

实体类配置：

package com.hpu.model;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

@Entity

@Table(name = "t_user",catalog="pms")

public class User {

private Integer id;

private String name;

private String password;

@Id

@GeneratedValue(strategy=GenerationType.AUTO)

public Integer getId() {

return id;

}

public String getPassword() {

return password;

}

public void setId(Integer id) {

this.id = id;

}

public void setPassword(String password) {

this.password = password;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

}

由上面可知，出错原因是没有找到hibernate_sequence这张表，可是使用的是Mysql数据库，而且生成Id的方式是AUTO也就是会按照native的方式来生成Id，可是查找hibernate_sequence这张表是oracle生成Id的方式，即Sequence，这是为什么呢，原来是我这个项目原先使用Oracle数据库中途改成了Mysql而没有把Dialect改成Mysql的方言引起的，所以修改之后 ，一切正常》