General J2EE: Connection Pooling
I had to write a code for ConnectionPooling. I cannot use any properties of container
So is there any pattern or example to how to write code for connection pooling for Type 4 driver
It's not too difficult to roll your own but you have to be careful to re-initialise connections if they go stale. Also you can get leaks if your code does not release the conenctons back into the pool once used. This is why it's best to use a JDBC driver that does pooling for you. Is there a reason why you can't use the JDBC driver connection pool ?
Website and Server Monitoring | Email Marketing | Website Analysis