yekki.jocl

来自「JSP聊天系统」· JOCL 代码 · 共 39 行

<!--
   The PoolingDriver expects PoolableConnectionFactory to be the root of the JOCL document.
 -->
<object class="org.apache.commons.dbcp.PoolableConnectionFactory" xmlns="http://apache.org/xml/xmlns/jakarta/commons/jocl">
	<!--
	  The first argument to PoolableConnectionFactory is a ConnectionFactory.
	  We'll use a DriverManagerConnectionFactory, passing in the appropriate
	  connect string for the underlying driver.
	-->
	<object class="org.apache.commons.dbcp.DriverManagerConnectionFactory">
	  <string value="jdbc:oracle:thin:web_dev/web_dev@192.168.8.170:1521:dev"/> <!-- CHANGE ME TO THE CONNECT STRING FOR YOUR DRIVER -->
	  <object class="java.util.Properties" null="true"/>
	</object>

	<object class="org.apache.commons.pool.impl.GenericObjectPool">
		<object class="org.apache.commons.pool.PoolableObjectFactory" null="true"/>
		<int value="10"/> <!-- max active -->
		<byte value="1"/> <!-- when exhausted action, 0 = fail, 1 = block, 2 = grow -->
		<long value="2000"/> <!-- max wait -->
		<int value="10"/> <!-- max idle -->
		<boolean value="false"/> <!-- test on borrow -->
		<boolean value="false"/> <!-- test on return -->
		<long value="10000"/> <!-- time between eviction runs -->
		<int value="5"/> <!-- number of connections to test per eviction run -->
		<long value="5000"/> <!-- min evictable idle time -->
		<boolean value="true"/> <!-- test while idle -->
	</object>

	<!-- the next argument is the KeyedObjectPoolFactory -->
	<object class="org.apache.commons.pool.StackKeyedObjectPoolFactory">
	<int value="5"/> <!-- max idle -->
	</object>

	<string value="SELECT COUNT(*) FROM DUAL"/> <;!-- validation query -->
	<boolean value="false"/> <!-- default read only -->
	<boolean value="true"/> <!-- default auto commit -->

</object>