去掉server8080.xml中的注释,加入数据源的配置,出现如下错误:...

[gameover1999]

我去掉了server8080.xml中的注释:
<!--This comment marks this file as generated, so it may be deleted and regenerated at any time. To preserve manual changes to this file, delete this comment.-->
加入数据源配置,配置后的server8080.xml如下:
<?xml version="1.0" encoding="UTF-8"?>
<Server debug="0" port="8081" shutdown="SHUTDOWN">
<Service name="Tomcat-Standalone">
<Connector acceptCount="10" className="org.apache.coyote.tomcat4.CoyoteConnector" connectionTimeout="60000" debug="0" maxProcessors="75" minProcessors="5" port="8080" useURIValidationHack="false"/>
<Engine debug="0" defaultHost="localhost" name="Standalone">
<Host appBase="D:\Java\Project\StuManage\Tomcat\webapps" debug="0" name="localhost" unpackWARs="true">
<Context debug="0" docBase="D:\Java\Project\StuManage\StudentManage" path="/StudentManage" reloadable="true" workDir="D:\Java\Project\StuManage\Tomcat\work\StudentManage">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true" />
<Resource name="jdbc/msSQLDB"
auth="Container"
type="javax.sql.DataSource" />
<ResourceParams name="jdbc/msSQLDB">
<Parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</Parameter>
<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>username</name>
<value>stu</value>
</Parameter>
<Parameter>
<name>password</name>
<value>123456</value>
</Parameter>
<Parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</Parameter>
<Parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;dataBaseName=StuManage</value>
</Parameter>
</ResourceParams>
</Context>
</Host>
</Engine>
</Service>
</Server>
可是在如下代码:
Context ctx = new InitialContext();
ds = (DataSource)ctx.lookup("java:comp/env/jdbc/msSQLDB");
System.out.println(ds.toString());
Connection conn = ds.getConnection();
出现错误,而且server8080.xml被自动恢复成原来的内容.
信息: Initializing Coyote HTTP/1.1 on port 8080

Starting service Tomcat-Standalone

Apache Tomcat/4.1.30

HostConfig[localhost]: Deploying configuration descriptor jb-StudentManage.xml

CoyoteConnector Coyote can't register jmx for protocol

2005-8-3 22:58:18 org.apache.coyote.http11.Http11Protocol start

信息: Starting Coyote HTTP/1.1 on port 8080

org.apache.commons.dbcp.BasicDataSource@7f5580

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause:

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getDriver(DriverManager.java:243)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:743)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)

at com.xmliu.db.ConnPool.<init>(ConnPool.java:13)

at org.apache.jsp.Login_jsp._jspService(Login_jsp.java:90)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

at java.lang.Thread.run(Thread.java:534)

请求各位大哥帮忙啊!!!

[gameover1999]

在线等,求救!!!

[gameover1999]

jb2005 + Tomcat4.1

[gameover1999]

lib中已经加入了那三个.jar了

[gameover1999]

唉,只有自己顶了.

[fbbobo]

"No suitable driver"
把mssqlserver的connector加到lib里

[gameover1999]

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
从这一句来看,好象根本就没找到配置的那个DataSource.我在(项目文件夹\Tomcat\conf\server8080.xml)中配置的DataSource被自动删除了.我应该在(Tomcat\conf\server.xml)中配置DataSource还是在(项目文件夹\Tomcat\conf\server8080.xml)中配置呢? 还有一个文件(项目文件夹\Tomcat\webapps\jb-StudentManage.xml)是干什么用的呢?(其中StudentMange是我的项目名称)

[gameover1999]

up