[CAY-2186] MySQL and Derby PK generators should not commit explicitly

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 02/Jan/17 14:14
• Updated: 20/Feb/17 09:16

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.

Issue Links

• relates to: CAY-2040 Database transactions can be committed prematurely when using Cayenne PK generation