引用 Struts2+spring2.5+jpa(hibernate)+proxool

引用

jackwang1 的 Struts2+spring2.5+jpa(hibernate)+proxool

Struts2+spring2.5+jpa(hibernate)这种组合大家在网上看的很多了，不过他们大多数的数据源用的是dbcp，或是cp30，也找了一些用proxool做数据源的，不过配置完似乎总有问题

例如 如果把数据源配置在applicationContext.xml里，则应用在启动的时候会报“Attempt to refer to a unregistered pool by its alias” 这是因为struts2与spring进行整合时,web.xml中的spring加载必须使listener来加载,如果使用ContextLoderServlet,则会出空指向异常,报的是Struts2的objectFactory中的某处,因为绝大多数WEB容器的加载顺序是:Listener,Filter,Servlet,所以将会现struts2在spring前加载,它就找不到spring的管理容器,产生异常,解决办法使用ContextLoderListener来加载spring,好,这样一来又有问题了（proxool在web.xml中的配置采用servlet加载，比Listener启动的晚）,spring出异常了,它又会找不到我们在applicationContext.xml所提供的数据源的别名,即:proxool.DbPool,无法管理数据库连接池了。于是只好放弃这种做法，某位大人说自己写Listener，这个也是个不错的解决方法，其实我是不建议修改人家源码的，因为这样不通用！经过多次测试终于找到了如下的一种配置方案：

1 准备：Struts2+spring2.5+jpa(hibernate)+proxool的必要jar包你得有吧，对了，我连接的是oracle数据库

2 开发工具：myeclipse6.5

3 新建工程，作必要的准备工作，copy jar包，我只把主要的配置文件列出来：

  1）web.xml

   <?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
 http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  <!-- Include this if you are using Hibernate 
  <filter>
  <filter-name>Spring OpenEntityManagerInViewFilter</filter-name>
  <filter-class>
  org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter
  </filter-class>
  </filter>  
  <filter-mapping>
  <filter-name>Spring OpenEntityManagerInViewFilter</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>/*</url-pattern>
 </filter-mapping>
  <listener>
  <listener-class>
   org.springframework.web.context.ContextLoaderListener
  </listener-class>
 </listener> 
 <welcome-file-list>
  <welcome-file>index.jsp</welcome-file>
 </welcome-file-list>
</web-app>

2)在web.xml同级目录建立applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:jee="http://www.springframework.org/schema/jee"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xmlns:context="http://www.springframework.org/schema/context"
 xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-2.5.xsd http://www.springframework.org/schema/jeehttp://www.springframework.org/schema/jee/spring-jee-2.5.xsd http://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-2.5.xsd"
 default-lazy-init="true">
 <bean
  class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />
 <!-- 连接池 -->
 <bean id="entityManagerFactory"
  class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
  <property name="persistenceXmlLocation" value="classpath:META-INF/persistence.xml"></property>
  <property name="persistenceUnitName" value="punit"></property> <!--value 与persistence.xml中的 unitname相同-->
 </bean>

 <bean id="transactionManager"
  class="org.springframework.orm.jpa.JpaTransactionManager">
  <property name="entityManagerFactory"
   ref="entityManagerFactory" />
 </bean>

 <tx:annotation-driven transaction-manager="transactionManager"/>
 <context:component-scan base-package="spring" />
</beans>

3）在src文件夹建立META-INF，在该文件夹建persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/persistencehttp://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
 version="1.0">
 <persistence-unit name="punit" transaction-type="RESOURCE_LOCAL">
 <provider>org.hibernate.ejb.HibernatePersistence</provider>
  <properties>    
   <property name="hibernate.ejb.cfgfile" value="hibernate.cfg.xml"/>
  </properties>
 </persistence-unit>
</persistence>
4）在src文件夹建立hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

   <session-factory>
        <!-- Database connection settings -->
        <property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
        <property name="hibernate.proxool.pool_alias">test</property>
        <property name="hibernate.proxool.xml">proxool.xml</property>
        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">false</property>
        <!-- Drop and re-create the database schema on startup - create-drop-->
        <property name="hbm2ddl.auto">update</property> 
        <mapping class="entity.Person"/>
    </session-factory>  
</hibernate-configuration>

5）在src文件建立proxool.xml

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
 <proxool>
  <alias>test</alias>
  <!--proxool只能管理由自己产生的连接-->
  <driver-url>
   jdbc:oracle:thin:@127.0.0.1:1521:orcl
  </driver-url>
  <driver-class>
   oracle.jdbc.OracleDriver
  </driver-class>
  <driver-properties>
   <property name="user" value="book" />
   <property name="password" value="book" />
  </driver-properties>
  <!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁-->
  <house-keeping-sleep-time>90000</house-keeping-sleep-time>
  <!-- 指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受-->
  <maximum-new-connections>20</maximum-new-connections>
  <!-- 最少保持的空闲连接数-->
  <prototype-count>5</prototype-count>
  <!-- 允许最大连接数,超过了这个连接，再有请求时，就排在队列中等候，最大的等待请求数由maximum-new-connections决定-->
  <maximum-connection-count>100</maximum-connection-count>
  <!-- 最小连接数-->
  <minimum-connection-count>10</minimum-connection-count>
 </proxool>
</something-else-entirely>

 

至此 所有的配置文件建立完成，测试程序

package spring;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;

import entity.Person;

@Transactional
@Component
public class LoginServiceImpl implements LoginService {
 @PersistenceContext
 private EntityManager em;

 // public void setEntityManager(EntityManager em) {
 // this.em = em;
 // }
 @SuppressWarnings("unchecked")
 public boolean checkuser(String name, String password) {
  Query query = em
    .createQuery("select o from Person o where o.name=?1 and o.password=?2");
  query.setParameter(1, name);
  query.setParameter(2, password);
  List<Person> ls = query.getResultList();
  if (ls.size() > 0)
   return true;
  else
   return false;
 }

}

有兴趣的话 自己测试下吧