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 - Monitor
Date Tue, 06 Apr 2004 18:00:53 GMT
Richard,

I am already setting autoReconnect=true. I just want to know if exists any method that returns
the # of opened connections are in the pool.

Thanks. 




On Tue, 6 Apr 2004 10:54:06 -0700 (PDT), Richard Yee <ryee86@yahoo.com> escreveu:

> De: Richard Yee <ryee86@yahoo.com>
> Data: Tue, 6 Apr 2004 10:54:06 -0700 (PDT)
> Para: Struts Users Mailing List <user@struts.apache.org>
> Assunto: Re: Connection Pooling - Monitor
> 
> Marcelo,
> The # of connections is determined by the value you
> set when you defined your datasource. What is the URL
> that you are using? You should set autoReconnect=true
> in the URL.
> 
> -Richard
> 
> 
> 
> --- Marcelo Epstein <marcelo@epstein.com.br> wrote:
> > 
> > Is it possible to know how many connection are in
> > the pool ? Is there any monitor available?
> > 
> > 
> > On Tue,  6 Apr 2004 14:15:34 -0300, "Marcelo
> > Epstein" <marcelo@epstein.com.br> escreveu:
> > 
> > > De: "Marcelo Epstein" <marcelo@epstein.com.br>
> > > Data: Tue,  6 Apr 2004 14:15:34 -0300
> > > Para: "Struts Users Mailing List"
> > <user@struts.apache.org>
> > > Assunto: Re: Connection Pooling (How i use...)
> > > 
> > > 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
> > 
> === message truncated ===
> 
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business $15K Web Design Giveaway 
> http://promotions.yahoo.com/design_giveaway/
> 
> ---------------------------------------------------------------------
> 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