注册 登录
编程论坛 J2EE论坛

[求助]JSP连接数据库SQL Server2000问题

changyi5757 发布于 2006-03-25 12:40, 629 次点击

exception

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
	org.apache.jsp.ch9._1_jsp._jspService(_1_jsp.java:86)
	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.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.ch9._1_jsp._jspService(_1_jsp.java:52)
	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)
请问这是怎么回事?
我的jdk目录为C:\j2sdk1.4.2_05
tomcat目录为C:\Tomcat 5.0
数据库目录为C:\Program Files\Microsoft SQL Server
驱动目录为C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC
并把C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib下的三个包拷贝到了
C:\Tomcat 5.0\common\lib下,并在环境变量里的CLASSPATH下添加了这三个包
请高手帮忙
2 回复
#2
飘飘叶子2006-03-25 13:50
你是用什么进行连接的?
记得那3个包应该是copy到tomcat\webapps\工程名\WEB-INF\lib下
#3
wangtaobig2006-03-25 22:05

一般出现这个信息,主要是数据库出错了!可能你安装了防火墙,这时你需要把防火墙关掉,在关闭SQL SERVER 服务管理,然后在起动服务管理。就OK了,也不知道是不是你出错的原因!如果不对请包含!

1