Error executing DDL “alter table news.credit_news add column explain varchar(255)“ via JDBC Statemen

已于 2022-07-04 16:53:09 修改
阅读量2.4k 收藏
点赞数 1
文章标签： mysql 数据库
于 2020-04-15 16:10:38 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/luckyZQC/article/details/105537478
版权

下面展示一些 内联代码片。

启动报错

Hibernate: alter table news.credit_news add column explain varchar(255)
[ WARN] [2020-04-15 16:02:06.853] [           main] org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl.handleException(ExceptionHandlerLoggedImpl.java:27)  : GenerationTarget encountered exception accepting command : Error executing DDL "alter table news.credit_news add column explain varchar(255)" via JDBC Statement
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table news.credit_news add column explain varchar(255)" via JDBC Statement
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:580) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.migrateTable(AbstractSchemaMigrator.java:297) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:75) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939) [hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57) [spring-orm-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [spring-orm-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390) [spring-orm-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377) [spring-orm-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) [spring-orm-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1804) [spring-beans-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1741) [spring-beans-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:576) [spring-beans-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498) [spring-beans-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) [spring-beans-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$110/1757676444.getObject(Unknown Source) [spring-beans-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [spring-beans-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) [spring-beans-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) [spring-beans-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1083) [spring-context-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:853) [spring-context-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546) [spring-context-5.1.2.RELEASE.jar!/:5.1.2.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) [spring-boot-2.1.0.RELEASE.jar!/:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) [spring-boot-2.1.0.RELEASE.jar!/:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.1.0.RELEASE.jar!/:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) [spring-boot-2.1.0.RELEASE.jar!/:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) [spring-boot-2.1.0.RELEASE.jar!/:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) [spring-boot-2.1.0.RELEASE.jar!/:2.1.0.RELEASE]
	at com.cn.jll.dajiaxinfu.information.InformationServiceApplication.main(InformationServiceApplication.java:20) [classes!/:0.0.1-SNAPSHOT]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_45]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_45]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_45]
	at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_45]
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [dajiaxinfu-information-service-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [dajiaxinfu-information-service-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [dajiaxinfu-information-service-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [dajiaxinfu-information-service-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
Caused by: 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 use near 'explain varchar(255)' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_45]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_45]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_45]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0_45]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.Util.getInstance(Util.java:381) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:769) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:612) ~[mysql-connector-java-5.1.8.jar!/:?]
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2958) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2956) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.wall.WallFilter.statement_execute(WallFilter.java:414) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2956) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2956) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.execute(StatementProxyImpl.java:147) ~[druid-1.1.10.jar!/:1.1.10]
	at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:619) ~[druid-1.1.10.jar!/:1.1.10]
	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final]
	... 43 more

mysql中，explain是关键字不能用

大家信夫（您身边的信用教官）：https://www.dajiaxinfu.com/

luckyZQC
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Error executing DDL "create table hibernate_sequence (next_val bigint) engine=InnoDB" via JDBC State
木生的博客
02-26 6258
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报错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
SpringBoot MySQL #1 报错 Error executing DDL ...
FSYML
07-17 965
连接 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) t
Error executing DDL via JDBC Statement
小科比的博客
10-27 2031
项目环境：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 776
在使用springboot+jpa进行部署项目时候,mysql \oracle 自行切换 即可正常。
Error executing DDL “drop table if exists 解决方案
xeenj的博客
06-28 824
这将会引用所有的数据库标识符，这样就可以在表名或列名中使用保留关键字了​。解决方案：在配置文件。
nginx-1.20.2-1.el7-rtmp.ngx.x86_64.rpm
03-02
屏蔽了显示服务器名称和版本号（需要配置） 加入了rtmp模块，支持流媒体视频
解决OracleRAC集群下创建SDE时报Stored procedures错误问题.docx
03-18
可以使用`ALTER USER`语句，设置无限制的表空间配额。 6. **重新启用SDE数据库：** 最后，执行ArcGIS Desktop提供的命令或通过ArcGIS Server管理工具，启用Enterprise Geodatabase，确保SDE连接正常。 在执行上述...
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...
sqlite_sample.rar_SQLITE LINUX_sqlite_sqlite-linux
09-19
fprintf(stderr, "Error executing statement: %s\n", sqlite3_errmsg(db)); } sqlite3_finalize(stmt); sqlite3_close(db); return 0; } ``` 在这个示例中，我们首先打开了一个名为"test.db"的数据库，然后...
错误信息 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 2896
o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "create table xxx SPRING BOOT JPA 自动创建表失败。报错如上。 我遇到这个问题，是因为数据库创建者有一些字段命名不规范，使用了一些特殊的关键字。 比如 type internal等等 解决方法： 1修改字段。 ...
SpringBoot+JPA 启动建表错误:CommandAcceptanceException: Error executing DDL"alter table X drop foreign key
yssa1125001的博客
05-28 8821
搭个Springboot+Jpa环境，一启动就报错： org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table X drop foreign key “FK7x41955roke6bti1oqnvs893h" via JDBC Statement 和： nested e...
H2数据库关键字导致org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL
qq_43041751的博客
06-09 2481
h2创表问题
springboot Error executing DDL via JDBC Statement
weixin_38011805的博客
03-08 841
关键字和数据库重复 主要原因在定义数据库字段时出现了空格，特殊字符，或者与数据库关键字冲突 spring jpa dialect 配置 spring.jpa.database-platform: org.hibernate.dialect.MySQL5Dialect
【Hibernate】 报错：Error executing DDL “create table course (xxx)“
冷芝士鸭的学习笔记
10-12 2042
报错代码： 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
Error executing DDL “alter table update_info add column desc varchar(255)“ via JDBC Statement
cyunann的博客
08-22 3337
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 ‘desc varchar(255)’ at line 1 和平时一样我使用Hibernate自动建数据表，出现了报错。 这个报错莫名其妙，我找了很久才发
Error executing DDL “alter table t_blog add column release bit not null“ via JDBC Statement
蓝墨の学习笔记
08-21 2285
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.
【BUG日记】【Hibernate】Error executing DDL “create table hibernate_sequence (next_val bigint) type=MyISAM
南方者的博客
10-12 1020
【日期】： 2020/10/12 【问题】： Error executing DDL “create table hibernate_sequence (next_val bigint) type=MyISAM” via JDBC Statement. Error executing DDL “insert into hibernate_sequence values ( 1 )” via JDBC Statement 【原因】： Entity类中，定义的字段使用了注解：@GeneratedValu
Executing: ALTER TABLE `ietime`.`ie_progress` ADD COLUMN `planeddate` DATETIME NULL COMMENT '计划完成日期' AFTER `plandate`, CHANGE COLUMN `gd` `plandate` DATETIME NULL DEFAULT NULL COMMENT '计划上线日期' AFTER `edtime`;
06-03
这是一条 MySQL 数据库的 ALTER TABLE 语句，用于向 `ie_progress` 表中添加一个名为 `planeddate` 的新列，并将原来的 `plandate` 列改名为 `gd`，并将其定义为可空的。新添加的 `planeddate` 列将位于 `plandate` 列后面。同时，它将 `plandate` 列的默认值设置为 `NULL`，并添加了一条注释说明。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值