|
如何利用JBuilder2005开发Web应用程序 (2) |
|
2006-01-12 |
6. 修改web.XML的内容
web.xml:
<?xml version="1.0" encoding="UTF-8"?>
<web-app
xmlns="http://java.sun.com/xml/ns/J2EE"
xmlns:xsi=
"http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=
"http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4">
<description>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> |
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</name>
<value>com.microsoft.
jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<!--
The JDBC connection url
for connecting to your MySQL dB.
The autoReconnect=true argument
to the url makes sure that the
mm.mysql JDBC Driver will
automatically reconnect if mysqld closed the
connection. mysqld by default
closes idle connections after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver:
//nt04:1433;DatabaseName=test</value>
</parameter>
</ResourceParams>
</Context>
</Host>
</Engine>
</Service>
</Server> |
|