Database connectivity problems

[Frank hogan]

I am using Visualge Java 4.0, using ConnectionPool class to create a set of connections. Watz happening is when my TOMCAT server goes down or for for that matter of fact some unknown reason how do I make sure to re-establish connectivity.
Also when transaction fails or database goes down and bad connection exists in the pool what do I do if someother TX is trying to use it
.
Thanks

[Maximilian Xavier Stocker]

Are you trying to roll your own connection pool? Why would you desire to do this when there are so many out there already (and open source free ones as well) ?