This is a follow-up message, for the record.
Following Antonio Fiol's kind prompting, I added the following Commons-DBCP
elements to the DataSource resource parameters specified in my application's
context fragment:
validationQuery -- select 'x' from dual
testWhileIdle -- true
Hi Harry,
I'm going to try and hijack this thread if I may (!) because, as you say...
Welcome! ;-)
[...] The other Tomcat server runs on a Red Hat 9 machine at my home. It connects
to the above Oracle DB box - far away - using the same static IP address.
[...] The problem is with the the DB
Thank you Antonio (!)
Your suggestions sound very plausible - I shall look into them and I promise
to post a follow up (for the record) in due course, though it might take me
a couple of days.
Many thanks indeed, and kind regards
Harry Mantheakis
London, UK
Hi Harry,
I'm going to try
