民航电子数据库：select、insert时包含数据库关键字，导致报错：Error updating database. Cause: java.lang.NullPointerException

已于 2024-04-25 14:21:11 修改
阅读量1k 收藏 19
点赞数 27
分类专栏： 第三方对接 文章标签： 数据库 java
于 2024-04-25 10:20:05 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_52116015/article/details/138176329
版权

目录

一、场景

1、对接民航电子数据库

2、shardingsphere + mybatis + springboot + caedb（民航电子数据库）

3、select、insert时报错（只有某个固定的SQL会报错）

二、表结构

在这里插入图片描述

三、SQL及入参

Preparing: INSERT INTO t_mb_weixinuser (subscribe,openid,sex,city,country,province,language, headimgurl,subscribe_time,nickname,originId,originType,SynFlag,vdnId) VALUE(?,?,?,?,?,?,?, ?,?,?,?,?,'0',?) 

Parameters: null, 1_153g69n_8xp7cg5(String), null, 局域网(String), (String), 局域网(String), null, null, 2024-04-24 04:53:13.917(Timestamp), 局域网局域网局域网(1_153g69n_8xp7cg5)(String), 1(Long), WEB(String), 1(Integer)

Preparing: select city,country,headimgurl,language,nickname,openid,province, sex,subscribe,subscribe_time,originId,originType,vdnId from t_mb_weixinuser where openid=? and vdnId = ? 

Parameters: 1_90D5KHa3O_243fo(String), 1(String)

四、报错信息

nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.lang.NullPointerException
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO t_mb_weixinuser (subscribe,openid,sex,city,country,province,language,   headimgurl,subscribe_time,nickname,originId,originType,SynFlag,vdnId)   VALUE(?,?,?,?,?,?,?,   ?,?,?,?,?,'0',?)
### Cause: java.lang.NullPointerException
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.lang.NullPointerException
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO t_mb_weixinuser (subscribe,openid,sex,city,country,province,language,   headimgurl,subscribe_time,nickname,originId,originType,SynFlag,vdnId)   VALUE(?,?,?,?,?,?,?,   ?,?,?,?,?,'0',?)
### Cause: java.lang.NullPointerException
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy96.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy99.insertUserInfo(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy100.insertUserInfo(Unknown Source)
	at com.xxx.service.impl.UserServiceImpl.insertUserInfo(UserServiceImpl.java:306)
	at com.xxx.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$e55ebb29.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
	at com.xxx.datasource.DataSourceAspect.around(DataSourceAspect.java:47)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.xxx.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$2c6e1114.insertUserInfo(<generated>)
	at com.xxx.socket.controller.VisitorController.test(VisitorController.java:266)
	at com.xxx.socket.controller.VisitorController$$FastClassBySpringCGLIB$$9d4b4aff.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
	at com.xxx.aop.FrequencyAspect.around(FrequencyAspect.java:66)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.xxx.socket.controller.VisitorController$$EnhancerBySpringCGLIB$$ed095656.test(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:515)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:583)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:212)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:682)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:617)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:932)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1694)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.lang.NullPointerException
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO t_mb_weixinuser (subscribe,openid,sex,city,country,province,language,   headimgurl,subscribe_time,nickname,originId,originType,SynFlag,vdnId)   VALUE(?,?,?,?,?,?,?,   ?,?,?,?,?,'0',?)
### Cause: java.lang.NullPointerException
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	... 107 common frames omitted
Caused by: java.lang.NullPointerException: null
	at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
	at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitInsert(SQL92DMLVisitor.java:106)
	at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitInsert(SQL92DMLVisitor.java:102)
	at org.apache.shardingsphere.sql.parser.autogen.SQL92StatementParser$InsertContext.accept(SQL92StatementParser.java:497)
	at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
	at org.apache.shardingsphere.sql.parser.SQLParserEngine.parse0(SQLParserEngine.java:80)
	at org.apache.shardingsphere.sql.parser.SQLParserEngine.parse(SQLParserEngine.java:61)
	at org.apache.shardingsphere.underlying.route.DataNodeRouter.createRouteContext(DataNodeRouter.java:97)
	at org.apache.shardingsphere.underlying.route.DataNodeRouter.executeRoute(DataNodeRouter.java:89)
	at org.apache.shardingsphere.underlying.route.DataNodeRouter.route(DataNodeRouter.java:76)
	at org.apache.shardingsphere.underlying.pluggble.prepare.PreparedQueryPrepareEngine.route(PreparedQueryPrepareEngine.java:54)
	at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.executeRoute(BasePrepareEngine.java:96)
	at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.prepare(BasePrepareEngine.java:83)
	at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.prepare(ShardingPreparedStatement.java:183)
	at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:143)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	at com.sun.proxy.$Proxy163.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy160.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	... 113 common frames omitted

