tomcat5.0数据源配置

环境说明:

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>

 

 

评论

1 楼 thousandzhang 2009-12-10  

亦可以直接将配置信息配置在struts-config.xml文件中，简单易行

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd">
<struts-config>
  <data-sources>
    <data-source type="org.apache.commons.dbcp.BasicDataSource" key="default">
      <set-property value="Example Data Source Configuration" property="description" />
      <set-property value="com.microsoft.jdbc.sqlserver.SQLServerDriver" property="driverClassName" />
      <set-property value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=consumer" property="url" />
      <set-property value="sa" property="username" />
      <set-property value="sdfsdf" property="password" />
      <set-property value="true" property="autoCommit" />
      <set-property value="500" property="maxCount" />
      <set-property value="100" property="minCount" />
    </data-source>
  </data-sources>
  <global-forwards>
    <forward contextRelative="true" name="notlogin" path="/enter.do" />
    <forward name="failure" contextRelative="true" path="/app/error/Failure.jsp" />
    <forward name="success" contextRelative="true" path="/app/error/Success.jsp" />
    <forward name="notAccess" contextRelative="true" path="/app/error/NotAccess.jsp" />
    <forward name="done" contextRelative="true" path="/app/error/Success_1.jsp" />
  </global-forwards>

  <message-resources key="security" null="false" parameter="resources.resources_security" />
</struts-config>