Java开发网 - tomcat 5.0.28配置连接池错误，请哥哥们帮忙看一下

Java开发网

您没有登录

» Java开发网 » Application Server

打印话题 寄给朋友 订阅主题

作者

tomcat 5.0.28配置连接池错误，请哥哥们帮忙看一下

Illum

发贴: 125
积分: 12

于 2004-11-20 22:46

tomcat 5.0.28
mysql 4.0.20
mysql-connector-java-bin.jar 已经放入tomcat\common\lib下

配置如下

Tomcat\config\server.xml如下：
<Server port="8005" shutdown="SHUTDOWN" debug="0">

<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
debug="0"/>
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
debug="0"/>


<GlobalNamingResources>


<Environment name="simpleValue" type="java.lang.Integer" value="30"/>


<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved">
</Resource>
<ResourceParams name="UserDatabase">
<parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
<parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>

</GlobalNamingResources>



<Context path="/dstest" docBase="dstest" debug="5" reloadable="true">
<Resource name="jdbc/testpool" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/testpool">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>root</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/dstest</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>8</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>4</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>
</Context>



<Service name="Catalina">
..........................................

作者

Re:tomcat 5.0.28配置连接池错误，请哥哥们帮忙看一下 [Re:Illum]

Illum

发贴: 125
积分: 12

于 2004-11-20 22:48

Tomcat\webapp\dstest\WEB-INF\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">
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>

<resource-ref>
<description>
datasource jdbc/testpool
</description>
<res-ref-name>
jdbc/testpool
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>
<welcome-file-list>
  <welcome-file>
index.jsp
</welcome-file>
  <welcome-file>
index.html
</welcome-file>
  <welcome-file>
index.htm
</welcome-file>
</welcome-file-list>
</web-app>

测试jsp如下：
Tomcat\webapps\dstest\test.jsp
<%@ page language="java"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>

<html>
<head>
<title>Test Database </title>
</head>
<body >
  <center>Test Database Source Pools</center>
  <table border="0" >
<%
String jndi_name="java:comp/env/jdbc/testpool";
String select_user_sql="select * from dstest";

Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("No Context");

DataSource ds = (DataSource)ctx.lookup(jndi_name);

Connection conn = ds.getConnection();

try {
PreparedStatement psPreparedStatement=conn.prepareStatement(select_user_sql);
ResultSet resultSet = psPreparedStatement.executeQuery();
while(resultSet.next()){
  out.print("<tr>");
  out.print("<td>"+resultSet.getString(1)+"</td>");
  out.print("<td>"+resultSet.getString(2)+"</td>");
  out.print("<td>"+resultSet.getString(3)+"</td>");
  out.print("</tr>");
}
}
catch(SQLException e){
e.printStackTrace();
}
finally {
conn.close();
}
%>
</table>
</body>
</html>

数据库dstest中有有表test,结构如下
Id int
Name varchar
Address varchar

Illum edited on 2004-11-21 00:10

作者

Re:tomcat 5.0.28配置连接池错误，请哥哥们帮忙看一下 [Re:Illum]

Illum

发贴: 125
积分: 12

于 2004-11-20 23:17

异常如下
令人百思不得其解

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Cannot create JDBC driver of class '' for connect URL 'null'
  org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
  org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
  org.apache.jsp.test_jsp._jspService(test_jsp.java:99)
  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
  org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
  org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
  org.apache.jsp.test_jsp._jspService(test_jsp.java:69)
  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

Illum edited on 2004-11-20 23:34

作者	Re:tomcat 5.0.28配置连接池错误，请哥哥们帮忙看一下 [Re:Illum]
Illum 发贴: 125 积分: 12	于 2004-11-20 23:18 应该不是jdbc的问题，因为有另外一个应用可以正常使用这个jdbc驱动 Illum edited on 2004-11-20 23:30

已读帖子

新的帖子

被删除的帖子