java连不上sqlserver,tomcat上sqlserver连不上,该如何处理

当前位置:我的异常网» Java Web开发 » tomcat上sqlserver连不上,该如何处理

tomcat上sqlserver连不上,该如何处理

www.myexceptions.net  网友分享于：2013-09-12  浏览：88次

tomcat上sqlserver连不上

我用的是tomcat5.0和sqlserver2000，       可是数据库老是连不上

用的测试代码：

Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();

String   url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs ";

String   user= "sa ";

String   password= "sa ";

Connection   conn=   DriverManager.getConnection(url,user,password);

Statement   stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String   sql= "select   *   from   xt_user ";

ResultSet   rs=stmt.executeQuery(sql);

while(rs.next())

{

%>

您的第一个字段内容为：

您的第二个字段内容为：

}

%>

rs.close();

stmt.close();

conn.close();

%>

错误：

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

exception

org.apache.jasper.JasperException:   Exception   in   JSP:   /test.jsp:19

16:

17:         String   password= "sa ";

18:

19:         Connection   conn=   DriverManager.getConnection(url,user,password);

20:

21:         Statement   stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

22:

Stacktrace:

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:506)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)

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

javax.servlet.ServletException:   [Microsoft][SQLServer   2000   Driver   for   JDBC]Error   establishing   socket.

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:843)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:776)

org.apache.jsp.test_jsp._jspService(test_jsp.java:114)

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:334)

文章评论