Tomcat Connection Pool Concept & c3p0 connection pooling?

A1: Yes. A2: Not sure if I got the question right, but you should only specify those connection properties which defaults do not make sense to you. It's probably best to do this in the separate c3p0.

Properties file and specify which connection which property applies to. Answer to 'additional configuration properties' question requires to know the specifics of your environment. I would recommend looking at idle_test_period setting as these can typically have wrong defaults (make sure this matches relevant setting on the DB end).

A3: Yeah, this looks OK. A4: You need to specify logging preferences in c3p0. Properties or define them in dynamically as System properties.

Refer to this chapter of the c3p0 manual.

A1: Yes A2: Looks right at first glance. You need to be careful with RAC in case you would use distributed transactions - then I believe you would have to specify additional properties. A3: Looks ok but depending on your task and estimated load I would play with maxIdleTime, acquireIncrement and maxPoolSize.

For example with current settings after 60 seconds of inactivity your connection will be closed so next operation requesting connection after 60 seconds would incur penalty in waiting for new connection to open. A4: mchange.com/projects/c3p0/index.html#con... Advice: There is a better connection pool from Tomcat 7, which could be used in Tomcat 6 as well. Consider it, especially if you need high performance Consider connection testing so your application don't get (or get less frequently) exception when db connectivity goes down It might be preferable to package connection pool and it's configuration within your application vs. in Tomcat.

This way application WAR would be self contained so it could be just dropped into wabapps dir of tomcat.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.