[CAY-1982] Mismatched Sequence Cache for Database Sequence Generated Keys

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 3.1
• Fix Version/s: 4.0.M2
• Component/s: Core Library
• Assignee: Unassigned
• Reporter: Andrew Ponsonby Lindesay
• Created: 23/Dec/14 05:34
• Updated: 23/Dec/14 07:32
• Resolved: 23/Dec/14 07:32

Description

I've seen this myself, but it was also raised on the mailing list today. The system has a sequence with an "increment_by" value of 1. This generates an increment of 1 for each query to get the next value.

Cayenne on the other hand has a default cache of 20 defined at JdbcPkGenerator#DEFAULT_PK_CACHE_SIZE. This creates a problem because Cayenne assigns PK's 1..20 for its use, but the sequence is only incremented by 1 in the database.

Maybe look at generating corrected DDL or defaulting to a cache of 1 for the case where primary keys are being database generated.