使用jndi（tomcat）

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>