You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/01/29 13:23:01 UTC
[GitHub] [shardingsphere] messi2094 opened a new issue #9224: Error querying database. Cause: java.lang.NullPointerException
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:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu commented on issue #9224: Error querying database. Cause: java.lang.NullPointerException
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #9224:
URL: https://github.com/apache/shardingsphere/issues/9224#issuecomment-774609254
@messi2094 What version do you use?
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #9224: Error querying database. Cause: java.lang.NullPointerException
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9224:
URL: https://github.com/apache/shardingsphere/issues/9224
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #9224: Error querying database. Cause: java.lang.NullPointerException
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #9224:
URL: https://github.com/apache/shardingsphere/issues/9224#issuecomment-927251560
No response anymore
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org