Closing database connections and exception handling

From: Andrea Desole (_REMOVE_THIS_desole_at_gmx.net)
Date: 03/31/04

  • Next message: EdUarDo: "Re: Simulating session?" 
    Date: Wed, 31 Mar 2004 09:27:17 +0200

    Hi,

    I just had a discussion with a couple of people concerning how to handle
    exceptions that occur in the close method of connection and statements.
    People usually say: it's an exception in the close method, that means
    you have already done what you had to do, there is really nothing more
    to do with this exception.
    My point is: if it is an exception, and shouldn't occur, it must be
    handled/propagated/notified, because that means that something goes
    wrong. Since the code to do that is not really much, I don't see why I
    can't be safer; you never know why an exception is thrown.
    I'm curious to hear some opinions.

    Thanks

    Andrea

  • Next message: EdUarDo: "Re: Simulating session?"

    Relevant Pages

    • get your potentially resuming element on board my squad
      ... exclusive era. ... require a transmission! ... it eases a contest too positive in connection with her ...
      (sci.crypt)
    • RE: Web.config update to allow remote connection to sql server 200
      ... The line throw an exception is this line: ... I looked at code and it seems hard that to find out what database connection ... Microsoft Online Community Support ...
      (microsoft.public.vsnet.general)
    • Re: SF: Refresher course
      ... All instant diplomatic house substitutes computers ... Hey, I'll decline the german. ... in connection with me it's ... access after Virginia blocks the strict kingdom's exception? ...
      (sci.crypt)
    • Re: Strange sudden shutdown issue with CF app
      ... Phone devices are notoriously low on virtual memory right out of the box because the OEMs decide to put every little thing into its own DLL and then have 25 processes launched at boot. ... Chris Tacke, Embedded MVP ... We have created an app that basically connects to a web service gets data, then stores it locally on the device, and when a record needs to be modified/added the system first tries to connect the web server sees if its availible, if not then it stores in locally on the device until the connection comes back, now I noticed that if the device does not mess around with the data connection then the application sits nicely as long as its open, and never gets shut down. ... But again most of the time I get no exception at all but just simply disappears. ...
      (microsoft.public.dotnet.framework.compactframework)
    • Re: Remobjects, good in multi-threading environment?
      ... for your client-side connection component and have the RTC SDK handle all processing in background threads, while you can still make your calls from the main thread, from a timer or from other threads. ... And any exception causes a very thorough ... Each method cleans up itself thoroughly and re-raises exceptions until ...
      (borland.public.delphi.thirdpartytools.general)