Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-694

Statement exceptions cause all the connection's result sets to be closed with the client driver

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.1.2.1
    • 10.2.1.6
    • Network Client
    • None

    Description

      Scenario:

      Autocommit off. Have two prepared statements, calling executeQuery() on both, giving me two result sets. Can fetch data from both with next(). If one statement gets an exception (say, caused by a division by zero), not only this statement's result set is closed, but also the other open resultset. This happens with the client driver, whereas in embedded mode, the other result set is unaffected by the exception in the first result set (as it should be).

      Attachments

        1. DERBY-694_upload_v1.diff
          13 kB
          V.Narayanan
        2. DERBY-694_upload_v1.stat
          0.6 kB
          V.Narayanan
        3. DERBY-694_v2.diff
          13 kB
          V.Narayanan
        4. DERBY-694_v2.stat
          0.7 kB
          V.Narayanan
        5. DERBY-694_v3.diff
          14 kB
        6. DERBY-694_v3.stat
          0.7 kB
        7. DERBY-694_v4.diff
          14 kB
          V.Narayanan
        8. DERBY-694_v4.stat
          0.7 kB
          V.Narayanan
        9. DERBY-694_v5.diff
          19 kB
          V.Narayanan
        10. DERBY-694_v5.stat
          0.9 kB
          V.Narayanan
        11. DERBY-694_v6.diff
          20 kB
          V.Narayanan
        12. DERBY-694_v6.stat
          1.0 kB
          V.Narayanan
        13. DERBY-694.html
          5 kB
          V.Narayanan
        14. StatementRollbackTest.java
          4 kB
          Oyvind Bakksjo

        Issue Links

          is part of

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-310 Document and/or change Derby client code to match behavior with Embedded driver where possible.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              narayanan V.Narayanan
              bakksjo Oyvind Bakksjo
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: