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]
