I'm moving some code from a proprietary connection pool to a pooled DataSource in WebSphere 5.x. The authors of the existing pool put a lot of work into error recovery. One strategy is that when a SQL exception indicates communication errors they purge the pool and let it restart from scratch, which neatly recovers from a brief network burp.
I'm having trouble finding Sun
doc on what to expect from a DataSource in such a situation. There's no API to purge the pool, so I'm hoping it has some signficant smarts built in. Any pointers to doc on this?
We'll be on UDB and I hope we'll be able to use Automatic Client Reroute. I believe that was a sufficient solution on another system in the company. It's not clear if I can use ACR with a single db instance, not in an HADR cluster. Anybody know for sure?
Thanks!