Hello, I am moving to the use of DBCP connection pooling. This means that I have to add the parameters to my SERVER.XML file to configure it. I would like to know what people would recommend as values for these parameters and why, specially any ones where you are not using the default:
My Thanks, Andoni. maxActive = 8 (0 => no limit) maxIdle = 8 (0 => no limit) maxWait = -1 (wait indefinitely) // I am fairly sure I am going to leave these as defaults, any reasons why not? defaultAutoCommit = true defaultReadOnly = false validationQuery = null // These are really only about logging unclosed connections... removeAbandoned = false removeAbandonedTimeout = 300 (specified in seconds, only in play if removeAbandoned is true) logAbandoned = false // These are obvious, please don't send me your passwords ;-) driverClassName password url username
