APPARENT DEADLOCK!!![proxool+Spring集成]

我终于也遇到c3p0的bug了!!!!!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@67b2ccc4 – APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
没办法,换proxool试试吧,附上proxool配置方案:
1).proxool.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
  <proxool>
    <alias>dbpool</alias>
    <driver-url>jdbc:mysql://192.168.2.10:3306/kingshine?useUnicode=true&amp;characterEncoding=UTF-8</driver-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <driver-properties>
      <property name="user" value="root"/>
      <property name="password" value="kingshine"/>
    </driver-properties>
    <!-- proxool自动侦查各个连接状态的时间间隔（毫秒），侦查到空闲的连接就马上 回收，超时的销毁 -->
    <house-keeping-sleep-time>900000</house-keeping-sleep-time>
    <!-- 最大连接数 -->
    <maximum-connection-count>10</maximum-connection-count>
    <!-- 最小连接数 -->
    <minimum-connection-count>3</minimum-connection-count>
    <!--连接池中可用的连接数量.如果当前的连接池中的连接少于这个数值.新的连接将被建立 -->
    <prototype-count>3</prototype-count>
    <!-- 可一次建立的最大连接数。那就是新增的连接请求,但还没有可供使用的连接，默认为10 -->
    <simultaneous-build-throttle>4</simultaneous-build-throttle>
    <!-- 日志统计跟踪类型。参数“ERROR”或 “INFO” -->
    <statistics-log-level>INFO</statistics-log-level>
    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
  </proxool>
</something-else-entirely>

2).applicationContext.xml文件(Spring配置文件)

<bean
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>classpath:jdbc.properties</value>
            </list>
        </property>
    </bean>

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName">
            <value>org.logicalcobwebs.proxool.ProxoolDriver</value>
        </property>
        <property name="url">
            <value>proxool.dbpool</value>
        </property>
    </bean>

    <!-- 配置Hibernate -->
    <bean id="sessionFactory" lazy-init ="true" 
        class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">${hibernate.dialect}</prop>
                <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
                <prop key="hibernate.generate_statistics">true</prop>
                <prop key="hibernate.connection.release_mode">auto</prop>
                <prop key="hibernate.autoReconnect">true</prop>
                <prop key="hibernate.jdbc.fetch_size">50</prop>
            </props>
        </property>
<!--        <property name="mappingResources"> -->
<!--            <list> -->
<!--                <value>classpath*:com/kingshine/*/bean/*.hbm.xml</value> -->
<!--            </list> -->
<!--        </property> -->
        <!-- hibernate注解扫描 -->
        <property name="packagesToScan" value="com.kingshine.*.bean" /> 
    </bean>

3).自定义Listener(为了在Spring配置文件加载之前加载proxool配置文件)

package com.kingshine.common.listener;

import java.io.File;
import java.util.Properties;

import javax.servlet.ServletContextEvent;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.logicalcobwebs.proxool.ProxoolException;
import org.logicalcobwebs.proxool.ProxoolFacade;
import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;
import org.logicalcobwebs.proxool.configuration.PropertyConfigurator;
/**
 * proxool初始化
 * @author 
 * @date 
 */
public class ProxoolListenerConfigurator implements
        javax.servlet.ServletContextListener {

    private static final Log LOG = LogFactory
            .getLog(ProxoolListenerConfigurator.class);

    private static final String XML_FILE_PROPERTY = "proxoolConfigLocation";

    private boolean autoShutdown = true;

    public void contextInitialized(ServletContextEvent servletConfig) {

        String appDir = servletConfig.getServletContext().getRealPath("/");

        Properties properties = new Properties();
        String value = servletConfig.getServletContext().getInitParameter(
                XML_FILE_PROPERTY);
        LOG.info("proxoolConfigLocation:"+value);

        try {
            File file = new File(value);
            if (file.isAbsolute()) {
                JAXPConfigurator.configure(value, false);
            } else {
                LOG.debug(appDir + File.separator + value);
                JAXPConfigurator.configure(appDir + File.separator + value,
                        false);
            }
        } catch (ProxoolException e) {
            LOG.error("Problem configuring " + value, e);
        }
        if (properties.size() > 0) {
            try {
                PropertyConfigurator.configure(properties);
            } catch (ProxoolException e) {
                LOG.error("Problem configuring using init properties", e);
            }
        }
    }

    public void contextDestroyed(ServletContextEvent s) {
        if (autoShutdown) {
            ProxoolFacade.shutdown(0);
        }
    }
}

4).web.xml

<context-param>
        <param-name>proxoolConfigLocation</param-name>
        <param-value>WEB-INF/classes/proxool.xml</param-value>
    </context-param>  
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext*.xml</param-value>
  </context-param>
  <context-param>
    <param-name>webAppRootKey</param-name>
    <param-value>system.root.kingshine</param-value>
  </context-param>
  <context-param>
    <param-name>log4jConfigLocation</param-name>
    <param-value>classpath:log4j.properties</param-value>
  </context-param>

  <listener>
        <listener-class>com.kingshine.common.listener.ProxoolListenerConfigurator</listener-class>
  </listener>
  <listener>
    <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
  </listener>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <listener>
    <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
  </listener>
  <listener>
    <listener-class>com.kingshine.common.listener.SystemSessionListener</listener-class>
  </listener>
  <filter>
    <filter-name>openSessionInView</filter-name>
    <filter-class>org.springframework.orm.hibernate4.support.OpenSessionInViewFilter</filter-class>
    <init-param>
      <param-name>sessionFactoryBeanName</param-name>
      <param-value>sessionFactory</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>openSessionInView</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  <filter>
    <filter-name>struts2</filter-name>
    <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>*.action</url-pattern>
  </filter-mapping>

  <!-- 配置proxool资源监控程序 -->
  <servlet>
      <servlet-name>adminP</servlet-name>
       <servlet-class>
           org.logicalcobwebs.proxool.admin.servlet.AdminServlet
       </servlet-class>
  </servlet>
  <servlet-mapping>
     <servlet-name>adminP</servlet-name>
     <url-pattern>/adminp</url-pattern>
  </servlet-mapping>

OK,完事可以看一下proxool的控制台:
http://localhost:8080/项目名称/adminp