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

[quote]


<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>

[/quote]


[quote]

<?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 时间
[/quote]