You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Jitesh Sinha <js...@cisco.com> on 2003/12/17 10:41:52 UTC

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: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org


RE: [OT ]BasicDataSource class of package org.apache.commons.dbcp

Posted by Jitesh Sinha <js...@cisco.com>.
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:chekuri_raju@yahoo.com]
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 <js...@cisco.com> wrote:
No friends for me on this list ! :(

-----Original Message-----
From: Jitesh Sinha [mailto:jsinha@cisco.com]
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: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org


---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now


---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org


RE: [OT ]BasicDataSource class of package org.apache.commons.dbcp

Posted by chekuri raju <ch...@yahoo.com>.
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 <js...@cisco.com> wrote:
No friends for me on this list ! :(

-----Original Message-----
From: Jitesh Sinha [mailto:jsinha@cisco.com]
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: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org


---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now

RE: BasicDataSource class of package org.apache.commons.dbcp

Posted by Jitesh Sinha <js...@cisco.com>.
No friends for me on this list ! :(

-----Original Message-----
From: Jitesh Sinha [mailto:jsinha@cisco.com]
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: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org