使用JPA运行项目时报错：Error executing DDL“********”

最新推荐文章于 2023-06-28 11:11:29 发布
最新推荐文章于 2023-06-28 11:11:29 发布
阅读量3.1k 收藏
点赞数
分类专栏： Spring Boot java JPA 文章标签： jpa java
原文链接：https://blog.csdn.net/qq_44750520/article/details/104760518
版权
java 同时被 3 个专栏收录
8 篇文章 1 订阅
订阅专栏
Spring Boot
4 篇文章 0 订阅
订阅专栏
JPA
1 篇文章 0 订阅
订阅专栏 
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table certificate (id varchar(255) not null auto_increment, awards varchar(255), create_time datetime(6), deleted bit not null, fraction integer, name varchar(255), picture longtext, reason varchar(255), status bit not null, update_time datetime(6), level_id varchar(255), module_id varchar(255), primary key (id)) engine=InnoDB" via JDBC Statement
	at 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:184)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316)
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469)
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259)
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Incorrect column specifier for column 'id'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
	... 18 common frames omitted

Hibernate: create table tb_level_two (id varchar(255) not null auto_increment, name varchar(255), primary key (id)) engine=InnoDB
2021-03-02 14:16:18.514  WARN 9144 --- [         task-1] o.h.t.s.i.ExceptionHandlerLoggedImpl     : GenerationTarget encountered exception accepting command : Error executing DDL "create table tb_level_two (id varchar(255) not null auto_increment, name varchar(255), primary key (id)) engine=InnoDB" via JDBC Statement

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table tb_level_two (id varchar(255) not null auto_increment, name varchar(255), primary key (id)) engine=InnoDB" via JDBC Statement
	at 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:184)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316)
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469)
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259)
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Incorrect column specifier for column 'id'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
	... 18 common frames omitted

Hibernate: create table tb_module_two (id varchar(255) not null auto_increment, create_time datetime(6), deleted bit not null, name varchar(255), update_time datetime(6), primary key (id)) engine=InnoDB
2021-03-02 14:16:18.514  WARN 9144 --- [         task-1] o.h.t.s.i.ExceptionHandlerLoggedImpl     : GenerationTarget encountered exception accepting command : Error executing DDL "create table tb_module_two (id varchar(255) not null auto_increment, create_time datetime(6), deleted bit not null, name varchar(255), update_time datetime(6), primary key (id)) engine=InnoDB" via JDBC Statement

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table tb_module_two (id varchar(255) not null auto_increment, create_time datetime(6), deleted bit not null, name varchar(255), update_time datetime(6), primary key (id)) engine=InnoDB" via JDBC Statement
	at 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:184)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316)
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469)
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259)
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Incorrect column specifier for column 'id'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
	... 18 common frames omitted

Hibernate: create table user_two (id varchar(255) not null auto_increment, avatar varchar(255), create_time datetime(6), nick_name varchar(255), pass_word varchar(255), update_time datetime(6), user_name varchar(255), primary key (id)) engine=InnoDB
2021-03-02 14:16:18.515  WARN 9144 --- [         task-1] o.h.t.s.i.ExceptionHandlerLoggedImpl     : GenerationTarget encountered exception accepting command : Error executing DDL "create table user_two (id varchar(255) not null auto_increment, avatar varchar(255), create_time datetime(6), nick_name varchar(255), pass_word varchar(255), update_time datetime(6), user_name varchar(255), primary key (id)) engine=InnoDB" via JDBC Statement

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table user_two (id varchar(255) not null auto_increment, avatar varchar(255), create_time datetime(6), nick_name varchar(255), pass_word varchar(255), update_time datetime(6), user_name varchar(255), primary key (id)) engine=InnoDB" via JDBC Statement
	at 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:184)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316)
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469)
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259)
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Incorrect column specifier for column 'id'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
	... 18 common frames omitted

