On Wed, 7 Mar 2001, Jim Richards wrote:
>
> Has anyone got the database pooling code/DataSource to work or specifically
> had it fail?
>
> I've been having problems (documented previously) and I've read about a few others
> who can't seem to get the pooling to work as well, and I want to get an idea
> of specifically where the problem might lie in order to fix it.
I'm using the database connection pool with Informix Dynamic Server v7.2 and
it appears to be working well. I have noticed that if my network
connection goes down (I pull the plug on the network for a while), I need
to restart Tomcat to reinitialize the connection pool. If I only
momentarily pull the plug, the subsequent query takes longer to run, but
does so successfully.
I admit, I have not looked into the details of all this. But if there is
a way to automate detection of an expired connection and tossing it,
or reinitializing the connection pool (if all the connections are bad),
I'd certainly be interested in having that capability either incorporated
into Struts or available as a patch. Thanks.
