小弟昨日写了jsp连接sql server2000,但是连接不上,页面部分代码:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Message";
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 message";
ResultSet rs=stmt.executeQuery(sql);
报错信息:
exception org.apache.jasper.JasperException: Exception in JSP: /index.jsp:1815: String user="sa";
16:
17:
18: Connection conn=DriverManager.getConnection(url,user,"");
19:
20: Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
21:
Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)root cause
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
各位帮帮忙,小弟看了半天了,都想不出那里有错
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Message";
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 message";
ResultSet rs=stmt.executeQuery(sql);
报错信息:
exception org.apache.jasper.JasperException: Exception in JSP: /index.jsp:1815: String user="sa";
16:
17:
18: Connection conn=DriverManager.getConnection(url,user,"");
19:
20: Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
21:
Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)root cause
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
各位帮帮忙,小弟看了半天了,都想不出那里有错
解决方案 »
- tomcat技术博客
- ssh首页面的小小问题,请高人帮助解决
- 在HTML中加载 JVFalidation问题
- 请问怎样判断输入的是不是 html 代码???
- 熟悉DAO的来看看关于sh的DAO设计模式
- 如何在win2000下搭建jsp环境?(请详细一点)
- 调用servlet出现这个错误HTTP method POST is not supported by this URL
- jsp提交给sevlet时候出了错,麻烦帮看看
- 请问发邮件的组件mail.jar 和activation.jar应放在什么地方?
- servlet+jsp+ajax
- 网页效果,打开主页,过一会儿自动跳到下一页,怎么设计?
- JBuilder 2005里面如何插FLASH?
今天第三个问这种问题滴…………
你把sql的sp3还是sp4的补丁打上就行了,应该是sp3的