五、排查

1、确认表字段类型与select、insert时属性值类型是否有误差
结果：字段类型一致

2、将报错的SQL拿到caedb数据库管理工具CAEManager执行
结果：select、insert正常
结论：在框架层面就报错了，不是caedb数据库导致

3、将caedb更换为mysql：shardingsphere + mybatis + springboot + mysql

结果：select、insert正常

结论：报错与caedb数据库有关

4、逐步缩短select、insert语句，以确认导致报错的字段
结果：发现是字段language导致报错

5、insert时将字段language的值写死为字符串
结果：依旧报错空指针
猜测：可能是这张表有不同点，导致报错

6、新建一张带有language字段的表尝试select、insert

在这里插入图片描述

在这里插入图片描述

结果：依旧报错
结论：报错与language字段有关

7、language字段是mysql的关键字，select、insert时如果包含数据库关键字应该带上反引号

在这里插入图片描述

结果：依旧报错

8、查看报错信息，通过debug排查原因

a）发现 mysql与 caedb（民航电子数据库）在框架代码中，数据库的类型存在差异

b）shardingsphere + mybatis + springboot + mysql

在这里插入图片描述

c）shardingsphere + mybatis + springboot + caedb（民航电子数据库）

在这里插入图片描述

六、原因

在shardingsphere + 数据库的情况下

mysql与 caedb（民航电子数据库）在框架代码中，数据库的类型存在差异，所以SQL语法也会存在差异

补充：经过测试，只有shardingsphere + caedb（民航电子数据库）在select、insert包含数据库关键字会报错，如果没有使用shardingsphere ，而仅仅是 caedb（民航电子数据库）即使包含关键字，select、insert也是正常的

七、解决

由于数据库类型以更变为SQL92，为关键字字段加上反引号已经无效

需要调整，为关键字字段加上：双引号

在这里插入图片描述

在这里插入图片描述

Preparing: INSERT INTO t_mb_weixinuser (subscribe,openid,sex,city,country,province,"language", headimgurl,subscribe_time,nickname,originId,originType,SynFlag,vdnId) VALUES(?,?,?,?,?,?,?, ?,?,?,?,?,'0',?) 
Parameters: null, 1713950894425(String), null, null, null, null, null, null, null, aaaaa(String), 1(Long), null, 1(Integer)
databases collection is [[service1, service0]], precise sharding value is [PreciseShardingValue(logicTableName=t_mb_weixinuser, columnName=originid, value=1)]
use databases name is [service1]
Updates: 1

在这里插入图片描述

Preparing: select city,country,headimgurl,"language",nickname,openid,province, sex,subscribe,subscribe_time,originId,originType,vdnId from t_mb_weixinuser where openid=? and vdnId = ?
Parameters: 1_90D5KHa3O_243fo(String), 1(String)
Total: 1

八、补充：mysql关键字查询

https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-L

