Java开发网 - jsp连SQL2000的问题？

Topic: jsp连SQL2000的问题？

1.jsp连SQL2000的问题？

Posted by: wmaofengjava
Posted on: 2005-02-16 16:26

我的CLASS-PATH是这样设的：
.;C:\j2sdk1.4.2\lib;C:\j2sdk1.4.2\lib\dt.jar;C:\j2sdk1.4.2\lib\tools.jar;C:\Tomcat 5.0\common\lib\servlet.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;msbase.jar\mssqlserver.jar;mssqlserver.jar\msutil.jar 但是在连接的时候却报这样错误,页面内容是别人写好的肯定没有错误:
type Exception report

message

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

exception

javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDriver
  org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
  org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
  org.apache.jsp.mydb_jsp._jspService(mydb_jsp.java:85)
  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

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
  org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1340)
  org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
  org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:148)
  org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:69)
  java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
  java.lang.Class.forName0(Native Method)
  java.lang.Class.forName(Class.java:141)
  org.apache.jsp.mydb_jsp._jspService(mydb_jsp.java:47)
  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.29 logs.

2.Re:jsp连SQL2000的问题？ [Re: wmaofengjava]	Copy to clipboard
Posted by: wmaofengjava Posted on: 2005-02-16 16:28 这肯定是驱动没找到啊!但是我就是不知道为什么它找不到,我不是也设置了吗? 请大侠赐教!

3.Re:jsp连SQL2000的问题？ [Re: wmaofengjava]	Copy to clipboard
Posted by: 孤独王子 Posted on: 2005-02-17 10:01 bin加里干吗？你注意以下，最好不要代空格，我以前也是出现过类似问题你重新安装一下八空格的路径改一下载是试看

4.Re:jsp连SQL2000的问题？ [Re: wmaofengjava]	Copy to clipboard
Posted by: henbane Posted on: 2005-03-18 11:16 这样的问题我到现在也解决不了，能否请斑竹或高手开个专题介绍一下啊？

5.Re:jsp连SQL2000的问题？ [Re: wmaofengjava]	Copy to clipboard
Posted by: lfxlixiang Posted on: 2005-03-20 15:23 你还需要一个JDBS的jar包，可以去官方网站去下载，然后在CLASSPATH中指向它就行了

6.Re:jsp连SQL2000的问题？ [Re: wmaofengjava]

Copy to clipboard

Posted by: why
Posted on: 2005-03-20 20:13

.;C:\j2sdk1.4.2\lib;C:\j2sdk1.4.2\lib\dt.jar;C:\j2sdk1.4.2\lib\tools.jar;C:\Tomcat 5.0\common\lib\servlet.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;msbase.jar\mssqlserver.jar;mssqlserver.jar\msutil.jar
綠色的可省
紅色的閣下說說是甚麼? 好好修正吧. Embaressed

例如
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar
不過敝人建議classpath上的東東不要有空格

事實上, 視乎情況而定, 閣下不必修改classpath, 只要把M$的jar's放在$TOMCAT$\common\lib或個別webapps的WEB-INF\lib下就可以了

this topic may be redirected to another board later...