[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

about "error establishing socket"??

Posted on 2004-10-13
6
Medium Priority
?
323 Views
Last Modified: 2010-04-01
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
Comment
Question by:hgbdelphi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 

Author Comment

by:hgbdelphi
ID: 12305795
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
 
LVL 35

Expert Comment

by:TimYates
ID: 12306031
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
 

Author Comment

by:hgbdelphi
ID: 12314062
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 35

Accepted Solution

by:
TimYates earned 400 total points
ID: 12317235
> 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
 

Author Comment

by:hgbdelphi
ID: 12335155
thanks! i will change my code.


   Best Regard!
0
 
LVL 35

Expert Comment

by:TimYates
ID: 12336846
Good luck!!

:-)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working from home is a dream for many people who aren’t happy about getting up early, going to the office, and spending long hours at work. There are lots of benefits of remote work for employees.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question