Oracle Weblogic Server crashes with a long running database query
We have a Java application installed on Weblogic 10.3.6. It communicates to an Oracle 11gR2 database. One of the screens in that application runs a database query that processes a lot of data and runs long i.e. for more than 10 minutes.We observe that the page crashes with error 'Failure of server APACHE bridge:', after 5 minutes.
We tried tweaking the timeout in mod_wl_ohs.conf as follows:
< WLIOTimeoutSecs 6000
< Idempotent OFF
The only change that occurred due to this was that the 'Failure of Apache Bridge' error went away, but the page did error out with 'Page not found' error.