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

Incorrect SQLState used in EmbedConnection.java.close() when there is an active transaction

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: JDBC
    • Labels:
      None

      Description

      Currently in EmbedConnection.close(), if there is an active transaction a SQLException is thrown with SQLState.LANG_INVALID_TRANSACTION_STATE, or "25000". But looking at the SQL 2003 specification, the correct SQL State should be "25001" - "Active SQL-Transaction" (see section 17.3 - disconnect statement, under General Rules: "If any SQL-connection in L is active, then an exception condition is raised: invalid transaction state ?
      active SQL-transaction.")

      Although the stability classification for SQL States is currently under debate, for now we must assume that, although incorrect, this SQL State cannot be changed until the next major release.

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              davidvc David Van Couvering

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment