关于Class MyBatisPagingItemReader<T> 读取数据只读第一条分页数据就结束了问题

都是单条单表数据进行导入使用的JdbcPagingItemReader<T>设置分页参数，就可以分页读取。现在导入数据需要维护层级关系，使用jdbc完全不可以满足关系

进而选择MyBatisPagingItemReader<T>, 使用mabatis维持层级关系，问题来了：当我设置分页参数为500的时候，返回的结果list是420，然后springBatch就没有继续往下读取了？

解决办法： 使用联合查询的时候，设置了分页参数是500，必须保证返回结果是500.当少于了500 batch会判定为最后一页，标记读取结束，程序读取就结束了

问题2：项目中会出现sql不报错（如果sql报错，会有日志打印，debug模式），但是springBatch查不出结果？最坑爹的日志也没有报错？

解决思路：这个原因很有可能是、resultMap中对应字段和实体中的对应字段不匹配。这个只能逐个检查了。（这个小问题坑了我好几个小时）

这个是修正后的xml  分页查询代码。必须保证left join 左边是500条 （不重复）订单记录

  <select id="selectOrderAndOrderLine" resultMap="CommonResultMap">

   select 

  temp_a.*,

  sol.id as line_id,

  sol.so_id as line_so_id,

  sol.item_meal_name as line_item_meal_name,

  sol.pic_path  as line_pic_path,

  sol.seller_nick    as    line_seller_nick  ,

  sol.buyer_nick     as    line_buyer_nick  ,

  sol.refund_status  as    line_refund_status  ,

  sol.outer_iid      as    line_outer_iid  ,

  sol.snapshot_url   as  line_snapshot_url  ,

  sol.snapshot       as  line_snapshot  ,

  sol.timeout_action_time  as  line_timeout_action_time  ,

  sol.buyer_rate  as  line_buyer_rate  ,

  sol.seller_rate  as  line_seller_rate  ,

  sol.seller_type  as  line_seller_type  ,

  sol.cid  as  line_cid  ,

  sol.sub_order_tax_fee  as  line_sub_order_tax_fee  ,

  sol.sub_order_tax_rate  as  line_sub_order_tax_rate  ,

  sol.oid  as  line_oid  ,

  sol.status  as  line_status  ,

  sol.title  as  line_title  ,

  sol.type  as  line_type  ,

  sol.iid  as  line_iid  ,

  sol.price  as  line_price  ,

  sol.num_iid  as  line_num_iid  ,

  sol.item_meal_id  as  line_item_meal_id  ,

  sol.sku_id  as  line_sku_id  ,

  sol.num  as  line_num  ,

  sol.outer_sku_id  as  line_outer_sku_id  ,

  sol.order_from  as  line_order_from  ,

  sol.total_fee  as  line_total_fee  ,

  sol.payment  as  line_payment  ,

  sol.discount_fee  as  line_discount_fee  ,

  sol.adjust_fee  as  line_adjust_fee  ,

  sol.modified  as  line_modified  ,

  sol.sku_properties_name  as  line_sku_properties_name  ,

  sol.refund_id  as  line_refund_id  ,

  sol.is_oversold  as  line_is_oversold  ,

  sol.is_service_order  as  line_is_service_order  ,

  sol.end_time  as  line_end_time  ,

  sol.consign_time  as  line_consign_time  ,

  sol.order_attr  as  line_order_attr  ,

  sol.shipping_type  as  line_shipping_type  ,

  sol.bind_oid  as  line_bind_oid  ,

  sol.logistics_company  as  line_logistics_company  ,

  sol.invoice_no  as  line_invoice_no  ,

  sol.is_daixiao  as  line_is_daixiao  ,

  sol.divide_order_fee  as  line_divide_order_fee  ,

  sol.part_mjz_discount  as  line_part_mjz_discount  ,

  sol.ticket_outer_id  as  line_ticket_outer_id  ,

  sol.ticket_expdate_key  as  line_ticket_expdate_key  ,

  sol.store_code  as  line_store_code  ,

  sol.is_www  as  line_is_www  ,

  sol.tmser_spu_code  as  line_tmser_spu_code  ,

  sol.bind_oids  as  line_bind_oids  ,

  sol.zhengji_status  as  line_zhengji_status  ,

  sol.md_qualification  as  line_md_qualification  ,

  sol.md_fee  as  line_md_fee  ,

  sol.customization  as  line_customization  ,

  sol.inv_type  as  line_inv_type  ,

  sol.is_sh_ship  as  line_is_sh_ship  ,

  sol.shipper  as  line_shipper  ,

  sol.f_type  as  line_f_type  ,

  sol.f_status  as  line_f_status  ,

  sol.f_term  as  line_f_term  ,

  sol.assembly_rela  as  line_assembly_rela  ,

  sol.assembly_price  as  line_assembly_price  ,

  sol.assembly_item  as  line_assembly_item  ,

  sol.last_modified_time  as  line_last_modified_time  ,

  sol.create_time  as  line_create_time 

       from 

