I'm facing a problem with the Apache/Tomcat/JDBC/Oracle communication configuration of an application.
Here are all the informations I have at my disposal about the problem :
- A button on the web-app lauches a SQL/Oracle procedure that takes about 5 to 10 minutes to come to an end successfully.
- The application is deployed on two distinct environnements. The Apache/Tomcat server configurations appear to be the same. The physical architecture, instead, is different (memory ressources, etc.)
- On one environnement, when this procedure is lauched, it always aborts after around 5 minutes with an ERROR 503 : "Service Unavailable".
I know there is not a lot of details, but do you have any idea of the reason why such an error occur ?