各种连接池的总结

SPRING MVC下

1.tomcat+oracle
1)tomcat的server.xml

<Context path="/a" docBase="b" debug="9" privileged="true" verbosity="4">

<Resource name="c" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="c">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.1.111:1521:e</value>
</parameter>
<parameter>
<name>username</name>
<value>username</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>
</Context>
a:http项目名，对应项目中web.xml的display-name
b:项目部署路径
c:自己取,跟JNDI相对应
e:DBName

2)将oracle中的classes12.jar ,**111.jar 拷入tomcat中common\lib下
3)项目web.xml
添加如下
<resource-ref>

<description>DB Connection</description>

<res-ref-name>a</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>
a:自己取，跟JNDI相对应
4)***.perproties
写入相对应ORACLE的相关信息 如下
datasource.driverClassName=oracle.jdbc.driver.OracleDriver
datasource.url=jdbc:oracle:thin:@192.168.1.111:1521:DBName
datasource.username=system
datasource.password=system
c3p0.idleConnectionTestPeriod=3600
c3p0.minPoolSize=2
c3p0.maxPoolSize=5
c3p0.maxStatements=100000
c3p0.numHelperThreads=10
c3p0.maxIdleTime=600
upload.path=/home/stmweb/upload
#jndi name for the data source
DB_JNDI=java:comp/env/ +a
DB_TYPE=ORACLE
SERVERPATH=E:\\avetti\\workspace-a\\zdshwebNEW\\Target\\WebRoot
a:JNDI相对应 tomcat中的a
5)applicationContext.xml
1.引入.perproties

<bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>classpath:init.properties</value>
</property>
</bean>
2.配置datasource

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" dependency-check="none">
<property name="driverClass">
<value>${datasource.driverClassName}</value>
</property>
<property name="jdbcUrl">
<value>${datasource.url}</value>
</property>
<property name="user">
<value>${datasource.username}</value>
</property>
<property name="password">
<value>${datasource.password}</value>
</property>

<property name="minPoolSize">
<value>${c3p0.minPoolSize}</value>
</property>
<property name="maxPoolSize">
<value>${c3p0.maxPoolSize}</value>
</property>

</bean>
5.接入框架
1)iBATIS
配置

<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="WEB-INF/sql-map-config.xml" />
<property name="dataSource" ref="dataSource" />
</bean>
2)HIEBERNATE
配置


6.事务的配置

<!-- transactionManager -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>

<bean id="txProxyTemplate" abstract="true" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="transactionAttributes">
<props>
<prop key="insert*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="delete*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="update*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="create*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="import*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="generate*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean>