Hibernate5在MySQL数据库中自动建表时报异常Error executing DDL via JDBC Statement

来源：互联网发布：淘宝详情页怎么做美观编辑：程序博客网时间：2024/05/18 01:26

首先，在项目的配置文件hibernate.cfg.xml中配置hibernate的mysql数据库方言及自动建表配置如下：

<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property><property name="hibernate.hbm2ddl.auto">update</property>

运行测试代码报异常如下：

WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statementorg.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statementat org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277)at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71)at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:313)at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:452)at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:710)at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:726)……

解决方法：修改MySQL数据库方言为：

<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>

MysqlDialect是比较早的配置，如果项目使用的是MySQL 5，最好使用MySQL5Dialect。MySQL5Dialect针对MySQL 5的一些新特性做了一些优化，而且Mysql5Dialect是继承了MysqlDialect的，所以MysqlDialect能完成的事 Mysql5Dialect都完成。

阅读全文

0 0