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]
