Tomcat 下 conf/context.xml
<?xml version='1.0' encoding='utf-8'?> <Context> <!-- Default set of monitored resources --> <WatchedResource>WEB-INF/web.xml</WatchedResource> <Resource name="jdbc/tianfan" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@192.168.1.240:1521:ORCL" username="tianfan" password="tianfantest" initialSize="20" maxActive="100" maxIdle="30" minIdle="10" logAbandoned="1" removeAbandoned="1" removeAbandonedTimeout="1" maxWait="1000" /> </Context>
Spring xml文件里 通过jndi访问数据
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" destroy-method="close"> <property name="jndiName"><value>java:comp/env/jdbc/tianfan</value></property> </bean>
工程 Web.xml增加
<resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/tianfan</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>