(

SELECT so.* FROM t_tm_sales_order so 

where so.last_modified_time >= to_timestamp('2015-05-05','yyyy-mm-dd hh24:mi:ss') 

order by so.id limit #{_pagesize} OFFSET #{_skiprows}  

) temp_a 

inner join t_tm_sales_order_line sol on temp_a.id=sol.so_id 

  </select>

  resultMap  如下

    <resultMap id="BaseResultMap" type="cn.baozun.entity.ods.crm.TmSalesOrder">

    <id column="id" jdbcType="BIGINT" property="id" />

    <result column="seller_nick" jdbcType="VARCHAR" property="sellerNick" />

    <result column="pic_path" jdbcType="VARCHAR" property="picPath" />

    <result column="payment" jdbcType="NUMERIC" property="payment" />

    <result column="seller_rate" jdbcType="INTEGER" property="sellerRate" />

    <result column="post_fee" jdbcType="NUMERIC" property="postFee" />

    <result column="receiver_name" jdbcType="VARCHAR" property="receiverName" />

    <result column="receiver_state" jdbcType="VARCHAR" property="receiverState" />

    <result column="receiver_address" jdbcType="VARCHAR" property="receiverAddress" />

    <result column="receiver_zip" jdbcType="VARCHAR" property="receiverZip" />

    <result column="receiver_mobile" jdbcType="VARCHAR" property="receiverMobile" />

    <result column="receiver_phone" jdbcType="VARCHAR" property="receiverPhone" />

    <result column="consign_time" jdbcType="TIMESTAMP" property="consignTime" />

    <result column="received_payment" jdbcType="NUMERIC" property="receivedPayment" />

    <result column="est_con_time" jdbcType="TIMESTAMP" property="estConTime" />

    <result column="invoice_kind" jdbcType="INTEGER" property="invoiceKind" />

    <result column="receiver_country" jdbcType="VARCHAR" property="receiverCountry" />

    <result column="receiver_town" jdbcType="VARCHAR" property="receiverTown" />

    <result column="order_tax_fee" jdbcType="NUMERIC" property="orderTaxFee" />

    <result column="paid_coupon_fee" jdbcType="NUMERIC" property="paidCouponFee" />

    <result column="shop_pick" jdbcType="VARCHAR" property="shopPick" />

    <result column="tid" jdbcType="BIGINT" property="tid" />

    <result column="num" jdbcType="NUMERIC" property="num" />

    <result column="num_iid" jdbcType="BIGINT" property="numIid" />

    <result column="status" jdbcType="VARCHAR" property="status" />

    <result column="title" jdbcType="VARCHAR" property="title" />

    <result column="type" jdbcType="VARCHAR" property="type" />

    <result column="price" jdbcType="NUMERIC" property="price" />

    <result column="discount_fee" jdbcType="NUMERIC" property="discountFee" />

    <result column="has_post_fee" jdbcType="INTEGER" property="hasPostFee" />

    <result column="total_fee" jdbcType="NUMERIC" property="totalFee" />

    <result column="created" jdbcType="TIMESTAMP" property="created" />

    <result column="pay_time" jdbcType="TIMESTAMP" property="payTime" />

    <result column="modified" jdbcType="TIMESTAMP" property="modified" />

    <result column="end_time" jdbcType="TIMESTAMP" property="endTime" />

    <result column="buyer_message" jdbcType="VARCHAR" property="buyerMessage" />

    <result column="buyer_memo" jdbcType="VARCHAR" property="buyerMemo" />

    <result column="buyer_flag" jdbcType="BIGINT" property="buyerFlag" />

    <result column="seller_memo" jdbcType="VARCHAR" property="sellerMemo" />

    <result column="seller_flag" jdbcType="BIGINT" property="sellerFlag" />

    <result column="invoice_name" jdbcType="VARCHAR" property="invoiceName" />

    <result column="invoice_type" jdbcType="VARCHAR" property="invoiceType" />

    <result column="buyer_nick" jdbcType="VARCHAR" property="buyerNick" />

    <result column="trade_attr" jdbcType="VARCHAR" property="tradeAttr" />

    <result column="credit_card_fee" jdbcType="NUMERIC" property="creditCardFee" />

    <result column="step_trade_status" jdbcType="VARCHAR" property="stepTradeStatus" />

    <result column="step_paid_fee" jdbcType="NUMERIC" property="stepPaidFee" />

    <result column="mark_desc" jdbcType="VARCHAR" property="markDesc" />

    <result column="shipping_type" jdbcType="VARCHAR" property="shippingType" />

    <result column="buyer_cod_fee" jdbcType="NUMERIC" property="buyerCodFee" />

    <result column="adjust_fee" jdbcType="NUMERIC" property="adjustFee" />

    <result column="trade_from" jdbcType="VARCHAR" property="tradeFrom" />

    <result column="buyer_rate" jdbcType="INTEGER" property="buyerRate" />

    <result column="receiver_city" jdbcType="VARCHAR" property="receiverCity" />

    <result column="receiver_district" jdbcType="VARCHAR" property="receiverDistrict" />

    <result column="o2o" jdbcType="VARCHAR" property="o2o" />

    <result column="o2o_guide_id" jdbcType="VARCHAR" property="o2oGuideId" />

    <result column="o2o_shop_id" jdbcType="VARCHAR" property="o2oShopId" />

    <result column="o2o_guide_name" jdbcType="VARCHAR" property="o2oGuideName" />

    <result column="o2o_shop_name" jdbcType="VARCHAR" property="o2oShopName" />

    <result column="o2o_delivery" jdbcType="VARCHAR" property="o2oDelivery" />

    <result column="coupon_fee" jdbcType="NUMERIC" property="couponFee" />

    <result column="o2o_et_order_id" jdbcType="VARCHAR" property="o2oEtOrderId" />

    <result column="post_gate_declare" jdbcType="INTEGER" property="postGateDeclare" />

    <result column="cross_bonded_declare" jdbcType="INTEGER" property="crossBondedDeclare" />

    <result column="assembly" jdbcType="INTEGER" property="assembly" />

    <result column="last_modified_time" jdbcType="TIMESTAMP" property="lastModifiedTime" />

    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />

    <result column="rawdata_id" jdbcType="INTEGER" property="rawdataId" />

    <result column="platform_id" jdbcType="VARCHAR" property="platformId" />

  </resultMap>

  <!-- orderlineMap  主要是order  表中的字段和line表中的字段有相同的，干脆统一去别名 -->

    <resultMap id="OrderlineMap" type="cn.baozun.entity.ods.crm.TmSalesOrderLine">

    <result column="line_id" jdbcType="BIGINT" property="id" />

    <result column="line_so_id" jdbcType="BIGINT" property="soId" />

    <result column="line_item_meal_name" jdbcType="VARCHAR" property="itemMealName" />

    <result column="line_pic_path" jdbcType="VARCHAR" property="picPath" />

    <result column="line_seller_nick" jdbcType="VARCHAR" property="sellerNick" />

    <result column="line_buyer_nick" jdbcType="VARCHAR" property="buyerNick" />

    <result column="line_refund_status" jdbcType="VARCHAR" property="refundStatus" />

    <result column="line_outer_iid" jdbcType="VARCHAR" property="outerIid" />

    <result column="line_snapshot_url" jdbcType="VARCHAR" property="snapshotUrl" />

    <result column="line_snapshot" jdbcType="VARCHAR" property="snapshot" />

    <result column="line_timeout_action_time" jdbcType="TIMESTAMP" property="timeoutActionTime" />

    <result column="line_buyer_rate" jdbcType="INTEGER" property="buyerRate" />

    <result column="line_seller_rate" jdbcType="INTEGER" property="sellerRate" />

    <result column="line_seller_type" jdbcType="VARCHAR" property="sellerType" />

    <result column="line_cid" jdbcType="BIGINT" property="cid" />

    <result column="line_sub_order_tax_fee" jdbcType="NUMERIC" property="subOrderTaxFee" />

    <result column="line_sub_order_tax_rate" jdbcType="NUMERIC" property="subOrderTaxRate" />

    <result column="line_oid" jdbcType="BIGINT" property="oid" />

    <result column="line_status" jdbcType="VARCHAR" property="status" />

    <result column="line_title" jdbcType="VARCHAR" property="title" />

    <result column="line_type" jdbcType="VARCHAR" property="type" />

    <result column="line_iid" jdbcType="VARCHAR" property="iid" />

    <result column="line_price" jdbcType="VARCHAR" property="price" />

    <result column="line_num_iid" jdbcType="BIGINT" property="numIid" />

    <result column="line_item_meal_id" jdbcType="INTEGER" property="itemMealId" />

    <result column="line_sku_id" jdbcType="BIGINT" property="skuId" />

    <result column="line_num" jdbcType="INTEGER" property="num" />

    <result column="line_outer_sku_id" jdbcType="VARCHAR" property="outerSkuId" />

    <result column="line_order_from" jdbcType="VARCHAR" property="orderFrom" />

    <result column="line_total_fee" jdbcType="NUMERIC" property="totalFee" />

    <result column="line_payment" jdbcType="NUMERIC" property="payment" />

    <result column="line_discount_fee" jdbcType="NUMERIC" property="discountFee" />

    <result column="line_adjust_fee" jdbcType="NUMERIC" property="adjustFee" />

    <result column="line_modified" jdbcType="TIMESTAMP" property="modified" />

    <result column="line_sku_properties_name" jdbcType="VARCHAR" property="skuPropertiesName" />

    <result column="line_refund_id" jdbcType="BIGINT" property="refundId" />

    <result column="line_is_oversold" jdbcType="INTEGER" property="isOversold" />

    <result column="line_is_service_order" jdbcType="INTEGER" property="isServiceOrder" />

    <result column="line_end_time" jdbcType="TIMESTAMP" property="endTime" />

    <result column="line_consign_time" jdbcType="TIMESTAMP" property="consignTime" />

    <result column="line_order_attr" jdbcType="VARCHAR" property="orderAttr" />

    <result column="line_shipping_type" jdbcType="VARCHAR" property="shippingType" />

    <result column="line_bind_oid" jdbcType="BIGINT" property="bindOid" />

    <result column="line_logistics_company" jdbcType="VARCHAR" property="logisticsCompany" />

    <result column="line_invoice_no" jdbcType="VARCHAR" property="invoiceNo" />

    <result column="line_is_daixiao" jdbcType="INTEGER" property="isDaixiao" />

    <result column="line_divide_order_fee" jdbcType="NUMERIC" property="divideOrderFee" />

    <result column="line_part_mjz_discount" jdbcType="NUMERIC" property="partMjzDiscount" />

    <result column="line_ticket_outer_id" jdbcType="VARCHAR" property="ticketOuterId" />

    <result column="line_ticket_expdate_key" jdbcType="VARCHAR" property="ticketExpdateKey" />

    <result column="line_store_code" jdbcType="VARCHAR" property="storeCode" />

    <result column="line_is_www" jdbcType="INTEGER" property="isWww" />

    <result column="line_tmser_spu_code" jdbcType="VARCHAR" property="tmserSpuCode" />

    <result column="line_bind_oids" jdbcType="VARCHAR" property="bindOids" />

    <result column="line_zhengji_status" jdbcType="INTEGER" property="zhengjiStatus" />

    <result column="line_md_qualification" jdbcType="VARCHAR" property="mdQualification" />

    <result column="line_md_fee" jdbcType="NUMERIC" property="mdFee" />

    <result column="line_customization" jdbcType="VARCHAR" property="customization" />

    <result column="line_inv_type" jdbcType="VARCHAR" property="invType" />

    <result column="line_is_sh_ship" jdbcType="INTEGER" property="isShShip" />

    <result column="line_shipper" jdbcType="VARCHAR" property="shipper" />

    <result column="line_f_type" jdbcType="VARCHAR" property="fType" />

    <result column="line_f_status" jdbcType="VARCHAR" property="fStatus" />

    <result column="line_f_term" jdbcType="VARCHAR" property="fTerm" />

    <result column="line_assembly_rela" jdbcType="VARCHAR" property="assemblyRela" />

    <result column="line_assembly_price" jdbcType="NUMERIC" property="assemblyPrice" />

    <result column="line_assembly_item" jdbcType="VARCHAR" property="assemblyItem" />

    <result column="line_last_modified_time" jdbcType="TIMESTAMP" property="lastModifiedTime" />

    <result column="line_create_time" jdbcType="TIMESTAMP" property="createTime" />

    <result column="line_platform_id" jdbcType="VARCHAR" property="platformId" />

  </resultMap>

    <!--为减少数据库IO，使用一对多查询出关联信息-->

  <resultMap id="CommonResultMap" type="cn.baozun.entity.ods.crm.TmSalesOrder" extends="BaseResultMap" >

    <collection property="orderLineList" resultMap="OrderlineMap" />

  </resultMap>