Thanks Chekuri and Ben for your replies...meanwhile I have done some research on BasicDataSource and found a few things..will post once I am totally sure about that...
-----Original Message----- From: chekuri raju [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 7:49 PM To: Struts Users Mailing List Subject: RE: [OT ]BasicDataSource class of package org.apache.commons.dbcp hello jitesh, why do u need to bother about BasicDataSource code if u r running it on any server just configure the configuration files and use JNDI lookup to get the connection and your close() on Connection object returns the con obj to pool regards srinivas Jitesh Sinha <[EMAIL PROTECTED]> wrote: No friends for me on this list ! :( -----Original Message----- From: Jitesh Sinha [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 3:12 PM To: Struts Users Mailing List Subject: BasicDataSource class of package org.apache.commons.dbcp Hello all, I am making use of BasicDataSource class to get connections .The code which I write to get a connection is as follows : basicDataSource = new BasicDataSource(); basicDataSource.setDefaultAutoCommit(autoCommit); basicDataSource.setUrl(jdbcUrl); basicDataSource.setDriverClassName(driver); basicDataSource.setUsername(user); basicDataSource.setPassword(password); basicDataSource.setMaxIdle(maxIdle); basicDataSource.setMaxActive(maxConn); basicDataSource.setRemoveAbandonedTimeout(removeAbandonedTimeout); basicDataSource.setMaxWait(maxWait); basicDataSource.setRemoveAbandoned(removeAbandoned); basicDataSource.setLogAbandoned(logAbandoned); basicDataSource.setValidationQuery(validationQuery); Connection conn =basicDataSource.getConnection() ; Does getConnection() method of BasicDataSource create a new connection to the database or internally manage some connection pool from which a new connection is taken? Will I need to write any extra code to make use of a connectionpool ? Thanks, Jitesh --------------------------------------------------------------------- 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] --------------------------------- Do you Yahoo!? Free Pop-Up Blocker - Get it now --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]