Recovery from Network error

From: Vassilis Raxenidis (raxe..orthnet.gr)
Date: Wed Feb 11 2004 - 09:27:45 EST

  • Next message: Andrus Adamchik: "Re: Recovery from Network error"

    Hi,

    I use cayenne together with Sybase.
    If the network goes down while trying to execute a query (for example by
    calling performIteratedQuery of DataContext)
    then the following exception is thrown:
    org.objectstyle.cayenne.CayenneException: [v.1.0.2 October 27 2003] Error
    getting ResultIterator: Global Exception:
    java.sql.SQLException: Can't obtain connection. Request timed out.
    So far so good as the databse server can't be reached due to network
    connection problem.
    But when the network connection to database server is recovered any
    subsequent call of performIteratedQuery method on the same
    DataContext instance keeps on throwing the same exception. Is that logical?
    Is there any recovery actions that have to be taken on the DataContext
    object after a network connectivity problem is detected?
    Thanks in advance.

    Vassilis Raxenidis

    This archive was generated by hypermail 2.0.0 : Wed Feb 11 2004 - 09:27:50 EST