Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-2186

MySQL and Derby PK generators should not commit explicitly

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

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      MySQL and Derby PK generators explicitly commit the connection when they get a new PK. This goes against Cayenne strategy for external transaction management (do not commit from inside Cayenne, let the transaction manager commit when needed).

      Haven't tested the behavior with a real tx manager, but without one (and with external transactions) these 2 PK generators add a side effect of committing whatever else was uncommitted on the connection in question.

      Attachments

        Issue Links

        Activity

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

          People

            andrus Andrus Adamchik
            andrus Andrus Adamchik

            Dates

              Created:
              Updated:

              Slack

                Issue deployment