ibatis ping db

最新推荐文章于 2020-09-16 16:56:01 发布

jis117

最新推荐文章于 2020-09-16 16:56:01 发布

阅读量84

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/jis117/article/details/84520437

版权

java 专栏收录该内容

144 篇文章 0 订阅

订阅专栏


<transactionManager type="JDBC">
<dataSource type="SIMPLE">
	<property name="JDBC.Driver" value="${driver}" />
	<property name="JDBC.ConnectionURL" value="${url}" />
	<property name="JDBC.Username" value="${username}" />
	<property name="JDBC.Password" value="${password}" />
	<property name="Pool.PingQuery" value="select 1 from redirect_url" />
	<property name="Pool.PingEnabled" value="true" />
	<property name="Pool.PingConnectionsOlderThan" value="0" />
	<property name="Pool.PingConnectionsNotUsedFor" value="3600000" /><!-- 对于空闲的连接一个小时检查一次 -->
</dataSource>
</transactionManager>



<context:property-placeholder location="classpath:jdbc.properties" ignore-unresolvable="true" />

<bean id="dataSource" class="com.huawei.rbt.common.RBTDataSource" destroy-method="close">
	<property name="driverClassName"	value="${pooled.driverClass}" />
	<property name="url"	value="${pooled.jdbcUrl}" />
	<property name="username"	value="${pooled.username}" />
	<property name="password"	value="${pooled.password}" />
	<property name="maxActive"	value="${pooled.maxActive}" />
	<property name="maxIdle"	value="${pooled.maxIdle}" />
	<property name="minIdle"	value="${pooled.minIdle}" />
	<property name="initialSize"	value="${pooled.initialSize}" />
	<property name="maxWait"	value="${pooled.maxWait}" />
	<property name="poolPreparedStatements"	value="${pooled.poolPreparedStatements}" />
	<property name="timeBetweenEvictionRunsMillis"	value="${pooled.timeBetweenEvictionRunsMillis}" />
</bean>