I am also having trouble confirming that Prepared Statements are being pooled.
I previously sent the following message to the list related to DBCP but got no responses. ----------------------------- I wanted to understand how can I verify that I have prepared statement pooling turned on when using DBCP. I am using JOCL files for configuring the connection pool. I have added the necessary XML snippet for enabling the Prepared Statement pooling ie define a StackKeyedObjectPoolFactory. Now when I can I get a PreparedStatement using the connection obtained from the pool and check its class using pstmt.getClass().getName() I get org.apache.commons.dbcp.DelegatingPreparedStatement but I was expecting org.apache.commons.dbcp.PoolablePreparedStatement Appreciate any help. -Rahul --- --- dev dev <[EMAIL PROTECTED]> wrote: > it DOESN"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. maxOpenPreparedStatements unlimited The > maximum number of open > statements that can be allocated from the statement > pool at the same time, > or zero for no limit. > > > On 9/2/06, James Carman <[EMAIL PROTECTED]> > wrote: > > > > Have you tried the poolPreparedStatements and > maxOpenPreparedStatements > > configuration properties? > > > > You can read about DBCP configuration here: > > > > > http://jakarta.apache.org/commons/dbcp/configuration.html > > > > > is this a wrong mailist to ask question about > Commons Database > > Connection > > > Pool (DBCP) or what? > > > > > > Dev > > > > > > > > > On 9/2/06, Abhijit Akhawe > <[EMAIL PROTECTED]> wrote: > > >> > > >> Wht DBCP? > > >> > > >> > > >> On 9/2/06, dev dev <[EMAIL PROTECTED]> wrote: > > >> > > > >> > 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: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
