ibatis中SqlMapConfig的oracle数据库配置

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMapConfig 

    PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" 

    "http://www.ibatis.com/dtd/sql-map-config-2.dtd">

<sqlMapConfig>

    <settings cacheModelsEnabled="true" enhancementEnabled="true"

        lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="32"

        maxSessions="10" maxTransactions="5" useStatementNamespaces="false" />

 

    <transactionManager type="JDBC">

        <dataSource type="SIMPLE">

            <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver" />

           <property name="JDBC.ConnectionURL"    value="jdbc:oracle:thin:@218.239.88.85:1521:cms2009" />

           <property name="JDBC.Username" value="cms2009user" />

           <property name="JDBC.Password" value="cms#jurl09#dk" />

            <property name="Pool.MaximumActiveConnections" value="10" />

            <property name="Pool.MaximumIdleConnections" value="5" />

            <property name="Pool.MaximumCheckoutTime" value="120000" />

            <property name="Pool.TimeToWait" value="500" />

            <property name="Pool.PingQuery" value="select 1 from sample" />

            <property name="Pool.PingEnabled" value="false" />

            <property name="Pool.PingConnectionsOlderThan" value="1" />

            <property name="Pool.PingConnectionsNotUsedFor" value="1" />

        </dataSource>

    </transactionManager>

    <sqlMap resource="com/tj/maps/User.xml" />

</sqlMapConfig>