如何修改Tomcat的Server.xml
calen 2006-08-21 06:19:31 需要连接SQL Server 2000,windows 2000的服务器,不过现在在我的机器上是xp的操作系统。
数据库名是dtbg,用户sa,密码123,服务器名dtbgser
请问该如何修改server.xml
我现有的配置中,总是提示
login.jsp org.apache.commons.dbcp.SQLNestedException: Cannot create Poolab
leConnectionFactory ([Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定
默认驱动程序)
配置XML如下
<Context path="/dtbg" docBase="C:\Tomcat\webapps\dtbg" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_dtbg_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/dtbg" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/dtbg">
<parameter>
<name>maxActive</name>
<!-- Maximum number of DB connections in pool.Set to 0 for no limit. -->
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<!-- Maximum number of idle DB connections to retain in pool.Set to 0 for no limit. -->
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<!-- Maximum time to wait for a DB connection to become available in ms.An exception is thrown if this timeout is exceeded.Set to -1 to wait indefinitely. -->
<value>10000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<!-- Abandoned DB connections are removed and recycled -->
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<!-- Use the removeAbandonedTimeout parameter to set the number of seconds a DB connection has been idle before it is considered abandoned. -->
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<!-- Log a stack trace of the code which abandoned -->
<value>false</value>
</parameter>
<parameter>
<name>factory</name>
<!--DBCP Basic Datasource Factory -->
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<!-- Database User Name -->
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<!-- User Password -->
<value>123</value>
</parameter>
<parameter>
<name>driverClassName</name>
<!-- Database Driver Class Name -->
<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:odbc:dtbg</value>
</parameter>
<!--
<parameter>
<name>url</name>
-->
<!-- Database Address -->
<!--
<value>jdbc:jtds:sqlserver://127.0.0.1:1433/dtbg</value>
</parameter>
-->
</ResourceParams>
</Context>