server.xml中配置为
<Context docBase="zljc" path="/zljc" reloadable="true" source="org.eclipse.jst.j2ee.server:zljc"> <Resource auth="Container" name="ZLJC" type="javax.sql.DataSource"/> <ResourceParams name="ZLJC"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>url</name> <value>jdbc:oracle:thin:@127.0.0.1:1521:ora</value> </parameter> <parameter> <name>password</name> <value>zljc</value> </parameter> <parameter> <name>maxActive</name> <value>60</value> </parameter> <parameter> <name>maxWait</name> <value>-1</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>username</name> <value>zljc</value> </parameter> </ResourceParams> </Context>
但是在连接数据库时候出现异常 Name is not bound in this Context
需要在web.xml中加入
<resource-ref> <description>Oracle Datasource example</description> <res-ref-name>ZLJC</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>