On Tuesday, August 27, 2002, 5:02:56 PM, Stephen wrote:
JS> Sorry forgot the code. If you are not familiar with AspectJ
JS> http://aspectj.org/servlets/AJSite
JS> AspectJ connection pooling written by Ivan Kiselev consists of 2 aspect
JS> classes
<SNIP>
Hmmmm... There isn't any kind of non-AspectJ code that will solve my
problem? What is that AspectJ provides that something coded in (for
lack of a better word) 'normal' Java?
For a recap to those new to this thread, no matter what kind of
connection pooling I seem to try, I run into problems when
connections are killed by our DBA (who apparently thinks it some
great practice to come in in the morning and kill any open
connections). What happens is when the connections are killed, none
of the pools seem to be able to handle it and errors crop up and a
valid connection is not achieved.
The latest try was using Tomcat's connection pooling and I even
added the queryValidation part which I thought would help:
<parameter>
<name>validationQuery</name>
<value>SELECT 'CRAP' FROM DUAL</value>
</parameter>
...but still this doesn't help either. Tomcat's pooling works fine
unless the connections are manually killed and then it goes to do
it's thing.
I guess I can start tackling this AspectJ ... are you certain,
though, that this will handle the problem effectively?
--
Thanks,
Rick
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
