iption>MySQL Test App</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
利用JBuilder2005开发Web应用程序(3)
时间:2010-04-27
7.F9运行应用,myWeb目录中将会生成Tomcat子目录,其中包含了conf子目录,
在Tomcat_HOME\conf\Catalina\localhost目录中生成了DBTest.xml文件
8.将myWeb\Tomcat\conf目录中的文件server8080.xml加入工程文件,修改server8080.xml的内容
server8080.xml:
<?xml version="1.0" encoding="UTF-8"?>
<Server debug="0" port="8081" shutdown="SHUTDOWN">
<Service name="Catalina">
<Connector acceptCount="10" connectionTimeout="60000" debug="0" maxThreads="75" minSpareThreads="5" port="8080"/>
<Engine debug="0" defaultHost="localhost" name="Catalina">
<Host appBase="C:\myWeb\Tomcat\webapps" autoDeploy="false" debug="0" deployXML="false" name="localhost" unpackWARs="false">
<Context path="/DBTest" docBase="C:\myWeb\DBTest" debug="5" reloadable="true" crossContext="true" workDir="C:\myWeb\Tomcat\work\DBTest">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!--
Maximum number of dB connections in pool.Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections.Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<!--
Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<!--
Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds.An Exception is thrown if
this timeout is exceeded.Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>topcomputer</value>
</parameter>
<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</nam
|