Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MaxStatements meaning

843859Mar 23 2009 — edited Mar 24 2009
I'd like to know what does the ConnectionPoolDataSource maxstatements property mean. I saw on c3p0 site (http://www.mchange.com/projects/c3p0/index.html#configuring_statement_pooling) that it should be a multiple of the length of the connection pool, e.g. if I set 5 to both minPoolSize and maxPoolSize (static size) and I want 5 statements per connection, I should set 25 (5x5) to the maxstatements property.

Is it true?

If yes or or not, please, if you have, post the documentation or link that ensures this, because I did not find at Sun's pages.

Chico.br
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2009
Added on Mar 23 2009
7 comments
3,010 views