I have got a question regarding database connection pooling.
I know that inorder to enable connection pooling we have to set the parameter ‘watt.server.db.connectionCache=server’ in the server.cnf file.
I see one more setting for connection pooling when we are trying to create a database connection (let it be wmDB or JDBC).There is a property called ‘Enable connection pooling’.we have to set it to YES to enable connection pooling.
The only thing which I don’t understand is what is the difference between both of them.
Do we have to set both of them inorder to get the advantages of connection pooling???
I am not clear with the concept.Somebody pls try to help.