struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcelo Epstein" <marc...@epstein.com.br>
Subject Re: Connection Pooling (How i use...)
Date Tue, 06 Apr 2004 17:15:34 GMT
Now I am closing the connection in the finally block.
The exemple provided by:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html
doesn´t do that:
package foo;

import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class DBTest {

  String foo = "Not Connected";
  int bar = -1;
    
  public void init() {
    try{
      Context ctx = new InitialContext();
      if(ctx == null ) 
          throw new Exception("Boom - No Context");

      DataSource ds = 
            (DataSource)ctx.lookup(
               "java:comp/env/jdbc/TestDB");

      if (ds != null) {
        Connection conn = ds.getConnection();
              
        if(conn != null)  {
            foo = "Got Connection "+conn.toString();
            Statement stmt = conn.createStatement();
            ResultSet rst = 
                stmt.executeQuery(
                  "select id, foo, bar from testdata");
            if(rst.next()) {
               foo=rst.getString(2);
               bar=rst.getInt(3);
            }
            conn.close();
        }
      }
    }catch(Exception e) {
      e.printStackTrace();
    }
 }

 public String getFoo() { return foo; }
 public int getBar() { return bar;}
}




On Tue, 06 Apr 2004 12:50:29 -0400, "Geeta Ramani" <geeta.ramani@cmpco.com> escreveu:

> De: "Geeta Ramani" <geeta.ramani@cmpco.com>
> Data: Tue, 06 Apr 2004 12:50:29 -0400
> Para: Struts Users Mailing List <user@struts.apache.org>
> Assunto: Re: Connection Pooling (How i use...)
> 
> This your problem: closing the connection in your try block. Move it to a finally block..
> 
> Marcelo Epstein wrote:
> 
> > I use the pool like this: (IS IT WRONG??) I think the connection is being closed..
> >
> > try {
> >         Context ctx = new InitialContext();
> >         if (ctx == null)
> >               throw new Exception("Boom - No Context");
> >
> >               DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/EasyDB");
> >
> >               if (ds != null) {
> >                 Connection conn = ds.getConnection();
> >                 if (conn != null) {
> >                         Statement stmt = conn.createStatement();
> >                         String query ="Any query";
> >                         ResultSet rs = stmt.executeQuery(query);
> >                         while (rs.next()) {
> >                                                               "Use ResulSet"
> >
> >                         }
> >                                 stmt.close();
> >                         conn.close();
> >                 }
> >             }
> >         } catch (Exception ex) {
> >                 System.out.println(ex.toString());
> >         }
> >
> > On Tue, 06 Apr 2004 10:19:15 -0600, "Larry Meadors" <Larry.Meadors@plumcreek.com>
escreveu:
> >
> > > De: "Larry Meadors" <Larry.Meadors@plumcreek.com>
> > > Data: Tue, 06 Apr 2004 10:19:15 -0600
> > > Para: <user@struts.apache.org>
> > > Assunto: Re: Connection Pooling
> > >
> > > My bet is on a connection leak - you open one in a try block and don't close
it in the finally block.
> > >
> > > >>> marcelo@epstein.com.br 04/06/04 10:08 AM >>>
> > > Hi,
> > >
> > > I have just started using Connection Pooling in my app  (Tomcat, Struts, DBCP,
Mysql) .
> > > It woks for about 20 hours and stop working until tomcat restart.
> > >
> > > I get this exception:
> > >
> > > org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted,
cause:
> > > java.util.NoSuchElementException: Timeout waiting for idle object
> > >
> > > I canÌ t fix it. Any advice??
> > >
> > > Thanks in advance.
> > > Marcelo
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > > For additional commands, e-mail: user-help@struts.apache.org
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > > For additional commands, e-mail: user-help@struts.apache.org
> > >
> > >
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > For additional commands, e-mail: user-help@struts.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
> 
> 
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Mime
View raw message