Hibernate: alter table certificate add constraint FK6n4ymhdqgq2inkq28lwivf7mh foreign key (level_id) references tb_level_two (id)
2021-03-02 14:16:18.518  WARN 9144 --- [         task-1] o.h.t.s.i.ExceptionHandlerLoggedImpl     : GenerationTarget encountered exception accepting command : Error executing DDL "alter table certificate add constraint FK6n4ymhdqgq2inkq28lwivf7mh foreign key (level_id) references tb_level_two (id)" via JDBC Statement

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table certificate add constraint FK6n4ymhdqgq2inkq28lwivf7mh foreign key (level_id) references tb_level_two (id)" via JDBC Statement
	at 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.applyForeignKeys(AbstractSchemaMigrator.java:433)
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316)
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469)
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259)
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Table 'certificate_collector_two.certificate' doesn't exist
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
	... 17 common frames omitted

Hibernate: alter table certificate add constraint FKjwmfb80kbt2fs6062t8ikkoft foreign key (module_id) references tb_module_two (id)
2021-03-02 14:16:18.522  WARN 9144 --- [         task-1] o.h.t.s.i.ExceptionHandlerLoggedImpl     : GenerationTarget encountered exception accepting command : Error executing DDL "alter table certificate add constraint FKjwmfb80kbt2fs6062t8ikkoft foreign key (module_id) references tb_module_two (id)" via JDBC Statement

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table certificate add constraint FKjwmfb80kbt2fs6062t8ikkoft foreign key (module_id) references tb_module_two (id)" via JDBC Statement
	at 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.applyForeignKeys(AbstractSchemaMigrator.java:433)
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316)
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469)
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259)
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Table 'certificate_collector_two.certificate' doesn't exist
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
	... 17 common frames omitted

2021-03-02 14:16:18.522  INFO 9144 --- [         task-1] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2021-03-02 14:16:18.528  INFO 9144 --- [         task-1] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2021-03-02 14:16:18.833  INFO 9144 --- [  restartedMain] DeferredRepositoryInitializationListener : Spring Data repositories initialized!
2021-03-02 14:16:18.841  INFO 9144 --- [  restartedMain] c.f.c.CertificateCollectorApplication    : Started CertificateCollectorApplication in 3.799 seconds (JVM running for 4.592)

解决方案：

JPA配置中加上这句配置

  #JPA配置
  jpa:
    hibernate:
      ddl-auto: update
    #控制台显示sql语句
    show-sql: true
    database: mysql
    open-in-view: true
    #报错：Error executing DDL，解决方案：设置数据库引擎为InnoDB
    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
Wesley_F
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Error executing DDL "create table hibernate_sequence (next_val bigint) engine=InnoDB" via JDBC State
木生的博客
02-26 6240
spring boot启动报错： org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table hibernate_sequence (next_val bigint) engine=InnoDB" via JDBC Statement at org.hibernat...
解决SpringDataJPA报错：org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null w
01-21
问题描述 用SpringBoot + Spring Data JPA操作数据库 项目启动的时候 报了一个错 SpringBoot的版本是2.2.6.RELEASE org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.cla
Error executing DDL “alter table t_blog add column release bit not null“ via JDBC Statement
蓝墨の学习笔记
08-21 2274
2020-08-21 18:24:05.624 WARN 6928 --- [ task-1] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "alter table t_blog add column release bit not null" via JDBC Statement org.
[Jpa 运行报错] Error executing DDL “alter table project_user_f.
汤圆的博客
05-28 4657
报错信息: Error executing DDL "alter table project_user_form add constraint FK2va0gk1rbm9kyfpeaivxugqsw foreign key (people_id) refere jpa.generate-ddl和jpa.hibernate.ddl-auto都可以控制是否执行datasource.schema脚本，来初始化数据库结构，只要有一个为可执行状态就会执行，比如jpa.generate-ddl:true或jpa.
JPA 添加多对多报错 Cannot add or update a child row: a foreign key constraint fails
qq_40990836的博客
01-17 1059
  报错就是这个 Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`cms`.`user_role`, CONSTRAINT `FK859n2jvi8ivhui0rl0esws6o`...
