SpringBoot MySQL #1 报错 Error executing DDL ...

最新推荐文章于 2023-06-28 11:11:29 发布
最新推荐文章于 2023-06-28 11:11:29 发布
阅读量930 收藏
点赞数
分类专栏： # Spring Boot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Molianna/article/details/118855301
版权

连接 MySQL 数据库时，运行项目报错：

Error executing DDL “create table hibernate_sequence (next_val bigint) type=MyISAM” via JDBC Statement…

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table hibernate_sequence (next_val bigint) type=MyISAM" via JDBC Statement
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:320) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:462) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1249) [hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) [spring-orm-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [spring-orm-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) [spring-orm-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:378) [spring-orm-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) [spring-orm-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1862) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1799) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1108) ~[spring-context-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868) ~[spring-context-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) ~[spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) ~[spring-boot-2.2.1.RELEASE.jar:2.2.1.RELEASE]
	at com.example.demo.DemoApplication.main(DemoApplication.java:20) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) ~[spring-boot-devtools-2.2.1.RELEASE.jar:2.2.1.RELEASE]
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=MyISAM' at line 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-3.4.1.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-3.4.1.jar:na]
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) ~[hibernate-core-5.4.8.Final.jar:5.4.8.Final]
	... 39 common frames omitted
 
 #springboot 配置问题
 spring.jpa.database-platform=org.hibernate.dialect.MySQLDialect
 改为
 spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect

和 SpringBoot 的版本有关系，2.0 后使用 JPA 连接数据库时会出现这个问题。

FSYML
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Error executing DDL "create table hibernate_sequence (next_val bigint) engine=InnoDB" via JDBC State
木生的博客
02-26 6197
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...
maven settings.xml 解决在项目新建时报错，Error executing Maven. 2 problems
最新发布
02-04
maven settings.xml 解决在项目新建时报错 Error executing Maven. 2 problems were encountered while building the effective settings。下载这个，注意54行的目录，修改成自己的项目目录，直接覆盖原来的\conf...
完美解决SpringDataJPA报错create table hibernate_sequence (next_val bigint) type=MyISAM Hibernate: create t
01-20
问题描述 用Spring Boot JPA自动生成数据库的表的时候 报了一个错 SpringBoot版本：2.2.6.RELEASE MySQL版本：5.6 2020-04-09 12:52:29.990 INFO 14120 --- [ restartedMain] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQLInnoDBDialect Hibernate: create table hibernate_sequence (next_val
sqoop导入数据至hdfs错误 You have an error in your SQL syntax；
LZX的博客
11-19 2404
21/11/19 10:14:37 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to u
[Jpa 运行报错] Error executing DDL “alter table project_user_f.
汤圆的博客
05-28 4519
报错信息: 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.
spring boot jpa @Entity 报Error executing DDL错误的解决办法
FE攻城狮
03-04 4507
错误如下： 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
hibernate创建数据表报错 Error executing DDL via JDBC Statement
ADNAP7的博客
06-04 9485
用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...
Error executing DDL via JDBC Statement
小科比的博客
10-27 2011
项目环境：spring+jdk8+Hibernate+MySql jpa 生成数据库时 报错 Error executing DDL via JDBC Statement 解决方法： 修改配置文件applicationContext.xml或者hibernate.cfg.xml里hibernate.dialect的值 <property name="hibernateProperties"> <props> <prop key="hibernate.dialect"&gt
JPA报 Error executing DDL
得已
09-27 741
在使用springboot+jpa进行部署项目时候,mysql \oracle 自行切换 即可正常。
错误信息 Error executing DDL via JDBC Statement 解决办法
热门推荐
NULL
02-27 1万+
二月 27, 2018 10:34:44 上午 org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Stat...
Error executing DDL
金戈铁马
08-08 2856
o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "create table xxx SPRING BOOT JPA 自动创建表失败。报错如上。 我遇到这个问题，是因为数据库创建者有一些字段命名不规范，使用了一些特殊的关键字。 比如 type internal等等 解决方法： 1修改字段。 ...
解决OracleRAC集群下创建SDE时报Stored procedures错误问题.docx
03-18
解决OracleRAC集群下创建SDE时报Stored procedures错误问题 环境：Oracle11.2.0.3 两节点RAC集群，windows server2008R2，FCSAN共享存储，ArcGIS Desktop 1031
解决 github项目clone报错 Failed connect to github.com:443; Connection
01-09
Error while executing: npm ERR! /usr/bin/git ls-remote -h -t https://github.com/nhn/raphael.git npm ERR! npm ERR! fatal: unable to access &#39;...
linux安装mysql(rpm脱网安装).zip
10-11
loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory 原因是没有安装libaio.so.1，安装即可。 Redhat/Fedora/CentOS下执行： yum install libaio 4、修改root密码...
使用JPA运行项目时报错：Error executing DDL“********”
weixin_44735825的博客
03-02 3004
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), pictu
Error executing DDL via JDBC Statement 导致原因之一:列名使用了sql关键字
weixin_30412167的博客
10-16 1123
WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statementorg.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement ...
sqoop将hive里的表导入mysql
大黄_sama
11-09 189
sqoop 导出hive数据到mysql   执行命令 bin/sqoop export --connect jdbc:mysql://slaver3:3306/ishangzu --username root --password root --table dw_pv_uv_ip --export-dir /user/hive/warehouse/t_20161019.db/dw_pv_u...
Error executing DDL “drop table if exists 解决方案
xeenj的博客
06-28 681
这将会引用所有的数据库标识符，这样就可以在表名或列名中使用保留关键字了​。解决方案：在配置文件。
执行mvn clean install报错Error executing Maven.是什么意思
03-27
"Error executing Maven"是指执行Maven命令时出现了错误，具体错误原因需要查看错误提示信息来确定。可能的原因包括：Maven配置错误、依赖项缺失、构建脚本错误等等。建议查看错误提示信息并逐一排查可能的原因。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值