Prepared Statement Pooling

[Modha Kumar <mo...@hotmail.com>]

Hi All

What is Prepared Statement Pooling?

I read " Improvements to the prepared statement pooling" are there in 
current DBCP.
How do I enable it?

Is there any documentation for this.

Thanks

_________________________________________________________________
Make money with Zero Investment. 
http://adfarm.mediaplex.com/ad/ck/4686-26272-10936-31?ck=RegSell Start your 
business.


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

Re: Prepared Statement Pooling

[Michael Starkie <sk...@gmail.com>]

Statement pooling is the ability to re-use sql statement objects. 
It's a service offered by DBCP.  DBCP uses commons-pool which is a
generic pooling api to pool sql connections and optionally statements.
 I highly recommend the following article to help you understand the
fundamentals and look at some examples:

http://www.manning.com/catalog/view.php?book=goyal9




On Mon, 28 Mar 2005 01:35:50 +0000, Modha Kumar <mo...@hotmail.com> wrote:
> Hi All
> 
> What is Prepared Statement Pooling?
> 
> I read " Improvements to the prepared statement pooling" are there in
> current DBCP.
> How do I enable it?
> 
> Is there any documentation for this.
> 
> Thanks
> 
> _________________________________________________________________
> Make money with Zero Investment.
> http://adfarm.mediaplex.com/ad/ck/4686-26272-10936-31?ck=RegSell Start your
> business.
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
> 
>

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