hgbdelphi
asked on
about "error establishing socket"??
hi,experts,in my project ,about some time (10s or 30s) ,the error" java.sql.SqLException:[Mic rosoft] [SQLServer:2000 driver for jdbc] Error establishing socket" will show in tomcat console.i use sqlserver2000 + sp3 + win2000 server,and my code like this:
<%@ page contentType="text/html; charset=gb2312" %>
<% request.setCharacterEncodi ng("gb2312 "); %>
<%@ page import="java.sql.*"%>
<%
String sqlDriver = "com.microsoft.jdbc.sqlser ver.SQLSer verDriver" ;
String sqlJdbc = "jdbc:microsoft:sqlserver: //btns:143 3;Database Name=Commu nityMedica l";
String sqlUser = "sa";
String sqlPwd = "btn";
try {
Class.forName(sqlDriver);
Connection conn = DriverManager.getConnectio n(sqlJdbc, sqlUser, sqlPwd);
java.sql.Statement stmt = conn.createStatement();
java.sql.ResultSet rs=stmt.executeQuery("sele ct 1");
if(rs.next()){
out.println("ok");
}
} catch (Exception e) {
out.println(e);
}
%>
why the error is show????
thanks!
<%@ page contentType="text/html; charset=gb2312" %>
<% request.setCharacterEncodi
<%@ page import="java.sql.*"%>
<%
String sqlDriver = "com.microsoft.jdbc.sqlser
String sqlJdbc = "jdbc:microsoft:sqlserver:
String sqlUser = "sa";
String sqlPwd = "btn";
try {
Class.forName(sqlDriver);
Connection conn = DriverManager.getConnectio
java.sql.Statement stmt = conn.createStatement();
java.sql.ResultSet rs=stmt.executeQuery("sele
if(rs.next()){
out.println("ok");
}
} catch (Exception e) {
out.println(e);
}
%>
why the error is show????
thanks!
Do you ever close your Statements and Connections?
Try:
<%@ page contentType="text/html; charset=gb2312" %>
<% request.setCharacterEncodi ng("gb2312 "); %>
<%@ page import="java.sql.*"%>
<%
String sqlDriver = "com.microsoft.jdbc.sqlser ver.SQLSer verDriver" ;
String sqlJdbc = "jdbc:microsoft:sqlserver: //btns:143 3;Database Name=Commu nityMedica l";
String sqlUser = "sa";
String sqlPwd = "btn";
Connection conn = null ;
java.sql.Statement stmt = null ;
try {
Class.forName(sqlDriver);
conn = DriverManager.getConnectio n(sqlJdbc, sqlUser, sqlPwd);
stmt = conn.createStatement();
java.sql.ResultSet rs=stmt.executeQuery("sele ct 1");
if(rs.next()){
out.println("ok");
}
} catch (Exception e) {
out.println(e);
} finally {
try { if( stmt != null ) stmt.close() ; } catch( Exception ex ) {}
try { if( conn != null ) conn.close() ; } catch( Exception ex ) {}
}
%>
Try:
<%@ page contentType="text/html; charset=gb2312" %>
<% request.setCharacterEncodi
<%@ page import="java.sql.*"%>
<%
String sqlDriver = "com.microsoft.jdbc.sqlser
String sqlJdbc = "jdbc:microsoft:sqlserver:
String sqlUser = "sa";
String sqlPwd = "btn";
Connection conn = null ;
java.sql.Statement stmt = null ;
try {
Class.forName(sqlDriver);
conn = DriverManager.getConnectio
stmt = conn.createStatement();
java.sql.ResultSet rs=stmt.executeQuery("sele
if(rs.next()){
out.println("ok");
}
} catch (Exception e) {
out.println(e);
} finally {
try { if( stmt != null ) stmt.close() ; } catch( Exception ex ) {}
try { if( conn != null ) conn.close() ; } catch( Exception ex ) {}
}
%>
ASKER
hi TimYates :
-->Do you ever close your Statements and Connections?
i dont't close the Statements and Connections,and this will create "error establishing socket",and not another case??
thanks!
-->Do you ever close your Statements and Connections?
i dont't close the Statements and Connections,and this will create "error establishing socket",and not another case??
thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks! i will change my code.
Best Regard!
Best Regard!
Good luck!!
:-)
:-)
ASKER