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

[size=14]

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>


[/size]