Java开发网 - jsp 连接sql server2000 的问题？

Topic: jsp 连接sql server2000 的问题？

1.jsp 连接sql server2000 的问题？

Posted by: qingfenglz
Posted on: 2005-09-05 17:10

jsp 连接sqlserver2000出错，出错代码：
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

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

exception

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
  org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
  org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
  org.apache.jsp.example_jsp._jspService(org.apache.jsp.example_jsp:88)
  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
  com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
  com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
  com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
  com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
  com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
  com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
  com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
  com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
  java.sql.DriverManager.getConnection(Unknown Source)
  java.sql.DriverManager.getConnection(Unknown Source)
  org.apache.jsp.example_jsp._jspService(org.apache.jsp.example_jsp:55)
  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

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

--------------------------------------------------------------------------------

Apache Tomcat/5.5.11

我已经把那三个.jar文件放在了common/lib下了！

2.Re:jsp 连接sql server2000 的问题？ [Re: qingfenglz]	Copy to clipboard
Posted by: scottlai Posted on: 2005-09-05 17:32 你的SQL2000 有裝SP3"A"嗎?

3.Re:jsp 连接sql server2000 的问题？ [Re: qingfenglz]	Copy to clipboard
Posted by: qingfenglz Posted on: 2005-09-05 21:03 没有啊！

4.Re:jsp 连接sql server2000 的问题？ [Re: qingfenglz]	Copy to clipboard
Posted by: scottlai Posted on: 2005-09-05 21:27 那就去下載裝囉

5.Re:jsp 连接sql server2000 的问题？ [Re: qingfenglz]	Copy to clipboard
Posted by: why Posted on: 2005-09-05 22:27 发贴前请使用本论坛的搜索功能查找相关主题 You should be able to find something similar on this forum (Database board or FAQ) http://www.cjsdn.net/post/search

6.Re:jsp 连接sql server2000 的问题？ [Re: qingfenglz]	Copy to clipboard
Posted by: huhui202020 Posted on: 2005-09-18 16:54 可能是驱动错误吧

7.Re:jsp 连接sql server2000 的问题？ [Re: qingfenglz]	Copy to clipboard
Posted by: yixiugg Posted on: 2005-09-21 13:58 安装sp3

8.Re:jsp 连接sql server2000 的问题？ [Re: qingfenglz]	Copy to clipboard
Posted by: cpground Posted on: 2005-09-21 17:47 如果你用的是连接数据源,那三个文件要放在WEB-INF\lib\下面.