How do i configure DBCP to support *caching* and reusing *
PreparedStatements?*
**
*Thanks*
*dev*

Have you tried the poolPreparedStatements and PreparedStatements
configuration properties?

You can read about DBCP configuration here:

is this a wrong mailist to ask question about Commons Database Connection
Pool (DBCP) or what?

Dev
--
9/2/06, Abhijit Akhawe <abhi.akhawe (AT) gmail (DOT) comwrote:
>>
>Wht DBCP?
>>
>>
>9/2/06, dev dev <gumiyo (AT) gmail (DOT) comwrote:
>>
>How do i configure DBCP to support *caching* and reusing *
>PreparedStatements?*
>**
>*Thanks*
>*dev*
>>
>>
>>
>>
>--
>Regards,
>Abhijit Akhawe.
>>
>>
>

James Carman, President
Carman Consulting, Inc.

To unsubscribe, e-mail: commons-user-unsubscribe (AT) jakarta (DOT) apache.org
For additional commands, e-mail: commons-user-help (AT) jakarta (DOT) apache.org

it DESN"T seem to work as expected. Does anyone use these parameters
below for their procedure calls (callablestatements) and make sure that
these PreparedStatements pooled objects are not being recycled or worked as
expected?

Thanks
dev

poolPreparedStatements false Enable prepared statement pooling for this
pool. PreparedStatements unlimited The maximum number of open
statements that can be allocated from the statement pool at the same time,
or zero for no limit.

9/2/06, James Carman <james (AT) carmanconsulting (DOT) comwrote:

Have you tried the poolPreparedStatements and PreparedStatements
configuration properties?

You can read about DBCP configuration here:

is this a wrong mailist to ask question about Commons Database
Connection
Pool (DBCP) or what?

Dev
--
9/2/06, Abhijit Akhawe <abhi.akhawe (AT) gmail (DOT) comwrote:
>>
>Wht DBCP?
>>
>>
>9/2/06, dev dev <gumiyo (AT) gmail (DOT) comwrote:
>>
>How do i configure DBCP to support *caching* and reusing *
>PreparedStatements?*
>**
>*Thanks*
>*dev*
>>
>>
>>
>>
>--
>Regards,
>Abhijit Akhawe.
>>
>>
>
>
>
James Carman, President
Carman Consulting, Inc.
--

To unsubscribe, e-mail: commons-user-unsubscribe (AT) jakarta (DOT) apache.org
For additional commands, e-mail: commons-user-help (AT) jakarta (DOT) apache.org
--