hibernate创建数据表报错 Error executing DDL via JDBC Statement
ADNAP7的博客
06-04 9519
用hibernate创建数据表的时候报错：Error executing DDL via JDBC Statement以及You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version和Table 'school.tb_role1' doesn't exists...
spring boot jpa @Entity 报Error executing DDL错误的解决办法
FE攻城狮
03-04 4605
错误如下： Error executing DDL "create table good (id bigint not null, cateid bigint, count bigint, createtime bigint, desc varchar(255), discount integer, imgurl varchar(255), name varchar(255), price bigint, saled bit, updatetime bigint, primary key (id)) eng
Spring集成JPA配置懒加载报错解决方案
08-25
Spring框架集成JPA（Java Persistence API）时，经常会遇到懒加载（Lazy Loading）报错的问题，本文将详细介绍解决方案。 懒加载报错解决方案 懒加载报错解决方案主要是解决Spring集成JPA配置懒加载时出现的报错...
解决返回JSON报错：HttpMessageNotWritableException: Could not write JSON: Infinite recursion (StackOverflowE
12-21
持久层框架用的是JPA 在Controller返回JSON数据到前端的时候 出现了这个StackOverflowError的错误 即 在将对象转换为JSON格式的数据的时候出现了无限递归调用的情况 如下： org.springframework....
springboot报错：NoClassDefFoundError: org/springframework/transaction/ReactiveTransactionManager
01-03
不添加org.springframework.boot:spring-boot-starter-data-jpa:2.2.5.RELEASE，只有org.mybatis.spring.boot:mybatis-spring-boot-starter:2.1.1， 则启动报错。 原因： org.springframework.boot:spring-boot-...
Error executing DDL via JDBC Statement
qq_38190111的博客
05-15 6811
springboot java jdk8 MySQL5 jpa 生成数据库时 报错Error executing DDL via JDBC Statement 解决方法： 修改application.properties 文件里的 spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.xxxx (你可能填...
JPA报 Error executing DDL
得已
09-27 770
在使用springboot+jpa进行部署项目时候,mysql \oracle 自行切换 即可正常。
【Hibernate】 报错：Error executing DDL “create table course (xxx)“
冷芝士鸭的学习笔记
10-12 2030
报错代码： Hibernate: create table course (id integer not null auto_increment, index integer, name varchar(255), primary key (id)) engine=InnoDB 十月 12, 2021 4:31:05 下午 org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException WARN: Generatio
SpringBoot+JPA 启动建表错误:CommandAcceptanceException: Error executing DDL"alter table X drop foreign key
yssa1125001的博客
05-28 8802
搭个Springboot+Jpa环境，一启动就报错： org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table X drop foreign key “FK7x41955roke6bti1oqnvs893h" via JDBC Statement 和： nested e...
JPA自动建表不生成外键
K10I
09-07 1393
SpringBoot项目搭配的JPA使用时候，有一对多的关系注解，那么自动会生成外键。1、单向多对多：只要在@JoinTable内的@JoinColumn内加上@ForeignKey属性配置即可，记得每个表外键都要加。2、双向一对多，除了在@JoinColumn加@ForeignKey配置，还需要再另一方（一方）加配置。1、单向一对多/多对一，在@JoinColumn内加上@ForeignKey属性配置即可。2、双向多对多：参照双向一对多/多对一，在另一方加注解即可。情况二、多表关系映射：多对多。
Error executing DDL “drop table if exists 解决方案
xeenj的博客
06-28 787
这将会引用所有的数据库标识符，这样就可以在表名或列名中使用保留关键字了​。解决方案：在配置文件。
hibernate开启ddl-auto为update模式时，Kingbase 8.2.0驱动下启动报Error executing DDL异常
10-11 698
首先描述下此异常出现的环境： 1. 开启数据库的大小写不敏感 2. hibnerate框架开启ddl-auto为update 确保数据库里已经有相应实体@Table的表，然后启动即会遇见此异常 通过跟踪代码，定位到如下图： 由于此处metaData对象读取的KbDatabaseMetaData连接的storeUpperCaseIdentifiers()方法返回的是写死的true导致执行了此处逻辑。 于是GroupedSchemaMigratorImpl类中的performTablesMi..
Error executing DDL
金戈铁马
08-08 2884
o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "create table xxx SPRING BOOT JPA 自动创建表失败。报错如上。 我遇到这个问题，是因为数据库创建者有一些字段命名不规范，使用了一些特殊的关键字。 比如 type internal等等 解决方法： 1修改字段。 ...
/** * SpringTest项目 数据库名字:SpringTest * * 要求:测试类,调用Controller层,实现增删改查.数据库表字段自己补充. * * 注解类依据实力添加,容器管理方式自己选择. */
最新发布
12-06
针对您的要求，您需要完成一个SpringTest项目，实现对数据库的增删改查操作。具体步骤如下： 1. 创建SpringTest项目，添加相关依赖，包括Spring MVC、Spring Data JPA等。 2. 在项目中创建实体类，用于表示数据库中的表结构。例如，创建一个User实体类，包含id、name、age等属性，并添加对应的getter/setter方法。 3. 创建DAO层接口，用于操作数据库。例如，创建一个UserRepository接口，继承自JpaRepository，用于对User表进行增删改查操作。 4. 创建Service层接口和实现类，用于实现业务逻辑。例如，创建一个UserService接口和UserServiceImpl实现类，用于对User表进行业务操作。 5. 创建Controller层，用于接收用户请求并调用相应的处理方法来处理请求，然后返回响应结果。例如，创建一个UserController类，包含增删改查等方法，用于对User表进行操作。 6. 在项目中配置相关注解，例如@ComponentScan、@EnableWebMvc等，用于启用Spring MVC框架和容器管理。 7. 编写测试类，调用Controller层的方法，实现对User表的增删改查操作。 下面是一个简单的示例代码，仅供参考： ```java // User实体类 @Entity @Table(name = "user") public class User { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String name; private Integer age; // getter/setter方法 } // UserRepository接口 public interface UserRepository extends JpaRepository<User, Long> { } // UserService接口和实现类 public interface UserService { User save(User user); void deleteById(Long id); User findById(Long id); List<User> findAll(); } @Service public class UserServiceImpl implements UserService { @Autowired private UserRepository userRepository; @Override public User save(User user) { return userRepository.save(user); } @Override public void deleteById(Long id) { userRepository.deleteById(id); } @Override public User findById(Long id) { return userRepository.findById(id).orElse(null); } @Override public List<User> findAll() { return userRepository.findAll(); } } // UserController类 @RestController @RequestMapping("/user") public class UserController { @Autowired private UserService userService; @PostMapping("/save") public User save(@RequestBody User user) { return userService.save(user); } @DeleteMapping("/delete/{id}") public void deleteById(@PathVariable Long id) { userService.deleteById(id); } @GetMapping("/find/{id}") public User findById(@PathVariable Long id) { return userService.findById(id); } @GetMapping("/findAll") public List<User> findAll() { return userService.findAll(); } } // 测试类 @RunWith(SpringRunner.class) @SpringBootTest public class UserControllerTest { @Autowired private UserController userController; @Test public void testSave() { User user = new User(); user.setName("张三"); user.setAge(20); User savedUser = userController.save(user); Assert.assertNotNull(savedUser.getId()); } @Test public void testDeleteById() { User user = new User(); user.setName("李四"); user.setAge(25); User savedUser = userController.save(user); userController.deleteById(savedUser.getId()); User deletedUser = userController.findById(savedUser.getId()); Assert.assertNull(deletedUser); } @Test public void testFindById() { User user = new User(); user.setName("王五"); user.setAge(30); User savedUser = userController.save(user); User foundUser = userController.findById(savedUser.getId()); Assert.assertEquals(savedUser.getName(), foundUser.getName()); Assert.assertEquals(savedUser.getAge(), foundUser.getAge()); } @Test public void testFindAll() { User user1 = new User(); user1.setName("赵六"); user1.setAge(35); User savedUser1 = userController.save(user1); User user2 = new User(); user2.setName("钱七"); user2.setAge(40); User savedUser2 = userController.save(user2); List<User> userList = userController.findAll(); Assert.assertEquals(2, userList.size()); } } ```

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值