ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Oracle Tomcat Connection Problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Oracle Tomcat Connection Problem

    Dear all,

    We have Oracle as the back end and Java-Jsp-Struts as the front end for our project.For the last few days we are facing a strange problem and although we tried a lot we were not able to find even the cause of the problem
    We have Oracle server and Webserver running on seperate machine. As this is a webbased solution , clients can take the pages by putting the URL in the browser. The problem is that the connection to the database is lost sometimes and we need to restart our apache tomcat service to get the connection again. Once it is restarted the pages work fine for sometime and after sometime the problem comes again. Sometimes the problem occures frequently and sometimes rarely.

    Please help us as we tried a lot to troubleshoot but failed.

    Whenever we are loosing connection, the database or listener seem to have no problem as they are running perfectly fine. Is there something that should be done in Tomcat for oracle connections? Or if multiple users are accessing the database at the same time is there something to do sothat the webserver is able to handle these multiple connections and update operations?

    The error messages that we get are:

    The network adapter could not establish the connection

    or The TNS Listener could not resolve the SID given in the connection descriptor

    If the error is the second one then sometimes it will vanish after sometime even without restarting thr tomcat service . But for the first one we must restart the service


    All suggessions are welcome.

    Regards,
    Meera.

  • #2
    Re: Oracle Tomcat Connection Problem

    Meera, sorry sir but your in the wrong forum. No Oracle here just the ISeries.
    Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

    Comment

    Working...
    X