Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Philippines
    Posts
    1

    Red face Unanswered: How to handle If I Get Disconnected?

    For example, when the database goes down or my connection or link to the database server goes down while an application is running, how can I handle that gracefully or how will I know that the database is down or I'm no longer connected to oracle so that I could prompt something for the user for them to know that a problem occured on the application(currently the application just hangs when oracle is down)?
    I would likely appreciate any suggestions that would come from you guys!
    Thank you very much!

  2. #2
    Join Date
    Aug 2003
    Posts
    1
    This is an interesting question. In one of my projects, i handle this issue using a timer object (VB) that is periodically generating a short SQL statement. If execution fails (Error handling with 'on error goto ...'), the user is getting informed that the application now is in offline state. While the application is 'offline', the mentioned timer tries periodically to reconnect to the db. Every Oracle statement is protected by a error handling, so a unwanted runtime error can't occur. I'm not sure if this is really the best way to handle this, but it works for us.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •