spring中使用proxool作数据源连接池的配置。

spring中使用proxool作数据源连接池的配置。


applicationContext.xml

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

----------------------------------------------------------------------------------------------------------


<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver">
</property>
<property name="url"
value="jdbc:oracle:thin:@localhost:1521:oracle9">
</property>
<property name="username" value="moto"></property>
<property name="password" value="moto"></property>
</bean>


<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.Oracle9Dialect
</prop>
<prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
                <prop key="hibernate.proxool.xml">proxool.xml</prop>
                <prop key="hibernate.proxool.pool_alias">moto</prop>
                                    <prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hinbernate.jdbc.fetch_size">100</prop>
<prop key="hinbernate.jdbc.batch_size">50</prop>
</props>
</property>
<property name="mappingResources">
<list>

<value>com/moto/vo/user/Employees.hbm.xml</value>
<value>com/moto/vo/user/UserPossie.hbm.xml</value>
<value>com/moto/vo/user/Company.hbm.xml</value>
<value>com/moto/vo/user/UserRate.hbm.xml</value>
<value>com/moto/vo/user/UserState.hbm.xml</value>
<value>com/moto/vo/user/UserTeam.hbm.xml</value>
<value>com/moto/vo/user/Department.hbm.xml</value>
<value>com/moto/vo/user/EmployeeClass.hbm.xml</value>


</list>
</property>
</bean>

---------------------------------------------------------------------

web.xml


<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.4"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee   http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>

<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/applicationContext.xml</param-value>

</context-param>


<servlet>
<servlet-name>action</servlet-name>
<servlet-class>
org.apache.struts.action.ActionServlet
</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>config/user</param-name>
<param-value>/WEB-INF/user/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>config/company</param-name>
<param-value>/WEB-INF/company/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>config/author</param-name>
<param-value>
/WEB-INF/author/struts-config.xml
</param-value>
</init-param>

<init-param>
<param-name>config/country</param-name>
<param-value>
/WEB-INF/country/struts-config.xml
</param-value>
</init-param>

<init-param>
<param-name>config/customer</param-name>
<param-value>
/WEB-INF/customer/struts-config.xml
</param-value>
</init-param>
<init-param>
<param-name>config/project</param-name>
<param-value>
/WEB-INF/project/struts-config.xml
</param-value>
</init-param>
<init-param>
<param-name>config/contract</param-name>
<param-value>
/WEB-INF/contract/struts-config.xml
</param-value>
</init-param>

<init-param>
<param-name>debug</param-name>
<param-value>3</param-value>
</init-param>
<init-param>
<param-name>detail</param-name>
<param-value>3</param-value>
</init-param>
<load-on-startup>0</load-on-startup>
</servlet>

<servlet>
<description>
This is the description of my J2EE component
</description>
<display-name>
This is the display name of my J2EE component
</display-name>
<servlet-name>SetCharacterEncoding</servlet-name>
<servlet-class>
com.moto.util.filter.SetCharacterEncoding
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>SetCharacterEncoding</servlet-name>
<url-pattern>/servlet/SetCharacterEncoding</url-pattern>
</servlet-mapping>

<error-page>
        <error-code>500</error-code>
        <location>/error.jsp</location>
    </error-page>
<error-page>
        <error-code>404</error-code>
        <location>/error.jsp</location>
    </error-page>

<filter>
<filter-name>SetCharacterEncoding</filter-name>
<filter-class>
com.moto.util.filter.SetCharacterEncoding
</filter-class>
</filter>
<filter-mapping>
<filter-name>SetCharacterEncoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

<filter>
        <filter-name>OpenSessionInView</filter-name>
        <filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>
        <init-param>
            <param-name>singleSession</param-name>
            <param-value>true</param-value>
        </init-param>
   </filter>
  
   <filter-mapping>
      <filter-name>OpenSessionInView</filter-name>
      <url-pattern>*.do</url-pattern>
   </filter-mapping>



<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>


<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.configuration.ServletConfigurator
</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF/proxool.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>

<servlet>
<servlet-name>Admin</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.admin.servlet.AdminServlet
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Admin</servlet-name>
<url-pattern>/admin</url-pattern>
</servlet-mapping>


<welcome-file-list>
<welcome-file>home.jsp</welcome-file>
</welcome-file-list>
</web-app>



-------------------------------------------------------------
proxool.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>


   <!-- My database localhost infoMessage  -->
   <!--
  <proxool>
    <alias>test</alias>
<driver-url>jdbc:oracle:thin:@localhost:1521:oracle9</driver-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <driver-properties>
      <property name="user" value="test"/>
      <property name="password" value="test"/>
    </driver-properties>
    <house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>
    <minimum-connection-count>0</minimum-connection-count>
    <maximum-connection-count>200</maximum-connection-count>
    <maximum-active-time>300000</maximum-active-time>
    <maximum-connection-lifetime>3600000</maximum-connection-lifetime>
    <verbose>true</verbose>
    <trace>true</trace>
  </proxool> -->
 


   <proxool>
    <alias>moto</alias>
<driver-url>jdbc:oracle:thin:@localhost:1521:oracle9</driver-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <driver-properties>
      <property name="user" value="moto"/>
      <property name="password" value="moto"/>
    </driver-properties>
    <house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>
    <minimum-connection-count>10</minimum-connection-count>
    <maximum-connection-count>5000000</maximum-connection-count>
    <maximum-active-time>3000000</maximum-active-time>
    <maximum-connection-lifetime>3600000</maximum-connection-lifetime>
    <verbose>true</verbose>
    <trace>true</trace>
  </proxool>
 
</something-else-entirely>