62,629
社区成员
发帖
与我相关
我的任务
分享请看我的代码,是一个用tdsDriver连接SQL Server的程序,为何出现:Error reading request connection reset
package testjdbc2;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class test extends HttpServlet {
private static final String CONTENT_TYPE = "text/html";
/**Initialize global variables*/
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><meta http-equiv=Content-Type content=text/html; charset=gb2312><title>test</title></head>");
out.println("<body>");
try {
Class.forName("com.inet.tds.TdsDriver").newInstance();
Connection Con = DriverManager.getConnection("jdbc:inetdae:10.1.22.116:1433?sql7=true", "sa", "");
Statement stmt = Con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from hechuan");
while(rs.next()) {
out.print("<p>" + rs.getString("name") + " ");
out.print(rs.getString("age") + " ");
out.print(rs.getString("pwd") + "</p>");
}
stmt.close();
Con.close();
}
catch (SQLException e) {
System.out.println(e.getMessage());
}
catch (Exception er) {
System.out.println(er.getMessage());
}
out.println("</body></html>");
}
/**Clean up resources*/
public void destroy() {
}
}
运行后出现以下输出:
com.inet.tds.TdsDriver
Error reading request connection reset
Context log path="" :invoker: init
Context log path="" :testjdbc2.test: init
是什么原因?
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class test extends HttpServlet {
private static final String CONTENT_TYPE = "text/html";
/**Initialize global variables*/
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><meta http-equiv=Content-Type content=text/html; charset=gb2312><title>test</title></head>");
out.println("<body>");
try {
Class.forName("com.inet.tds.TdsDriver").newInstance();
Connection Con = DriverManager.getConnection("jdbc:inetdae:10.1.22.116:1433?sql7=true", "sa", "");
Statement stmt = Con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from hechuan");
while(rs.next()) {
out.print("<p>" + rs.getString("name") + " ");
out.print(rs.getString("age") + " ");
out.print(rs.getString("pwd") + "</p>");
}
stmt.close();
Con.close();
}
catch (SQLException e) {
System.out.println(e.getMessage());
}
catch (Exception er) {
System.out.println(er.getMessage());
}
out.println("</body></html>");
}
/**Clean up resources*/
public void destroy() {
}
}
运行后出现以下输出:
com.inet.tds.TdsDriver
Error reading request connection reset
Context log path="" :invoker: init
Context log path="" :testjdbc2.test: init
是什么原因?
...全文
请发表友善的回复…
发表回复
luodi 2001-04-13
- 打赏
- 举报
我怀疑你的jdbc url写错了，因为我好象没有看见你指明是用哪一个数据库。
再去看看Driver的文档，看看URL格式定义是什么样的。
再去看看Driver的文档，看看URL格式定义是什么样的。
