My intension was not to close the the connection and check whether DBCP is going to handle this for me becuase I have set 'removeAbandoned' paramter in server.xml.
> -----Original Message----- > From: Joaquim [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 10, 2002 11:34 AM > To: Tomcat Users List > Subject: Re: removeAbandoned does not work > > > Are you getting any exception? The close statements are in the try > catch block, > if you get an exception, they not be executed. I would put the close > statements > in a finally statement, to ensure that they would be executed. > > Kranthi Yemula wrote: > > >Hi, > > > >I am using tomcat 4.0.3. I am playing with Datasources. > >I am having trouble validating 'removing abandoned database pool > >connections'. > > > >I did the below: > >----------------------------------------------- > >1) I have set up the below parameters in my server.xml > > > ><!-- configure your DBCP DataSource so that abandoned dB > connections are > >removed and recycled --> > ><parameter> > ><name>removeAbandoned</name> > ><value>true</value> > ></parameter> > ><!-- Use the removeAbandonedTimeout parameter to set the > number of seconds a > >dB connection has been idle before it is considered abandoned. > >Default time is 300 seconds. Here we are choosing 60 seconds. --> > ><parameter> > ><name>removeAbandonedTimeout</name> > ><value>20</value> > ></parameter> > ><!-- The logAbandoned parameter can be set to true if you > want DBCP to log a > >stack trace of the code which abandoned the dB connection resources. > >Default is false. --> > ><parameter> > ><name>logAbandoned</name> > ><value>true</value> > ></parameter> > > > >----------------------------------------------- > > > >2) I modified my test program so that it does not close > databse connection. > > > > > >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"); > > > > Context envCtx = (Context) ctx.lookup("java:comp/env"); > > > > // Look up our data source > > DataSource ds = > (DataSource)ctx.lookup("java:comp/env/jdbc/Kranthi"); > > > > > > 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); > > } > > /*stmt.close(); > > rst.close(); > > conn.close(); > > */ > > } > > } > > }catch(Exception e) { > > e.printStackTrace(); > > } > > } > > > >------------------------------------------------------------- > --------------- > >-------------- > > > >I call the jsp that calls the above java program. But, its > not actually > >closing the open connections. > > > >Can anybody please help me. > > > >Thanks, > >KYemula. > > > > > > > > > > -- > Joaquim Laureano > Lusostar Technologies, LLC > Phone: 732-542-4890 > Email: [EMAIL PROTECTED] > > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
