Configuration:
- Tomcat (1) 5.0.27 in dmz
- Tomcat (2) 5.0.27 inside domain
- Using JayBird DB Driver
- IIS 6
- Interbase 7.5 DB server inside domain
Tomcat (1) is currently having some serious issues with pooled
connections to the db server. These applicaitons have been running for
years and now all of a sudden there is a problem. Nothing has change on
any servers. Tomcat(2) is setup exactly like Tomcat(1) except it is not
configured to work with IIS 6...it's standalone. Tomcat(2) does not
exibit this problem.
The problem is this: my initial connection will work without any
problems. If I wait about an hour the connection to the database seems
to be null but the connection instance I have is not. It's not until I
attempt to get another new connection that the call will go through.
What I've tried:
1. Modifying pool parameters
2. Changing db driver
3. Testing if the connection is null before I use it.
Any help would be greatly appreciated.
Thanks in advance.
