在window2003下 JSP连接sql server 出现的错误

[yuqianloveme]

HTTP Status 500 -

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

type Exception report

message

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

exception

org.apache.jasper.JasperException: /jsp.jsp(1,4) Invalid directive
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:39)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:357)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:81)
org.apache.jasper.compiler.Parser.parseDirective(Parser.java:506)
org.apache.jasper.compiler.Parser.parseElements(Parser.java:1539)
org.apache.jasper.compiler.Parser.parse(Parser.java:126)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:220)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:101)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:196)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:398)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:507)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:277)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:223)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)


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

[常遇道]

你的环境配了没有
补丁打了吧

[yuqianloveme]

环境配了.什么补丁

[yuqianloveme]

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:822)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:755)
org.apache.jsp.jsp_jsp._jspService(jsp_jsp.java:80)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:268)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:277)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:223)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)


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(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.jsp_jsp._jspService(jsp_jsp.java:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:268)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:277)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:223)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)


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

[yuqianloveme]

这是什么错误呀.

[常遇道]

打sqlserver200 sp3包
打jdbc驅動包驱动
jdbc驅動包驱动的三个包放在你项目的WEB-INF/lib/下,最好放common/lib/下
设置CLASSPATH:
.;C:\jdk1.5\lib\tools.jar;C:\jdk1.5\lib\dt.jar;
C:\jdk1.5\jre\lib\rt.jar;C:\jdk1.5\lib\msbase.jar;
C:\jdk1.5\lib\msutil.jar;C:\jdk1.5\lib\mssqlserver.jar;
%Tomcat_Home%\common\lib\servlet-api.jar;

[wsk_228]

1.打sqlserver200 sp3补丁
2.放驱动以ms开头的三个.jar在你项目WEB-INF/lib/下

[柯本]

咳...
每天都有人有Error establishing socket错,google中约有8,940个
我都回过不下十次了,这个问题不知FAQ中无没有
再回一次:
1.首先,与驱动无关
2.你的sqlserver启动了吗?
3.你的sqlserver打补丁了吗?
4.你安装sqlserver时用混合验证了吗?
5.你开防火墙了吗?
如果你是连本机的sqlserver
请在cmd方式下用中运行netstat -na
看一下1433端口,如果无监听,那是你的sqlserver本身有问题

[single_study]

没有打sp3的问题

[yuqianloveme]

搞定,谢谢各位!