mybatis timeout = 60 加上一个时间 可以让sql时间更长

引用

    <select id="financierRepay" parameterType="FmServiceFeeChargeRecord" resultType="FmServiceFeeChargeRecord" timeout="60">
        SELECT a.service_fee_charge_record_id,b.id as repay_record_id,a.service_entity_type,
        c.payment_amount as charge_amount,c.payment_date as create_date,d.account_id,
        d.`name` as account_name,c.assets_id,e.assets_name,e.assets_class,e.financier_id,e.financier_name,
        e.channel_partner_id,f.`name` as channel_partner_name from fm_service_fee_charge_record a
        LEFT JOIN fm_payment_records c on a.service_fee_charge_record_id = c.business_id
        LEFT JOIN fm_repay_record b on a.repay_record_id = b.id
        LEFT JOIN fm_account d on c.payment_account_id = d.account_id
  LEFT JOIN fm_service_fee_plan p on a.service_fee_charge_plan_id=p.service_fee_charge_plan_id
        LEFT JOIN fm_assets e on p.assets_id = e.assets_id
        LEFT JOIN fm_account f on e.channel_partner_id = f.account_id
        where b.id is not null and b.detail_voucher_id is null and DATE(b.trans_date)= #{createDate}
        and b.submit_regulatory_status=5 and b.repay_type in(1,2)
        and (b.repay_principal_amount !=0 or b.repay_interest_amount !=0)
        ORDER BY b.id,a.service_entity_type desc
    </select>

引用

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <properties resource="conf/sweeter-config.properties"/><!-- 提供jdbc.dialectclass -->
<settings>
<setting name="jdbcTypeForNull" value="NULL" /><!-- 空值的缺省 JDBC类型  -->
<setting name="logImpl" value="LOG4J2" />
<setting name="mapUnderscoreToCamelCase" value="true" /><!-- 开启驼峰命名规则映射  -->
<setting name="defaultStatementTimeout" value="30" />
</settings>
<plugins>
  <plugin interceptor="cn.evun.sweet.core.mybatis.page.PageHelper">
        <property name="dialect" value=""/><!-- 交由代码处理 -->
        <!-- 默认为false.设置为true时，会将RowBounds第一个参数offset当成pageNum页码使用-->
        <property name="offsetAsPageNum" value="true"/>
        <!-- 默认为false.设置为true时，使用RowBounds分页会进行count查询 -->
        <property name="rowBoundsWithCount" value="true"/>
        <!-- 设置为true时，如果pageSize=0或者RowBounds.limit = 0就会查询出全部的结果 ,（相当于没有执行分页查询，但是返回结果仍然是Page类型）-->
        <property name="pageSizeZero" value="true"/>
        <!-- 3.3.0版本可用 - 分页参数合理化，默认false禁用 -->
        <!-- 启用合理化时，如果pageNum<1会查询第一页，如果pageNum>pages会查询最后一页 -->
        <!-- 禁用合理化时，如果pageNum<1或pageNum>pages会返回空数据 -->
        <property name="reasonable" value="true"/>
        <!-- 3.5.0版本可用 - 为了支持startPage(Object params)方法 -->
        <!-- 增加了一个`params`参数来配置参数映射，用于从Map或ServletRequest中取值 -->
        <!-- 可以配置pageNum,pageSize,count,pageSizeZero,reasonable,不配置映射的用默认值 -->
        <property name="params" value="pageNum=start;pageSize=limit;pageSizeZero=zero;reasonable=heli;count=contsql"/>
    </plugin>
    <plugin interceptor="cn.evun.sweet.core.mybatis.MybatisInterceptor"></plugin>
</plugins>
</configuration>



虽然后面的mybatis.xml里面有  <setting name="defaultStatementTimeout" value="30" />
但是我们可以用各个 sql的xml 的属性来微调各个sql的timeout 时间