org.springframework.dao.DataIntegrityViolationException:
### Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'post_value' at row 1
### The error may involve com.kyexpress.crm.offer.fee.provider.mapper.ValueAddedFeeAuthDetailMapper.batchUpdateSelective-Inline
### The error occurred while setting parameters
### SQL: update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_value = ?, post_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, post_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, post_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, post_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, post_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, post_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, post_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, post_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ? ; update value_added_fee_auth_detail SET value_added_fee_auth_id = ?, position_level = ?, field_en = ?, field_cn = ?, auth_type = ?, auth_value = ?, condition_type = ?, front_condition = ?, post_condition = ?, front_value = ?, post_value = ?, order_number = ?, updated_by = ?, updation_date = ?, enabled_flag = ?, trace_id = ? where id = ?
### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'post_value' at row 1
; SQL []; Data truncation: Out of range value for column 'post_value' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'post_value' at row 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy165.update(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy465.batchUpdateSelective(Unknown Source)
at com.kyexpress.framework.service.GenericService.lambda$batchUpdateSelective$3(GenericService.java:252)
at com.kyexpress.framework.service.GenericService.doBatchUpdate(GenericService.java:776)
at com.kyexpress.framework.service.GenericService.batchUpdateSelective(GenericService.java:250)
at com.kyexpress.crm.offer.fee.provider.service.valueadded.ValueAddedFeeAuthDetailService.update(ValueAddedFeeAuthDetailService.java:76)
at com.kyexpress.crm.offer.fee.provider.service.valueadded.ValueAddedFeeAuthDetailService$$FastClassBySpringCGLIB$$13044a31.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
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:673)
at com.kyexpress.crm.offer.fee.provider.service.valueadded.ValueAddedFeeAuthDetailService$$EnhancerBySpringCGLIB$$912bed37.update(<generated>)
at com.kyexpress.crm.offer.fee.provider.controller.ValueAddedFeeAuthController.update(ValueAddedFeeAuthController.java:80)
at com.kyexpress.crm.offer.fee.provider.controller.ValueAddedFeeAuthController$$FastClassBySpringCGLIB$$41767a43.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at com.kyexpress.framework.validator.spring.interceptor.ValidatorControllerMethodInterceptor.invoke(ValidatorControllerMethodInterceptor.java:219)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
at com.kyexpress.crm.offer.fee.provider.controller.ValueAddedFeeAuthController$$EnhancerBySpringCGLIB$$22024eb6.update(<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:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at com.kyexpress.framework.permission.filter.PermissionFilter.doFilter(PermissionFilter.java:113)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at com.kyexpress.framework.gray.filter.GrayFilter.doFilter(GrayFilter.java:63)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at com.kyexpress.framework.debug.filter.DebugFilter.doFilter(DebugFilter.java:56)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at com.kyexpress.framework.web.filter.WebFilter.doFilter(WebFilter.java:97)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at com.kyexpress.framework.tracer.sofa.springmvc.SpringMvcSofaTracerFilter.doFilter(SpringMvcSofaTracerFilter.java:153)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:211)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:809)
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: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'post_value' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3971)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2490)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at io.shardingsphere.core.executor.prepared.PreparedStatementExecutor$3.executeSQL(PreparedStatementExecutor.java:105)
at io.shardingsphere.core.executor.prepared.PreparedStatementExecutor$3.executeSQL(PreparedStatementExecutor.java:101)
at io.shardingsphere.core.executor.sql.execute.SQLExecuteCallback.execute0(SQLExecuteCallback.java:81)
at io.shardingsphere.core.executor.sql.execute.SQLExecuteCallback.execute(SQLExecuteCallback.java:59)
at io.shardingsphere.core.executor.sql.execute.SQLExecuteCallback.execute(SQLExecuteCallback.java:46)
at io.shardingsphere.core.executor.ShardingExecuteEngine.syncExecute(ShardingExecuteEngine.java:106)
at io.shardingsphere.core.executor.ShardingExecuteEngine.execute(ShardingExecuteEngine.java:88)
at io.shardingsphere.core.executor.sql.execute.SQLExecuteTemplate.execute(SQLExecuteTemplate.java:75)
at io.shardingsphere.core.executor.sql.execute.SQLExecuteTemplate.execute(SQLExecuteTemplate.java:56)
at io.shardingsphere.core.executor.prepared.MemoryStrictlyPreparedStatementExecutor.executeCallback(MemoryStrictlyPreparedStatementExecutor.java:47)
at io.shardingsphere.core.executor.prepared.PreparedStatementExecutor.execute(PreparedStatementExecutor.java:108)
at io.shardingsphere.core.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:189)
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.$Proxy511.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 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.Invocation.proceed(Invocation.java:49)
at com.kyexpress.framework.tracer.sofa.config.processor.MybatisTraceInterceptor.intercept(MybatisTraceInterceptor.java:47)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy510.update(Unknown Source)
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.$Proxy509.update(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.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
at com.sun.proxy.$Proxy509.update(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.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.kyexpress.framework.interceptor.SelectColumnsInterceptor.intercept(SelectColumnsInterceptor.java:54)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy509.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
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
经过检查发现
post_value在数据库的类型和范围取值如下
说明长度最大为8位,最多两位小数。
触发报错场景是:前端输入的位数超过了decimal设置的范围导致报错,
解决办法:改变如下字段的decimal范围由8改为12
即可入参传入10亿的参数,即可解决报错问题!