急求：ibatis2.0+SqlServer2005 连接池如何配置

[xiejinz]

急求：ibatis2.0+SqlServer2005 连接池如何配置
；项目现在需要用了，给力的我把分全部塞给你，谢谢！！！
开始没有用到连接池，现在要用的话，要不要加包加类？？？
在网上找了些相关资料，都没有成功，不太懂；
最好要配在 spring 配置文件中的，

[xiejinz]

[Quote=引用 4 楼 fredrickhu 的回复:]
SQL code
private BasicDataSource legacyDbcpConfiguration(Map map) {
BasicDataSource basicDataSource = null;
if (map.containsKey("JDBC.Driver")) {
basicDataSource = new BasicDataSo……
[/Quote]

我是用spring 管理的，还有自己写java代码去获取连接吗，
再一个，我要把连接池的代码，配到spring 里面去管理，不然开事务怎么办，要有“ dataSource ” 啊

[「已注销」]

参考
自己测试

[快溜]

主题：ibatis2.3源码之数据源&连接池浅析
ibatis2.0连接池配置

[xiejinz]

这也是在网上找的，看着挺像可以，但就是配不出来，有没有可以指教一下的咯？？
<beans>
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>

<!-- 这个也不会填 -->
<value>classpath*:config/jdbc.properties</value> </list>
</property>
</bean>

<!-- ========================= RESOURCE DEFINITIONS ========================= -->
<!-- 这里这个类找不到 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<property name="driverClass" value="${jdbc.driverClassName}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="properties">
<props>
<prop key="c3p0.minPoolSize">1</prop>
<prop key="hc3p0.maxPoolSize">10</prop>
<prop key="hc3p0.timeout">60</prop>
<prop key="c3p0.max_statement">50</prop>
<prop key="c3p0.testConnectionOnCheckout">true</prop>
<prop key="hibernate.c3p0.testConnectionOnCheckout">false</prop>
<prop key="user">${jdbc.username}</prop>
<prop key="password">${jdbc.password}</prop>
</props>
</property>
</bean>

<!-- Transaction manager for a single JDBC DataSource -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>

<!-- SqlMap setup for iBATIS Database Layer -->
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="classpath:config/sql-map-config.xml"/>
<property name="dataSource" ref="dataSource"/>
</bean>

<bean id="txProxyTemplate" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"
lazy-init="true">
<property name="transactionManager"><ref bean="transactionManager" /></property>
<!--ָķ˂ϱ˴є-->
<property name="transactionAttributes">
<props>
<prop key="insert*">PROPAGATION_REQUIRED</prop>
<prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="save*">PROPAGATION_REQUIRED</prop>
<prop key="remove*">PROPAGATION_REQUIRED</prop>
<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean>

[xiejinz]

忘了说了，我这里外网有限制，就可以上个论坛，没有百度什么的上了，呵呵

[--小F--]

private BasicDataSource legacyDbcpConfiguration(Map map) {   
  BasicDataSource basicDataSource = null;   
  if (map.containsKey("JDBC.Driver")) {   
    basicDataSource = new BasicDataSource();   
    String driver = (String) map.get("JDBC.Driver");   
    String url = (String) map.get("JDBC.ConnectionURL");   
    String username = (String) map.get("JDBC.Username");   
    String password = (String) map.get("JDBC.Password");   
    String validationQuery = (String) map.get("Pool.ValidationQuery");   
    String maxActive = (String) map.get("Pool.MaximumActiveConnections");   
    String maxIdle = (String) map.get("Pool.MaximumIdleConnections");   
    String maxWait = (String) map.get("Pool.MaximumWait");   
  
    basicDataSource.setUrl(url);   
    basicDataSource.setDriverClassName(driver);   
    basicDataSource.setUsername(username);   
    basicDataSource.setPassword(password);   
  
    if (notEmpty(validationQuery)) {   
      basicDataSource.setValidationQuery(validationQuery);   
    }   
  
    if (notEmpty(maxActive)) {   
      basicDataSource.setMaxActive(Integer.parseInt(maxActive));   
    }   
  
    if (notEmpty(maxIdle)) {   
      basicDataSource.setMaxIdle(Integer.parseInt(maxIdle));   
    }   
  
    if (notEmpty(maxWait)) {   
      basicDataSource.setMaxWait(Integer.parseInt(maxWait));   
    }   
  
  }   
  return basicDataSource;   
}  

  private BasicDataSource legacyDbcpConfiguration(Map map) {
    BasicDataSource basicDataSource = null;
    if (map.containsKey("JDBC.Driver")) {
      basicDataSource = new BasicDataSource();
      String driver = (String) map.get("JDBC.Driver");
      String url = (String) map.get("JDBC.ConnectionURL");
      String username = (String) map.get("JDBC.Username");
      String password = (String) map.get("JDBC.Password");
      String validationQuery = (String) map.get("Pool.ValidationQuery");
      String maxActive = (String) map.get("Pool.MaximumActiveConnections");
      String maxIdle = (String) map.get("Pool.MaximumIdleConnections");
      String maxWait = (String) map.get("Pool.MaximumWait");

      basicDataSource.setUrl(url);
      basicDataSource.setDriverClassName(driver);
      basicDataSource.setUsername(username);
      basicDataSource.setPassword(password);

      if (notEmpty(validationQuery)) {
        basicDataSource.setValidationQuery(validationQuery);
      }

      if (notEmpty(maxActive)) {
        basicDataSource.setMaxActive(Integer.parseInt(maxActive));
      }

      if (notEmpty(maxIdle)) {
        basicDataSource.setMaxIdle(Integer.parseInt(maxIdle));
      }

      if (notEmpty(maxWait)) {
        basicDataSource.setMaxWait(Integer.parseInt(maxWait));
      }

    }
    return basicDataSource;
  } 这段代码的目的是读取ibatis中的sqlMapConfig.xml配置文件的，下面是这个配置文件的具体长像：

Sqlmapconfig配置文件代码  
 <transactionManager type="JDBC">     
     <dataSource type="DBCP">     
         <property name="JDBC.Driver" value="com.mysql.jdbc.Driver" />     
         <property name="JDBC.ConnectionURL" value="jdbc:mysql://xxx" />     
         <property name="JDBC.Username" value="root" />     
         <property name="JDBC.Password" value="xxx" />     
         <property name="Pool.MaximumActiveConnections" value="15"/>   
<property name="Pool.MaximumIdleConnections" value="15"/>   
<property name="Pool.MaximumWait" value="1000"/>   
<property name="Pool.RemoveAbandoned" value="true"/>     
<property name="Pool.RemoveAbandonedTimeout" value="1"/>     
<property name="asdfaf" value="1"/>     
     </dataSource>     
 </transactionManager>    

    <transactionManager type="JDBC">  
        <dataSource type="DBCP">  
            <property name="JDBC.Driver" value="com.mysql.jdbc.Driver" />  
            <property name="JDBC.ConnectionURL" value="jdbc:mysql://xxx" />  
            <property name="JDBC.Username" value="root" />  
            <property name="JDBC.Password" value="xxx" />  
            <property name="Pool.MaximumActiveConnections" value="15"/>
			<property name="Pool.MaximumIdleConnections" value="15"/>
			<property name="Pool.MaximumWait" value="1000"/>
			<property name="Pool.RemoveAbandoned" value="true"/>  
			<property name="Pool.RemoveAbandonedTimeout" value="1"/>  
			<property name="asdfaf" value="1"/>  
        </dataSource>  
    </transactionManager>   可以看到源代码里只有以下几项对dbcp的配置是可以在ibatis中配置的，其余都是用的dbcp的默认值：

      String validationQuery = (String) map.get("Pool.ValidationQuery");
      String maxActive = (String) map.get("Pool.MaximumActiveConnections");
      String maxIdle = (String) map.get("Pool.MaximumIdleConnections");
      String maxWait = (String) map.get("Pool.MaximumWait");

结论：不知道是否是我的遗漏，但是看了源代码确实是只对了这四个配置项进行了处理，其他的没有提到。实际影响到我的后果就是我对

<property name="Pool.RemoveAbandoned" value="true"/>  
<property name="Pool.RemoveAbandonedTimeout" value="1"/>  

这两项的配置由于ibatis的阻碍，dbcp实际上是看不到的，真不知道ibatis的这个版本是怎么回事，感觉没有完全用上DBCP，不知道接下来的版本会不会有所改进。