Uploaded image for project: 'IronJacamar'
  1. IronJacamar
  2. JBJCA-1321

Statement.cancel() is not invoked until the statement is completed

    XMLWordPrintable

Details

    Description

      Hi,

      in our application we are using the Statement.cancel() method to stop long-running queries; in Wildfly 9.0.2 this is not working because the cancel() method is synchronized using a lock which is not released until the query is executed. In WrappedStatement:

      public void cancel() throws SQLException
    {
      if (doLocking)
          lock();
       try
       {
        /* ... */

      It seems this behaviour has changed from version 1.2.5.Final of ironjacamar-jdbc; in version 1.2.4.Final WrappedStatement.cancel doesn't try to obtain the lock.
      Probably I'm missing something, but to me it's strange that in order to cancel a statement you have to wait for its completion.

      Thank you,

      lorenzo

      Attachments

        Issue Links

          is incorporated by

          Bug - A problem that impairs or prevents the functions of the product. JBEAP-5084 Statement.cancel() is not invoked until the statement is completed

          • Critical - To be worked on immediately following BLOCKER issues.
          • Verified

          Bug - A problem that impairs or prevents the functions of the product. JBEAP-6593 (7.0.z) JBJCA-1321 - Statement.cancel() is not invoked until the statement is completed

          • Critical - To be worked on immediately following BLOCKER issues.
          • Verified

          Component Upgrade - A task tracking an update to a bundled component or revision of component upstream of the project. WFLY-8258 Upgrade to IronJacamar 1.3.6

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              rhn-engineering-lgao Lin Gao
              lorenzo.benvenuti lorenzo benvenuti (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: