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

Client should disallow XAConnection getConnection() when a global transaction has been started and a logical connection has already been obtained

Agile BoardAttach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.1.1.0
    • None
    • JDBC
    • Normal

    Description

      If a logical connection has already been obtained, client should disallow XAConnection getConnection if a global transaction has been started and a logical connection has already been obtained

      Repro:

      With the client the script below does not give an error.

      ij> connect 'wombat;create=true';
      ij> disconnect;
      ij> xa_datasource 'wombat';
      ij> xa_connect user 'APP' password 'xxx';
      Connection number: 3.
      ij> – start new transaction
      xa_start xa_noflags 0;
      ij> xa_getconnection;
      ij> – Should not be able to get connection again
      xa_getconnection;

      With embedded we get.
      ERROR XJ059: Cannot close a connection while a global transaction is still active.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            kmarsden Katherine Marsden

            Dates

              Created:
              Updated:

              Slack

                Issue deployment