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
