ibatis2

<transactionmanager type="JDBC">
    <datasource type="SIMPLE">
        <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
        <property name="JDBC.ConnectionURL" value="jdbc:mysql:///localhost"/>
        <property name="JDBC.Username" value="user"/>
        <property name="JDBC.Password" value="password"/>

        <!-- optional elements include -->
        <property name="Pool.MaximumActiveConnections" value="10"/>
        <property name="Pool.MaximumIdleConnections" value="5"/>
        <property name="Pool.MaximumCheckoutTime" value="120000"/>
        <property name="Pool.TimeToWait" value="10000"/>
        <property name="Pool.PingQuery" value="select * from dbname.tablename"/>
        <property name="Pool.PingEnabled" value="false"/>
        <property name="Pool.PingConnectionsOlderThan" value="0"/>
        <property name="Pool.PingConnectionsNotUsedFor" value="0"/>
    </datasource>
</transactionmanager>