tomcat连接池配置问题

wangdongzjk 2004-05-07 07:15:07

server.xml中的关于连接池的配置如下：
<Context path="/hull" docBase="D:\JavaServer\Tomcat 4.1\dbconnector" debug="0" reloadable="true">

<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" perfix="localhost_hull_log." suffix=".txt"
timestamp="true"/>

<Resource name="jdbc/SqlServerDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/SqlServerDB">
<parameter>
<name>maxActive</name>

<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>

<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>

<value>10000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>

<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>

<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>

<value>false</value>
</parameter>
<parameter>
<name>factory</name>

<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>524722</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://WANGDONG\\WANGDONG:1433;DatabaseName=HULL</value>
</parameter>
</ResourceParams>
</Context>
但是，怎么tomcat启动不了了？
我用的是tomcat4.1.27
配置了apache2.0.49

...全文

75 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

minghuitian 2004-05-07

打赏
举报

llin998 2004-05-07

打赏
举报

我建议你先在IE下试试是否能够打开这个文件，是不是你的server.xml写错了！我犯过这个错误的！我有好用的tomcat+jsp例子，你可以参考试试！

1)server.xml文件


<Context path="/pool" docBase="pool" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_pool_log." suffix=".txt"
timestamp="true"/>

<Resource auth="Container" name="jdbc/OraConPool" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/OraConPool">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>3</value>
</parameter>
<parameter>
<name>password</name>
<value>tiger</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:myschema@10.70.36.253:1521:oradb</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>scott</value>
</parameter>
</ResourceParams>
</Context>


2)web.xml


<resource-ref>
<description>OraConnPool</description>
<res-ref-name>jdbc/OraConPool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

llin.jsp
<%@ page contentType="text/html;charset=ISO8859-1" language="java" import="java.sql.*,javax.naming.*,javax.sql.*" %>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
</HEAD>
<BODY>
<%
Connection conn = null;
Statement stm = null;
ResultSet rs = null;
try {
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/OraConPool");
//用来替换上面的两行，没有测试不知道好用否
// DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/OracleDB");
conn = ds.getConnection();
if (conn==null){
out.println("Connection is null");
}else{
stm = conn.createStatement();

rs=stm.executeQuery("select count(*) from tab");
rs.next();
out.println(rs.getInt(1));
}
}catch(Exception e){
out.println(e.getMessage());
}
finally {
try{
stm.close();
conn.close();
}catch(Exception e){
}
}
%>
</BODY>
</HTML>
这是我的测试程序，运行没有问题

wangdongzjk 2004-05-07