struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Lowe <mark.l...@boxstuff.com>
Subject Re: Connection Pooling (How i use...)
Date Tue, 06 Apr 2004 17:24:12 GMT
Marcelo

Could you do me the huge favor of keeping the version 3 drivers for  
another 20 hours but with the changes you've made (finally block  
stuff)..

And tell us what happens in 20 or so hours. I'd be very interested in  
what you find.

On 6 Apr 2004, at 19:15, Marcelo Epstein wrote:

> 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
>


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


Mime
View raw message