springboot项目启动报警java.sql.SQLException:

最新推荐文章于 2024-04-28 15:07:44 发布
最新推荐文章于 2024-04-28 15:07:44 发布
阅读量2.4k 收藏
点赞数
分类专栏： spring-boot jpa spring
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yanlici1249075710/article/details/78533432
版权
spring-boot 同时被 3 个专栏收录
9 篇文章 0 订阅
订阅专栏
jpa
9 篇文章 0 订阅
订阅专栏
spring
5 篇文章 0 订阅
订阅专栏 


 2017-11-14 17:34:49[org.hibernate.engine.jdbc.spi.SqlExceptionHelper]-[ERROR] Field 'allow_update' doesn't have a default value
 2017-11-14 17:34:49[com.dianju.trustedSign.core.modules.rbacOperation.OperationInit]-[ERROR] 权限叙述冲突
 org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'viewControllerHandlerMapping' defined in class path resource [org/springframework/boot/autoconfigure/web/WebMvcAutoConfiguration$EnableWebMvcConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.web.servlet.HandlerMapping]: Factory method 'viewControllerHandlerMapping' threw exception; nested exception is org.springframework.orm.jpa.JpaSystemException: could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:599)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1123)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1018)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1054)
    at com.dianju.trustedSign.core.Util.getBean(Util.java:53)
    at com.dianju.trustedSign.core.modules.rbacOperation.OperationInit.init(OperationInit.java:40)
    at com.dianju.trustedSign.core.SystemListener.contextInitialized(SystemListener.java:91)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4810)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5255)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.web.servlet.HandlerMapping]: Factory method 'viewControllerHandlerMapping' threw exception; nested exception is org.springframework.orm.jpa.JpaSystemException: could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:189)
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588)
    ... 21 more
Caused by: org.springframework.orm.jpa.JpaSystemException: could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:314)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
    at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
    at com.dianju.trustedSign.core.SystemInit$$EnhancerBySpringCGLIB$$c73da3e4.addInterceptors(<generated>)
    at org.springframework.web.servlet.config.annotation.WebMvcConfigurerComposite.addInterceptors(WebMvcConfigurerComposite.java:112)
    at org.springframework.web.servlet.config.annotation.DelegatingWebMvcConfiguration.addInterceptors(DelegatingWebMvcConfiguration.java:57)
    at org.springframework.web.servlet.config.annotation.WebMvcConfigurationSupport.getInterceptors(WebMvcConfigurationSupport.java:280)
    at org.springframework.web.servlet.config.annotation.WebMvcConfigurationSupport.viewControllerHandlerMapping(WebMvcConfigurationSupport.java:374)
    at org.springframework.boot.autoconfigure.web.WebMvcAutoConfiguration$EnableWebMvcConfiguration$$EnhancerBySpringCGLIB$$dc665f4f.CGLIB$viewControllerHandlerMapping$35(<generated>)
    at org.springframework.boot.autoconfigure.web.WebMvcAutoConfiguration$EnableWebMvcConfiguration$$EnhancerBySpringCGLIB$$dc665f4f$$FastClassBySpringCGLIB$$bb72b7d7.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
    at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:355)
    at org.springframework.boot.autoconfigure.web.WebMvcAutoConfiguration$EnableWebMvcConfiguration$$EnhancerBySpringCGLIB$$dc665f4f.viewControllerHandlerMapping(<generated>)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:162)
    ... 22 more
Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
    at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
    at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
    at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)
    at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425)
    at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
    at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177)
    at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:77)
    at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
    ... 44 more
Caused by: java.sql.SQLException: Field 'allow_update' doesn't have a default value
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
    at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
    at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
    at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
    ... 58 more

原因就是数据库的表缺少一个字段：
解决办法1：手动去数据库中，该表处添加
解决办法2：修改这个文件application.properties下的，设置为这个样式就可以了
spring.jpa.hibernate.ddl-auto = create
解决办法3：把原来数据库中那个表删除即可，也会自动创建

