proxool集成

最近在使用c3p0的连接池的时候，发现了一些小bug，就改换了proxool，但是发现和Struts2+spring+JPA(hibernate)整合的时候出现一堆问题，头疼的要命，翻了一上午终于找到解决办法了。

 

第一种就是自己写一个filter

import java.io.File; import java.util.Enumeration; import java.util.Properties; import javax.servlet.ServletContext; import javax.servlet.ServletContextEvent; import javax.servlet.ServletContextListener; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.logicalcobwebs.proxool.ProxoolException; import org.logicalcobwebs.proxool.configuration.JAXPConfigurator; import org.logicalcobwebs.proxool.configuration.PropertyConfigurator; /** * @author wangtao */ public class ProxoolListener implements ServletContextListener { private static final Log LOG = LogFactory.getLog(ProxoolListener.class); private static final String XML_FILE_PROPERTY = "xmlFile"; private static final String PROPERTY_FILE_PROPERTY = "propertyFile"; private static final String AUTO_SHUTDOWN_PROPERTY = "autoShutdown"; @SuppressWarnings("unused") private boolean autoShutdown = true; public void contextDestroyed(ServletContextEvent arg0) { System.out.println("destroy database pool...."); } public void contextInitialized(ServletContextEvent contextEvent) { ServletContext context = contextEvent.getServletContext(); //对应servlet的init方法中ServletConfig.getServletContext() String appDir = contextEvent.getServletContext().getRealPath("/"); Properties properties = new Properties(); Enumeration names = context.getInitParameterNames(); while (names.hasMoreElements()) { String name = (String) names.nextElement(); String value = context.getInitParameter(name); if (name.equals(XML_FILE_PROPERTY)) { try { File file = new File(value); if (file.isAbsolute()) { JAXPConfigurator.configure(value, false); } else { JAXPConfigurator.configure(appDir + File.separator + value, false); } } catch (ProxoolException e) { LOG.error("Problem configuring " + value, e); } } else if (name.equals(PROPERTY_FILE_PROPERTY)) { try { File file = new File(value); if (file.isAbsolute()) { PropertyConfigurator.configure(value); } else { PropertyConfigurator.configure(appDir + File.separator + value); } } catch (ProxoolException e) { LOG.error("Problem configuring " + value, e); } } else if (name.equals(AUTO_SHUTDOWN_PROPERTY)) { autoShutdown = Boolean.valueOf(value).booleanValue(); } else if (name.startsWith("jdbc")) { //此处以前是PropertyConfigurator.PREFIX改为jdbc,因为此源码是0.9.1版本的,与0.9RC3版本有点不一样 properties.setProperty(name, value); } } if (properties.size() > 0) { try { PropertyConfigurator.configure(properties); } catch (ProxoolException e) { LOG.error("Problem configuring using init properties", e); } } } }

 

然后

在web.xml 中 加载监听器

<context-param>
   <param-name>xmlFile</param-name>
   <param-value>路径/proxool.xml</param-value>
</context-param>
<listener>
   <listener-class>路径.ProxoolListener</listener-class>
</listener>

 

第二种适用于hibernate

<bean id="sessionFactory"    class=" ">
     <property name="configLocation" value="classpath:conf/hibernate.cfg.xml">
   </property>
   <property name="hibernateProperties">
    <props>
     <prop key="hibernate.proxool.pool_alias">DbPool</prop>
     <prop key="hibernate.proxool.xml">proxool.xml</prop>
     <prop key="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider
     </prop>
    </props>
   </property>
</bean>

 

这种办法有个缺点，无法调用jdbc。

 

还有第三种也就是jpa的方式

 

打开src 中的meta-inf下的persistence.xml

 

信息如下：

<?xml version="1.0" encoding="UTF-8"?> <persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0"> <persistence-unit name="Unit" transaction-type="RESOURCE_LOCAL"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/> <property name="hibernate.cache.provider_class" value="org.hibernate.cache.NoCacheProvider"/> <property name="hibernate.show_sql" value="true"/> <property name="hibernate.format_sql" value="true"/> <!--create or update --> <property name="hibernate.hbm2ddl.auto" value="update" /> <property name="hibernate.max_fetch_depth" value="3"></property> <!-- hibernate proxool --> <property name="hibernate.connection.provider_class" value="org.hibernate.connection.ProxoolConnectionProvider"/> <property name="hibernate.proxool.pool_alias" value="mysql"/> <property name="hibernate.proxool.xml" value="proxool.xml"/> </properties> </persistence-unit> </persistence>

 

修改applicationContext.xml

<!-- jpa entityManagerFactory--> <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="persistenceXmlLocation" value="classpath:META-INF/persistence.xml"></property> <property name="persistenceUnitName" value="Unit"></property> <!--value 与persistence.xml中的 unitname相同-->

 

web.xml中不需要变化，仍然可以使用filter 这样子就算成功了。但是和上面第二种一样，会有jdbc没办法调用的情况。头疼

 

谁还有更好的办法，一定要告诉我。