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] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
