Database pooling works pretty well for me. But there are some pitfalls, when a
connection times out or the database server is restarted. As the framework does
not check if a connection is still valid before returning it to the application
you will run into an exception when trying to use a connection which has timed
out or was closed due to some other reason on the server side.
I know there was some discussion going on about this on the list in the past.
There were some pros and cons about whether the framework should check the
validity of a connection before returning it to the application. I patched the
struts code in order to do this check and always return a valid connection
(requires the jdbc driver Connection.isClosed() method to work correctly - some
have a bug in their implementation). If you are interested in this little patch,
please let me know.
--- Matthias
I patched
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.
>
> ----
> You are the simulacrum of my dreams
> and the signifier of my desires
>
> Mr Grumpy ... come and visit his home!
> http://www.cyber4.org/members/grumpy/index.html
