CODEWITHSUNDEEP
javac3p0
user1016403
user1016403

Reputation: 12621

C3P0 max statements configuration?

I am using C3P0. i have below configuration. i need to cache the statements.

maxPoolSize="20" 
minPoolSize="6" 
acquireIncrement="3"
initialPoolSize="3"
maxStatements="2000"

here i have set maxStatements to 2000. maxPoolSize is 20. does it mean total 2000*20=40000 statements wil be cached?

Thanks!

Upvotes: 8

Views: 16090

Answers (1)

Gareth Davis
Gareth Davis

Reputation: 28069

no maxStatements is the global cache max size.

maxStatementsPerConnection is the per connection value.

Relevant section the c3p0 docs

Upvotes: 7

Related Questions