ibatis的连接池如此配置就可以了吗？

最新推荐文章于 2014-05-27 10:17:00 发布

bigcanon

最新推荐文章于 2014-05-27 10:17:00 发布

阅读量267

点赞数

文章标签： iBATIS SQL XML

sql-map-config.xml内容如下



<sqlMapConfig>

  <properties resource="config.properties"/>

  <transactionManager type="JDBC">  
    <dataSource type="simple">
      <property value="${driver}" name="JDBC.Driver"/>
      <property value="${url}" name="JDBC.ConnectionURL"/>
      <property value="${username}" name="JDBC.Username"/>
      <property value="${password}" name="JDBC.Password"/>
      <property name="Pool.MaximumActiveConnections" value="10"/>
	  <property name="Pool.MaximumIdleConnections" value="5"/>
      <property name="Pool.MaximumWait" value="10"/>
      <property name="Pool.MaximumCheckoutTime" value="120000"/>
      <property name="Pool.TimeToWait" value="500"/>
      <property name="Pool.PingEnabled" value="false"/>
      <property name="Pool.PingConnectionsOlderThan" value="1"/>
      <property name="Pool.PingConnectionsNotUsedFor" value="1"/>
    </dataSource>    
  </transactionManager>
  <sqlMap resource="com/co/sm/persistence/sqlmapdao/sql/Login.xml"/>
  <sqlMap resource="com/co/sm/persistence/sqlmapdao/sql/AdminShop.xml"/>
  <sqlMap resource="com/co/sm/persistence/sqlmapdao/sql/AdminSystem.xml"/>
  <sqlMap resource="com/co/sm/persistence/sqlmapdao/sql/GuestIndex.xml"/>
  <sqlMap resource="com/co/sm/persistence/sqlmapdao/sql/Mobile.xml"/>
</sqlMapConfig>