1.在tomcat的conf文件下的web.xml增加
<resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/ob2</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
2.在tomcat的conf文件夹下的增加如下代码
<Resource name="jdbc/ob2" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="test" password="test" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:test" />
<ResourceParams name="jdbc/ob2"> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>removeAbandonedTimeout</name> <value>60</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter> </ResourceParams>
3.在spring的配置文件中增加如下代码
<bean id="jndi" class="java.lang.String"> <constructor-arg value="java:comp/env/jdbc/ob2" /> </bean> <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName" ref="jndi" /> </bean>
或者
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName" value="java:comp/env/jdbc/ob2" /> </bean>