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

[Mark Lowe]

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"  
<[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]