天黑请​闭眼
关注
  • 27
    点赞
  • 踩
  • 19
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
mybatis报Error updating database. Cause: java.lang.NullPointerException: temporal
asunx的专栏
12-30 9762
@Error updating database. Cause: java.lang.NullPointerException: temporalTOC
### Error updating database. Cause: java.lang.NullPointerException ### Cause: java.lang.NullPointer
HUACONG_zhizun的博客
01-24 9924
找了大半天原因，最后发现是xml里面的标签在作祟，气死我了 不知道是mybatis-plus的原因还是mybatis的原因把delete换成selete就好了我也是醉了啊
关于java中向数据库中插入数据时，报错Caused by: java.lang.NullPointerException的问题
qq_20565303的专栏
06-29 4万+
今天在实现一个update数据时出现一个错误； org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.lang.NullPointerEx
Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 不能将值 NULL 插入列 ‘id‘
子豪的博客
07-20 2044
项目本来好好的,结果启动不起来了.解决方法重启redis。
mybatis小问题记录下.update 更新数据nullpoint问题.
LIUHUA121的博客
12-23 2638
图中所见,updateZeroHotRate方法其实并不需要参数.但是当把参数差点以后,如下图所示 此时会报错,错误信息如下: ### Error updating database. Cause: java.lang.NullPointerException ### Cause: java.lang.NullPointerException org.mybatis.spri...
SVN报错:Error Updating changes:svn:E155037的解决方案
08-26
今天小编就为大家分享一篇关于SVN报错:Error Updating changes:svn:E155037的解决方案，小编觉得内容挺不错的，现在分享给大家，具有很好的参考价值，需要的朋友一起跟随小编来看看吧
MySQL 启动报错:File ./mysql-bin.index not found (Errcode: 13)
12-15
Linux下安装初始化完MySQL数据库之后，使用mysqld_safe启动mysql数据库，如下发现，启动失败 [root@SVNServer bin]# ./mysqld_safe –user=mysql& 或 [root@SVNServer bin]# /etc/init.d/mysqld start Starting ...
geoip2.database包 GeoLite2-City.mmdb
10-23
geoip2 可解析出ip的位置和所在城市等信息，GeoLite2-City.mmdb数据库，仅供学习使用。
paper::rainbow: 一个类纸风的主题paper:party_popper:(still updating...)
05-27
paper :artist_palette: paper 是一个简洁，没有过多冗余视觉元素和功能的 hexo 主题，其设计风格的灵感来源于:newspaper: 报纸等纸质读物。而且主题以一种:light_bulb:极其巧妙的方式实现了当下(2019)流行的:last_...
Starting MySQL.Manager of pid-file quit without updating file.[FAILED]的解决方法
09-11
标题中的“Starting MySQL.Manager of pid-file quit without updating file.[FAILED]”是一个常见的MySQL启动时的错误信息，这表明MySQL服务在尝试启动时遇到了问题。这个错误通常与MySQL服务器的进程ID（PID）文件...
myBatis中java.lang.NullPointerException
love123111111的博客
07-16 3050
### Error updating database. Cause: java.lang.NullPointerException ### The error may exist in file [E:\IDEAFOLDER\springboot_project\springboot-data-jdbc\target\classes\mybatis\mapper\EmployeeMapper.xml] ### The error may involve defaultParameterMap ###
SpringBoot项目报错: Cause: java.lang.NullPointerException] with root cause
lst1917137725的博客
11-23 1万+
在集成SpringBoot框架的过程中，遇到的错误，记录下解决办法。 如果有需要，可以看我之前的博客，了解一下SpringBoot框架如何集成代码逆向生成插件generator、集成mybatis持久层框架、配置Druid数据源等。 SpringBoot+Mybatis-Generator+Mybatis+Druid+Pagehelper+Swagger2环境搭建 报错： 2018-11-02 1...
使用Mybatis报错:java.lang.NullPointerException排查方案
JavaEdge全是干货的技术号
11-23 2万+
nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.lang.NullPointerException ### The error may involve com.hzgroup.switchproject.dao.inter.mysql.DistributionBookingDao.updateByPrimaryKeySelecti
向数据库添加数据出现java.lang.NullPointerException
m0_52228992的博客
01-10 405
向数据库中新增一条数据，出现。
java mybatis 关于中向数据库中插入数据时，报错java.lang.NullPointerException的问题
Bonnenults浅时光的博客
07-11 1万+
今天在实现想MySQL的数据库一个insert数据时出现一个错误； org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.lang....
问题Error querying database. Cause: java.lang.NullPointerException解决方法
weixin_43878062的博客
01-27 1万+
Error querying database. Cause: java.lang.NullPointerException 遇到此类问题主要主要查看springBoot配置文件与实际配置jdbc类的是否配置成功 错误原因 注意我这配置的是Spring.datasource.xxx 配置文件 application.properties spring.datasource.url=jdbc:mysql://localhost:3306/springboot spring.datasource.user
出现java.lang.NullPointerException的可能原因及解决方案
热门推荐
IT学习小镇
03-23 6万+
综上所述，最常见的原因是对象未被正确初始化或者有 null 值的参数、数组或集合。因此，开发人员需要避免这些情况并进行适当的错误处理。
Error updating database. Cause: java.lang.NullPointerException
最新发布
04-09
当出现"Error updating database. Cause: java.lang.NullPointerException"的错误时，意味着在更新数据库时发生了空指针异常。空指针异常通常是由于代码中使用了一个空对象引用而导致的。 要解决这个问题，你可以按照以下步骤进行排查和修复： 1. 检查代码中的空引用：查找可能导致空指针异常的代码行，特别是涉及到数据库更新的代码。确保在使用对象之前进行了有效的空值检查，或者在使用对象之前对其进行初始化。 2. 检查数据库连接：确保数据库连接已经正确地建立，并且在更新数据库之前没有被关闭或中断。如果数据库连接出现问题，可能会导致空指针异常。 3. 检查数据库表和字段：确保数据库表和字段的名称、类型和约束与代码中的操作一致。如果表或字段不存在或发生了变化，可能会导致空指针异常。 4. 使用日志进行调试：在代码中添加适当的日志输出，以便在发生异常时能够追踪错误的原因。通过查看日志信息，你可以更好地理解发生异常的位置和原因。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值