• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

about "error establishing socket"??

hi,experts,in my project ,about some time (10s or 30s) ,the error" java.sql.SqLException:[Microsoft] [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.setCharacterEncoding("gb2312"); %>
<%@ page import="java.sql.*"%>
<%
            String sqlDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
            String sqlJdbc = "jdbc:microsoft:sqlserver://btns:1433;DatabaseName=CommunityMedical";
            String sqlUser = "sa";
            String sqlPwd = "btn";
            try {
                  Class.forName(sqlDriver);
                  Connection conn = DriverManager.getConnection(sqlJdbc, sqlUser, sqlPwd);
                  java.sql.Statement stmt = conn.createStatement();
            java.sql.ResultSet rs=stmt.executeQuery("select 1");
            if(rs.next()){
              out.println("ok");
            }
            } catch (Exception e) {
                  out.println(e);
            }
%>

why the error is show????

thanks!
0
hgbdelphi
Asked:
hgbdelphi
  • 3
  • 3
1 Solution
 
hgbdelphiAuthor Commented:
can any exters help me ,it's sqlserver2000's bug?but i use splserver2000+sp3,and when i use resin or tomcat the error is show in two server.
0
 
TimYatesCommented:
Do you ever close your Statements and Connections?

Try:

<%@ page contentType="text/html; charset=gb2312" %>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="java.sql.*"%>
<%
          String sqlDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
          String sqlJdbc = "jdbc:microsoft:sqlserver://btns:1433;DatabaseName=CommunityMedical";
          String sqlUser = "sa";
          String sqlPwd = "btn";
          Connection conn =  null ;
          java.sql.Statement stmt = null ;
          try {
               Class.forName(sqlDriver);
               conn = DriverManager.getConnection(sqlJdbc, sqlUser, sqlPwd);
               stmt = conn.createStatement();
               java.sql.ResultSet rs=stmt.executeQuery("select 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 ) {}
          }
%>
0
 
hgbdelphiAuthor Commented:
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!
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
TimYatesCommented:
> i dont't close the Statements and Connections,and this will create  "error establishing socket",and not another case??

Yes, this will cause the problem, as SQLServer will run out of sockets.  You need to close statements and sockets...

You can use a connection pool which will speed up your connection getting (and stop you using too many concurrent connections)

This is how to do it with Tomcat:

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
0
 
hgbdelphiAuthor Commented:
thanks! i will change my code.


   Best Regard!
0
 
TimYatesCommented:
Good luck!!

:-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now