SV: Connection Pooling (How i use...)

[hermod . opstvedt]

Hi

First of all - You have a memory leak in your application - Because :
you do not close your resultset !! This may eventually lead to awkward
situations.

Hermod

-----Opprinnelig melding-----
Fra: Marcelo Epstein [mailto:[EMAIL PROTECTED]
Sendt: 6. april 2004 18:31
Til: Struts Users Mailing List
Emne: Re: Connection Pooling (How i use...)


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]


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

This email with attachments is solely for the use of the individual or
entity to whom it is addressed. Please also be aware that DnB NOR cannot
accept any payment orders or other legally binding correspondence with
customers as a part of an email. 

This email message has been virus checked by the virus programs used
in the DnB NOR Group.

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]