1249075710
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
java.sql.SQLException: Locale not recognized处理
weixin_30737433的博客
05-31 1493
java.sql.SQLException: Locale not recognized at oracle.jdbc.driver.T4CTTIoauthenticate.setSessionFields(T4CTTIoauthenticate.java:939) at oracle.jdbc.driver.T4CTTIoauthenticate.<init>(T4CTTIoau...
java.sql.SQLException: 结果集已耗尽
08-02
在Java编程中，`java.sql.SQLException: 结果集已耗尽` 是一个常见的错误提示，通常出现在处理数据库查询结果集时。这个异常表明程序试图访问已经没有数据的结果集中下一行，即所有行已经被遍历完，尝试访问超出范围...
springboot配置druid连接池application.yml文件出现Caused by: java.sql.SQLException: com.mysql.jdbc.Driver
月亮投递员的博客
11-30 835
springboot配置druid中application.yml中出错错误展示解决方案 错误展示 运行项目自带的启动类发现application.yml中出现了这个错误Caused by: java.sql.SQLException: com.mysql.jdbc.Driver 解决方案 指定驱动mysql的jar <dependency> <groupId>mysql</groupId> <artifactId>mysql-
springboot全局处理sql异常
最新发布
qq_36022463的博客
04-28 544
引用：https://download.csdn.net/blog/column/12507643/134327833。springboot全局异常处理，不会去拦截sql异常，导致错误返回到前端，，将sql中的字段暴露出来，很危险，，因为ExceptionHandler 只认我们注入类的名称，，而。
springboot启动失败常见问题
陌花拟的博客
12-02 1399
刚开始使用springboot连接mysql数据库，项目启动的时候报了一个错误 Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the ...
通过jdbc连接hive报java.sql.SQLException: Method not supported问题
weixin_33842328的博客
08-28 1万+
今天尝试通过jdbc连接hive，JDBC直接连接是正常成功的，实例： import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLEx...
java.sql.SQLException: 无效的列类型: 错误解析
热门推荐
可行的code
08-16 4万+
八月 16, 2018 8:47:40 下午 org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [DispatcherServlet] in context with path [/RPCExamSystem] threw exception [Request pr...
java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to
12-14
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错： 解决方法： 1，登陆服务器 mysql> use mysql; //用mysql ...
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
01-21
Q: I am working with ... I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
09-29
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
MySQL存储表情时报错：java.sql.SQLException: Incorrect string value:‘\xF0\x9F\x92\xA9\x0D\x0A…’的解决方法
12-16
本文主要介绍了关于MySQL存储表情报错：java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x92\xA9\x0D\x0A…’的相关解决方法，分享出供大家参考学习，下面话不多说了，来一起看看详细的介绍： 本项目是...
java.sql.SQLException: 当事务仍处于活动状态时，无法关闭连接。解决办法
weixin_30710457的博客
11-07 623
当遇到“java.sql.SQLException: 当事务仍处于活动状态时，无法关闭连接。”的异常信息时候，一般情况下是由于Connection的autoCommit设置为false。导致查询语句无法结束。解决办法：将Connection的AutoCommit设置为true。 转载于:https://www.cnblogs.com/jfarm/archive/2009/11/07/15978...
Method threw ‘java.lang.NullPointerException‘ exception. Cannot evaluate com.*.toString()
qisuanli0846的博客
03-31 1万+
在Debug模式下发现toString()抛NullPointerException，异常描述： Method threw 'java.lang.NullPointerException' exception. Cannot evaluate com.mb.wlph.model.MovementBase.toString() 异常原因： 因为Debug模式下需要显示变量信息，这个信息就是要调用toString()方法得到的,实体类对象存在null属性字段时,调用toString()方法...
关于金仓数据库的java连接问题
qingfengguixiaox的博客
11-06 2345
关于人大金仓数据库的java连接问题
springboot集成mysql时报CLIENT_PLUGIN_AUTH is required异常处理
riemann_的博客
04-27 1215
异常信息： java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.15.jar:8.0....
启动Spring boot报错：nested exception is java.sql.SQLException: Field 'id' doesn't have a default value...
wuxun1997的专栏
05-10 2141
　　先看具体日志： org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration': Unsatisfied depe...
JAVA数据库异常回滚,事务回滚功能有时失效，报：java.sql.SQLException: The transaction is no longer active - status: 'Marke...
weixin_39879665的博客
03-11 1683
1、根据异常信息java.sql.SQLException:Thetransactionisnolongeractive-status:'Markedrollback.来看，jdbc连接已关闭但仍在此事物中进行数据库操作导致的问题；建议去查看下eos-governor中执行sql语句较长的情况。2、检查是否存在连接未释放的情况，排查方法如下：Governor中提供了SQL监控的...
java mysql executequery_java execute、executeQuery和executeUpdate之间的区别
weixin_35827671的博客
02-03 287
在用纯JSP做一个页面报警功能的时候习惯性的用executeQuery来执行SQL语句，结果执行update时就遇到问题，语句能执行，但返回结果出现问题，另外还忽略了executeUpdate的返回值不是结果集ResultSet,而是数值！特收藏如下一篇文章(感谢网友们对各种信息的贡献)：JDBCTM中Statement接口提供的execute、executeQuery和executeUpdate...
springboot项目启动时：报错连接数据库异常
看一点点书，懂一点点道理，过好这一生
05-20 2139
springboot项目启动时：报错连接数据库异常 原因排查： 1.使用连接工具进行验证是否可以连接数据库 2.确认可以连接数据库，项目启动依旧报错 3.和其他人代码都一样，但是自己的就是报错；可以修改下Oracle驱动，然后启动项目，发现正常；异常诡异，在此可以被看到解决该问题； 代码中Oracle的驱动是： <dependency> <groupId>com.oracle</groupId> <ar
springboot出现如何排错java.sql.SQLException: Access denied for user 'root'@'localhost'
04-12
如果您遇到了 "java.sql.SQLException: Access denied for user 'root'@'localhost'" 的错误，这通常意味着您的应用程序无法使用给定的用户名和密码连接到数据库。您可以尝试检查您的数据库连接字符串是否正确并且...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值