messi2094 opened a new issue #9224:
URL: https://github.com/apache/shardingsphere/issues/9224
2021-01-29 21:03:51:934 [http-nio-8082-exec-1] DEBUG
com.bitsun.bizcenter.tc.infrastructure.persistence.dao.OrderMapper.getOrderDetailList.debug
(getOrderDetailList.java 143) - ==> Preparing: SELECT a.*, b.id AS
orderline_id, b.brand_code AS orderline_brand_code, b.order_no AS
orderline_order_no, b.sku_id AS orderline_sku_id, b.item_code AS
orderline_item_code, b.item_name AS orderline_item_name, b.sku_quantity AS
orderline_sku_quantity, b.origin_price AS orderline_origin_price, b.class_code
AS orderline_class_code, b.packing_unit AS orderline_packing_unit,
b.storage_quantity AS orderline_storage_quantity, b.sku_type AS
orderline_sku_type, b.create_user_id AS orderline_create_user_id,
b.create_user_name AS orderline_create_user_name, b.create_time AS
orderline_create_time, b.modify_user_id AS orderline_modify_user_id,
b.modify_user_name AS orderline_modify_user_name, b.modify_time AS
orderline_modify_time, b.sku_code AS orderline_sku_code, b.adjust_price AS
orderline_adjust_price
, b.member_discount AS orderline_member_discount, b.member_discount_amount AS
orderline_member_discount_amount, b.sales_price AS orderline_sales_price,
b.sales_amount AS orderline_sales_amount, b.brand_discount_amount AS
orderline_brand_discount_amount, b.general_discount_amount AS
orderline_general_discount_amount, b.point_deduction_amount AS
orderline_point_deduction_amount, b.mall_vip_discount AS
orderline_mall_vip_discount, b.mall_vip_discount_amount AS
orderline_mall_vip_discount_amount, b.actual_amount AS orderline_actual_amount,
b.multiple_point AS orderline_multiple_point, b.point AS orderline_point,
b.special_offer_price AS orderline_special_offer_price, b.special_offer_flag AS
orderline_special_offer_flag, b.promotion_no AS orderline_promotion_no,
b.sap_sale_price AS orderline_sap_sale_price, b.manual_change_price AS
orderline_manual_change_price, b.change_price AS orderline_change_price,
b.same_type AS orderline_same_type, b.promotion_remark AS
orderline_promotion_remark,
b.match_main_order_line AS orderline_match_main_order_line,
b.main_order_line_id AS orderline_main_order_line_id, b.order_line_id AS
orderline_order_line_id, b.enjoy_point AS orderline_enjoy_point, b.remark AS
orderline_remark, b.over_mall_discount_amount AS
orderline_over_mall_discount_amount, b.empty_sale_quantity AS
orderline_empty_sale_quantity, b.skc_id AS orderline_skc_id, b.skc_code AS
orderline_skc_code, b.store_code AS orderline_store_code,
b.order_line_promotion_info AS orderline_order_line_promotion_info,
b.point_used_amount AS orderline_point_used_amount, b.settlement_type,
b.promotion_amount, b.overcharge_amt AS orderline_overcharge_amt FROM tc_order
a LEFT JOIN tc_order_line b ON a.order_no = b.order_no AND b.deleted = 'f' AND
b.tenant_id = 1 WHERE (a.ORDER_NO = ? AND a.CREATE_TIME >= ? AND a.STORE_CODE =
?) AND a.deleted = 'f' AND a.tenant_id = 1
2021-01-29 21:03:51:938 [http-nio-8082-exec-1] DEBUG
com.bitsun.bizcenter.tc.infrastructure.persistence.dao.OrderMapper.getOrderDetailList.debug
(getOrderDetailList.java 143) - ==> Preparing: SELECT a.*, b.id AS
orderline_id, b.brand_code AS orderline_brand_code, b.order_no AS
orderline_order_no, b.sku_id AS orderline_sku_id, b.item_code AS
orderline_item_code, b.item_name AS orderline_item_name, b.sku_quantity AS
orderline_sku_quantity, b.origin_price AS orderline_origin_price, b.class_code
AS orderline_class_code, b.packing_unit AS orderline_packing_unit,
b.storage_quantity AS orderline_storage_quantity, b.sku_type AS
orderline_sku_type, b.create_user_id AS orderline_create_user_id,
b.create_user_name AS orderline_create_user_name, b.create_time AS
orderline_create_time, b.modify_user_id AS orderline_modify_user_id,
b.modify_user_name AS orderline_modify_user_name, b.modify_time AS
orderline_modify_time, b.sku_code AS orderline_sku_code, b.adjust_price AS
orderline_adjust_price
, b.member_discount AS orderline_member_discount, b.member_discount_amount AS
orderline_member_discount_amount, b.sales_price AS orderline_sales_price,
b.sales_amount AS orderline_sales_amount, b.brand_discount_amount AS
orderline_brand_discount_amount, b.general_discount_amount AS
orderline_general_discount_amount, b.point_deduction_amount AS
orderline_point_deduction_amount, b.mall_vip_discount AS
orderline_mall_vip_discount, b.mall_vip_discount_amount AS
orderline_mall_vip_discount_amount, b.actual_amount AS orderline_actual_amount,
b.multiple_point AS orderline_multiple_point, b.point AS orderline_point,
b.special_offer_price AS orderline_special_offer_price, b.special_offer_flag AS
orderline_special_offer_flag, b.promotion_no AS orderline_promotion_no,
b.sap_sale_price AS orderline_sap_sale_price, b.manual_change_price AS
orderline_manual_change_price, b.change_price AS orderline_change_price,
b.same_type AS orderline_same_type, b.promotion_remark AS
orderline_promotion_remark,
b.match_main_order_line AS orderline_match_main_order_line,
b.main_order_line_id AS orderline_main_order_line_id, b.order_line_id AS
orderline_order_line_id, b.enjoy_point AS orderline_enjoy_point, b.remark AS
orderline_remark, b.over_mall_discount_amount AS
orderline_over_mall_discount_amount, b.empty_sale_quantity AS
orderline_empty_sale_quantity, b.skc_id AS orderline_skc_id, b.skc_code AS
orderline_skc_code, b.store_code AS orderline_store_code,
b.order_line_promotion_info AS orderline_order_line_promotion_info,
b.point_used_amount AS orderline_point_used_amount, b.settlement_type,
b.promotion_amount, b.overcharge_amt AS orderline_overcharge_amt FROM tc_order
a LEFT JOIN tc_order_line b ON a.order_no = b.order_no AND b.deleted = 'f' AND
b.tenant_id = 1 WHERE (a.ORDER_NO = ? AND a.CREATE_TIME >= ? AND a.STORE_CODE =
?) AND a.deleted = 'f' AND a.tenant_id = 1
2021-01-29 21:03:51:942 [http-nio-8082-exec-1] DEBUG
com.bitsun.bizcenter.tc.infrastructure.persistence.dao.OrderMapper.getOrderDetailList.debug
(getOrderDetailList.java 143) - ==> Parameters: POS2020210100001(String),
2021-01-29T06:44:49(LocalDateTime), 12312(String)
line 1:1392 no viable alternative at input 'b.point'
line 1:1392 no viable alternative at input 'b.point'
2021-01-29 21:03:52:197 [http-nio-8082-exec-1] ERROR
com.bitsun.bizcenter.tc.api.config.TradeCenterExceptionHander.handleException
(TradeCenterExceptionHander.java 83) - nested exception is
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.NullPointerException
### The error may exist in file
[D:\code\anta\order-srv\bizcenter-tc-infrastructure\target\classes\mapper\OrderMapper.xml]
### The error may involve
com.bitsun.bizcenter.tc.infrastructure.persistence.dao.OrderMapper.getOrderDetailList-Inline
### The error occurred while setting parameters
### SQL: SELECT a.*, b.id AS orderline_id, b.brand_code AS
orderline_brand_code, b.order_no AS orderline_order_no, b.sku_id AS
orderline_sku_id, b.item_code AS orderline_item_code, b.item_name AS
orderline_item_name, b.sku_quantity AS orderline_sku_quantity, b.origin_price
AS orderline_origin_price, b.class_code AS orderline_class_code, b.packing_unit
AS orderline_packing_unit, b.storage_quantity AS orderline_storage_quantity,
b.sku_type AS orderline_sku_type, b.create_user_id AS orderline_create_user_id,
b.create_user_name AS orderline_create_user_name, b.create_time AS
orderline_create_time, b.modify_user_id AS orderline_modify_user_id,
b.modify_user_name AS orderline_modify_user_name, b.modify_time AS
orderline_modify_time, b.sku_code AS orderline_sku_code, b.adjust_price AS
orderline_adjust_price, b.member_discount AS orderline_member_discount,
b.member_discount_amount AS orderline_member_discount_amount, b.sales_price AS
orderline_sales_price, b.sales_amount AS orderline_sale
s_amount, b.brand_discount_amount AS orderline_brand_discount_amount,
b.general_discount_amount AS orderline_general_discount_amount,
b.point_deduction_amount AS orderline_point_deduction_amount,
b.mall_vip_discount AS orderline_mall_vip_discount, b.mall_vip_discount_amount
AS orderline_mall_vip_discount_amount, b.actual_amount AS
orderline_actual_amount, b.multiple_point AS orderline_multiple_point, b.point
AS orderline_point, b.special_offer_price AS orderline_special_offer_price,
b.special_offer_flag AS orderline_special_offer_flag, b.promotion_no AS
orderline_promotion_no, b.sap_sale_price AS orderline_sap_sale_price,
b.manual_change_price AS orderline_manual_change_price, b.change_price AS
orderline_change_price, b.same_type AS orderline_same_type, b.promotion_remark
AS orderline_promotion_remark, b.match_main_order_line AS
orderline_match_main_order_line, b.main_order_line_id AS
orderline_main_order_line_id, b.order_line_id AS orderline_order_line_id,
b.enjoy_point AS orderlin
e_enjoy_point, b.remark AS orderline_remark, b.over_mall_discount_amount AS
orderline_over_mall_discount_amount, b.empty_sale_quantity AS
orderline_empty_sale_quantity, b.skc_id AS orderline_skc_id, b.skc_code AS
orderline_skc_code, b.store_code AS orderline_store_code,
b.order_line_promotion_info AS orderline_order_line_promotion_info,
b.point_used_amount AS orderline_point_used_amount, b.settlement_type,
b.promotion_amount, b.overcharge_amt AS orderline_overcharge_amt FROM tc_order
a LEFT JOIN tc_order_line b ON a.order_no = b.order_no AND b.deleted = 'f' AND
b.tenant_id = 1 WHERE (a.ORDER_NO = ? AND a.CREATE_TIME >= ? AND a.STORE_CODE =
?) AND a.deleted = 'f' AND a.tenant_id = 1
### Cause: java.lang.NullPointerException
org.mybatis.spring.MyBatisSystemException: nested exception is
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.NullPointerException
### The error may exist in file
[D:\code\anta\order-srv\bizcenter-tc-infrastructure\target\classes\mapper\OrderMapper.xml]
### The error may involve
com.bitsun.bizcenter.tc.infrastructure.persistence.dao.OrderMapper.getOrderDetailList-Inline
### The error occurred while setting parameters
### SQL: SELECT a.*, b.id AS orderline_id, b.brand_code AS
orderline_brand_code, b.order_no AS orderline_order_no, b.sku_id AS
orderline_sku_id, b.item_code AS orderline_item_code, b.item_name AS
orderline_item_name, b.sku_quantity AS orderline_sku_quantity, b.origin_price
AS orderline_origin_price, b.class_code AS orderline_class_code, b.packing_unit
AS orderline_packing_unit, b.storage_quantity AS orderline_storage_quantity,
b.sku_type AS orderline_sku_type, b.create_user_id AS orderline_create_user_id,
b.create_user_name AS orderline_create_user_name, b.create_time AS
orderline_create_time, b.modify_user_id AS orderline_modify_user_id,
b.modify_user_name AS orderline_modify_user_name, b.modify_time AS
orderline_modify_time, b.sku_code AS orderline_sku_code, b.adjust_price AS
orderline_adjust_price, b.member_discount AS orderline_member_discount,
b.member_discount_amount AS orderline_member_discount_amount, b.sales_price AS
orderline_sales_price, b.sales_amount AS orderline_sale
s_amount, b.brand_discount_amount AS orderline_brand_discount_amount,
b.general_discount_amount AS orderline_general_discount_amount,
b.point_deduction_amount AS orderline_point_deduction_amount,
b.mall_vip_discount AS orderline_mall_vip_discount, b.mall_vip_discount_amount
AS orderline_mall_vip_discount_amount, b.actual_amount AS
orderline_actual_amount, b.multiple_point AS orderline_multiple_point, b.point
AS orderline_point, b.special_offer_price AS orderline_special_offer_price,
b.special_offer_flag AS orderline_special_offer_flag, b.promotion_no AS
orderline_promotion_no, b.sap_sale_price AS orderline_sap_sale_price,
b.manual_change_price AS orderline_manual_change_price, b.change_price AS
orderline_change_price, b.same_type AS orderline_same_type, b.promotion_remark
AS orderline_promotion_remark, b.match_main_order_line AS
orderline_match_main_order_line, b.main_order_line_id AS
orderline_main_order_line_id, b.order_line_id AS orderline_order_line_id,
b.enjoy_point AS orderlin
e_enjoy_point, b.remark AS orderline_remark, b.over_mall_discount_amount AS
orderline_over_mall_discount_amount, b.empty_sale_quantity AS
orderline_empty_sale_quantity, b.skc_id AS orderline_skc_id, b.skc_code AS
orderline_skc_code, b.store_code AS orderline_store_code,
b.order_line_promotion_info AS orderline_order_line_promotion_info,
b.point_used_amount AS orderline_point_used_amount, b.settlement_type,
b.promotion_amount, b.overcharge_amt AS orderline_overcharge_amt FROM tc_order
a LEFT JOIN tc_order_line b ON a.order_no = b.order_no AND b.deleted = 'f' AND
b.tenant_id = 1 WHERE (a.ORDER_NO = ? AND a.CREATE_TIME >= ? AND a.STORE_CODE =
?) AND a.deleted = 'f' AND a.tenant_id = 1
### Cause: java.lang.NullPointerException
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
at com.sun.proxy.$Proxy154.selectList(Unknown Source)
at
org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
at
com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)
at
com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)
at
com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)
at com.sun.proxy.$Proxy158.getOrderDetailList(Unknown Source)
at
com.bitsun.bizcenter.tc.domain.service.impl.OrderDomainServiceImpl.getOrderDetailList(OrderDomainServiceImpl.java:489)
at
com.bitsun.bizcenter.tc.domain.service.impl.OrderDomainServiceImpl$$FastClassBySpringCGLIB$$9ca6a505.invoke(<generated>)
at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
at
com.bitsun.bizcenter.tc.domain.service.impl.OrderDomainServiceImpl$$EnhancerBySpringCGLIB$$15ab97e5.getOrderDetailList(<generated>)
at
com.bitsun.bizcenter.tc.application.impl.OrderServiceImpl.getOrderDetailList(OrderServiceImpl.java:287)
at
com.bitsun.bizcenter.tc.application.impl.OrderServiceImpl$$FastClassBySpringCGLIB$$e0a1dca0.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.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at
com.bitsun.bizcenter.tc.application.impl.OrderServiceImpl$$EnhancerBySpringCGLIB$$35796.getOrderDetailList(<generated>)
at
com.bitsun.bizcenter.tc.api.rest.OrderApiController.getOrderDetailList(OrderApiController.java:111)
at
com.bitsun.bizcenter.tc.api.rest.OrderApiController$$FastClassBySpringCGLIB$$2a109657.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:100)
at
com.bitsun.bizcenter.tc.api.config.DataHintAspect.doAround(DataHintAspect.java:36)
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:186)
at
org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:100)
at
com.bitsun.core.common.web.WebLogAspect.doAround(WebLogAspect.java:93)
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:186)
at
org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:55)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
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.bitsun.bizcenter.tc.api.rest.OrderApiController$$EnhancerBySpringCGLIB$$a97444f8.getOrderDetailList(<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:190)
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
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.doGet(FrameworkServlet.java:897)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.bitsun.core.common.web.CorsFilter.doFilter(CorsFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:114)
at
org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:104)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:118)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
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:408)
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.NullPointerException
### The error may exist in file
[D:\code\anta\order-srv\bizcenter-tc-infrastructure\target\classes\mapper\OrderMapper.xml]
### The error may involve
com.bitsun.bizcenter.tc.infrastructure.persistence.dao.OrderMapper.getOrderDetailList-Inline
### The error occurred while setting parameters
### SQL: SELECT a.*, b.id AS orderline_id, b.brand_code AS
orderline_brand_code, b.order_no AS orderline_order_no, b.sku_id AS
orderline_sku_id, b.item_code AS orderline_item_code, b.item_name AS
orderline_item_name, b.sku_quantity AS orderline_sku_quantity, b.origin_price
AS orderline_origin_price, b.class_code AS orderline_class_code, b.packing_unit
AS orderline_packing_unit, b.storage_quantity AS orderline_storage_quantity,
b.sku_type AS orderline_sku_type, b.create_user_id AS orderline_create_user_id,
b.create_user_name AS orderline_create_user_name, b.create_time AS
orderline_create_time, b.modify_user_id AS orderline_modify_user_id,
b.modify_user_name AS orderline_modify_user_name, b.modify_time AS
orderline_modify_time, b.sku_code AS orderline_sku_code, b.adjust_price AS
orderline_adjust_price, b.member_discount AS orderline_member_discount,
b.member_discount_amount AS orderline_member_discount_amount, b.sales_price AS
orderline_sales_price, b.sales_amount AS orderline_sale
s_amount, b.brand_discount_amount AS orderline_brand_discount_amount,
b.general_discount_amount AS orderline_general_discount_amount,
b.point_deduction_amount AS orderline_point_deduction_amount,
b.mall_vip_discount AS orderline_mall_vip_discount, b.mall_vip_discount_amount
AS orderline_mall_vip_discount_amount, b.actual_amount AS
orderline_actual_amount, b.multiple_point AS orderline_multiple_point, b.point
AS orderline_point, b.special_offer_price AS orderline_special_offer_price,
b.special_offer_flag AS orderline_special_offer_flag, b.promotion_no AS
orderline_promotion_no, b.sap_sale_price AS orderline_sap_sale_price,
b.manual_change_price AS orderline_manual_change_price, b.change_price AS
orderline_change_price, b.same_type AS orderline_same_type, b.promotion_remark
AS orderline_promotion_remark, b.match_main_order_line AS
orderline_match_main_order_line, b.main_order_line_id AS
orderline_main_order_line_id, b.order_line_id AS orderline_order_line_id,
b.enjoy_point AS orderlin
e_enjoy_point, b.remark AS orderline_remark, b.over_mall_discount_amount AS
orderline_over_mall_discount_amount, b.empty_sale_quantity AS
orderline_empty_sale_quantity, b.skc_id AS orderline_skc_id, b.skc_code AS
orderline_skc_code, b.store_code AS orderline_store_code,
b.order_line_promotion_info AS orderline_order_line_promotion_info,
b.point_used_amount AS orderline_point_used_amount, b.settlement_type,
b.promotion_amount, b.overcharge_amt AS orderline_overcharge_amt FROM tc_order
a LEFT JOIN tc_order_line b ON a.order_no = b.order_no AND b.deleted = 'f' AND
b.tenant_id = 1 WHERE (a.ORDER_NO = ? AND a.CREATE_TIME >= ? AND a.STORE_CODE =
?) AND a.deleted = 'f' AND a.tenant_id = 1
### Cause: java.lang.NullPointerException
at
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
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:426)
... 120 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.postgresql.visitor.impl.PostgreSQLDMLVisitor.createProjection(PostgreSQLDMLVisitor.java:357)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitProjection(PostgreSQLDMLVisitor.java:345)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitProjection(PostgreSQLDMLVisitor.java:112)
at
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser$ProjectionContext.accept(PostgreSQLStatementParser.java:2416)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitProjections(PostgreSQLDMLVisitor.java:321)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitProjections(PostgreSQLDMLVisitor.java:112)
at
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser$ProjectionsContext.accept(PostgreSQLStatementParser.java:2152)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitSelectClause(PostgreSQLDMLVisitor.java:260)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitSelectClause(PostgreSQLDMLVisitor.java:112)
at
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser$SelectClauseContext.accept(PostgreSQLStatementParser.java:1989)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitUnionClause(PostgreSQLDMLVisitor.java:253)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitUnionClause(PostgreSQLDMLVisitor.java:112)
at
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser$UnionClauseContext.accept(PostgreSQLStatementParser.java:1896)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitSelect(PostgreSQLDMLVisitor.java:245)
at
org.apache.shardingsphere.sql.parser.postgresql.visitor.impl.PostgreSQLDMLVisitor.visitSelect(PostgreSQLDMLVisitor.java:112)
at
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser$SelectContext.accept(PostgreSQLStatementParser.java:1845)
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.$Proxy281.execute(Unknown Source)
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
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.$Proxy279.query(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.$Proxy279.query(Unknown Source)
at
com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:67)
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at
com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:155)
at
com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:90)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
... 126 common frames omitted
2021-01-29 21:03:52:277 [http-nio-8082-exec-1] WARN
org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.logException
(ExceptionHandlerExceptionResolver.java 198) - Resolved
[org.mybatis.spring.MyBatisSystemException: nested exception is
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.NullPointerException
### The error may exist in file
[D:\code\anta\order-srv\bizcenter-tc-infrastructure\target\classes\mapper\OrderMapper.xml]
### The error may involve
com.bitsun.bizcenter.tc.infrastructure.persistence.dao.OrderMapper.getOrderDetailList-Inline
### The error occurred while setting parameters
### SQL: SELECT a.*, b.id AS orderline_id, b.brand_code AS
orderline_brand_code, b.order_no AS orderline_order_no, b.sku_id AS
orderline_sku_id, b.item_code AS orderline_item_code, b.item_name AS
orderline_item_name, b.sku_quantity AS orderline_sku_quantity, b.origin_price
AS orderline_origin_price, b.class_code AS orderline_class_code, b.packing_unit
AS orderline_packing_unit, b.storage_quantity AS orderline_storage_quantity,
b.sku_type AS orderline_sku_type, b.create_user_id AS orderline_create_user_id,
b.create_user_name AS orderline_create_user_name, b.create_time AS
orderline_create_time, b.modify_user_id AS orderline_modify_user_id,
b.modify_user_name AS orderline_modify_user_name, b.modify_time AS
orderline_modify_time, b.sku_code AS orderline_sku_code, b.adjust_price AS
orderline_adjust_price, b.member_discount AS orderline_member_discount,
b.member_discount_amount AS orderline_member_discount_amount, b.sales_price AS
orderline_sales_price, b.sales_amount AS orderline_sale
s_amount, b.brand_discount_amount AS orderline_brand_discount_amount,
b.general_discount_amount AS orderline_general_discount_amount,
b.point_deduction_amount AS orderline_point_deduction_amount,
b.mall_vip_discount AS orderline_mall_vip_discount, b.mall_vip_discount_amount
AS orderline_mall_vip_discount_amount, b.actual_amount AS
orderline_actual_amount, b.multiple_point AS orderline_multiple_point, b.point
AS orderline_point, b.special_offer_price AS orderline_special_offer_price,
b.special_offer_flag AS orderline_special_offer_flag, b.promotion_no AS
orderline_promotion_no, b.sap_sale_price AS orderline_sap_sale_price,
b.manual_change_price AS orderline_manual_change_price, b.change_price AS
orderline_change_price, b.same_type AS orderline_same_type, b.promotion_remark
AS orderline_promotion_remark, b.match_main_order_line AS
orderline_match_main_order_line, b.main_order_line_id AS
orderline_main_order_line_id, b.order_line_id AS orderline_order_line_id,
b.enjoy_point AS orderlin
e_enjoy_point, b.remark AS orderline_remark, b.over_mall_discount_amount AS
orderline_over_mall_discount_amount, b.empty_sale_quantity AS
orderline_empty_sale_quantity, b.skc_id AS orderline_skc_id, b.skc_code AS
orderline_skc_code, b.store_code AS orderline_store_code,
b.order_line_promotion_info AS orderline_order_line_promotion_info,
b.point_used_amount AS orderline_point_used_amount, b.settlement_type,
b.promotion_amount, b.overcharge_amt AS orderline_overcharge_amt FROM tc_order
a LEFT JOIN tc_order_line b ON a.order_no = b.order_no AND b.deleted = 'f' AND
b.tenant_id = 1 WHERE (a.ORDER_NO = ? AND a.CREATE_TIME >= ? AND a.STORE_CODE =
?) AND a.deleted = 'f' AND a.tenant_id = 1
### Cause: java.lang.NullPointerException]
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
