I sent you the classes. Just download the compiler, install, compile and test it. You will know right away. They have support, just email them if you have any problems.
-----Original Message----- From: Rick Reumann [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 5:18 PM To: Jackson, Stephen Cc: 'Struts Users Mailing List' Subject: Re[2]: [OT] conn pooling - what next? 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

