环境说明:
TOMCAT5.0.28+SQL SERVER2000 SP4
目录结构:
$tomcat_home$\conf\server.xml,在</GlobalNamingResources>前一行添加:
<ResourceLink name="JDBC/SERVER2000" type="javax.sql.DataSource" global="JDBC/SERVER2000"/>
$tomcat_home$\conf\Catalina\localhost\myAppName.xml,设置数据源:
<?xml version='1.0' encoding='utf-8'?> <Context path="/contexPath" reloadable="true" docBase="D:/.../.../pathName" > <Resource name="JDBC/Server2000" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="JDBC/Server2000"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>driverClassName</name> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=consumer</value> </parameter> <parameter> <name>username</name> <value>sa</value> </parameter> <parameter> <name>password</name> <value>sdfsdf</value> </parameter> <parameter> <name>maxActive</name> <value>20</value> </parameter> <parameter> <name>maxIdle</name> <value>10</value> </parameter> <parameter> <name>maxWait</name> <value>-1</value> </parameter> </ResourceParams> </Context>
$youWebDIR$\WEB-INF\web.xml:在</web-app>前插入应用数据源的参考
<resource-ref> <description>SQL Server Datasource</description> <res-ref-name>JDBC/SERVER2000</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </web-app>