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 <[EMAIL PROTECTED]> escreveu: > De: Richard Yee <[EMAIL PROTECTED]> > Data: Tue, 6 Apr 2004 10:54:06 -0700 (PDT) > Para: Struts Users Mailing List <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> escreveu: > > > > > De: "Marcelo Epstein" <[EMAIL PROTECTED]> > > > Data: Tue, 6 Apr 2004 14:15:34 -0300 > > > Para: "Struts Users Mailing List" > > <[EMAIL PROTECTED]> > > > 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" > > <[EMAIL PROTECTED]> escreveu: > > > > > > > De: "Geeta Ramani" <[EMAIL PROTECTED]> > > > > Data: Tue, 06 Apr 2004 12:50:29 -0400 > > > > Para: Struts Users Mailing List > > <[EMAIL PROTECTED]> > > > > 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" <[EMAIL PROTECTED]> escreveu: > > > > > > > > > > > De: "Larry Meadors" > > <[EMAIL PROTECTED]> > > > > > > Data: Tue, 06 Apr 2004 10:19:15 -0600 > > > > > > Para: <[EMAIL PROTECTED]> > > > > > > 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. > > > > > > > > > > > > >>> [EMAIL PROTECTED] 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: > > [EMAIL PROTECTED] > > > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > === message truncated === > > > __________________________________ > Do you Yahoo!? > Yahoo! Small Business $15K Web Design Giveaway > http://promotions.yahoo.com/design_giveaway/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
