Oracle "timeout" problem
Posted on 2007-11-19
I am supporting an n-tiered application. The front end is an Eclipse plug in. The eclipse plug in sends XML messages to a middleware layer that connects to an Oracle database and returns an XML message. At one site, a "timeout" has been set for security reasons. As a result, the middleware is losing connectivity to the database after 30 minutes and subsequent queries fail.
I have been told that the timeout has been set at the database level, but cannot figure out what may have been done exactly.
My goal: to reproduce this timeout error on my own system (I do not have an error message handy, but it was a standard "not connected to oracle" message - will post it if I can get it).