使用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>
页:
[1]