You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When updating to the latest Spring libraries described in #186, the GeneratedValue annotation (defaults to AUTO) no longer uses the IDENTITY strategy on MSSQL Server, but instead defaults to a spring-global sequencer:
select next value for webapi.hibernate_sequence
This is the behavior on PostgreSQL and Oracle, but should be made explicit, and potentially have a dedicated sequencer for each entity. The challenge is creating the DDL for these sequencers that are initialized based on a value from a select max (id) from EntityTable. I'm sure this is possible on MSSQL, but more challenging on oracle.
Alternatively, we can adopt the 'table-based' strategy which is proven to be more cross-platform friendly, tho slow when doing bulk inserts into the identity column (which is not something we do in our current webAPI anyways, so perhaps not a large issue). Further research is required.
The text was updated successfully, but these errors were encountered:
When updating to the latest Spring libraries described in #186, the GeneratedValue annotation (defaults to AUTO) no longer uses the IDENTITY strategy on MSSQL Server, but instead defaults to a spring-global sequencer:
This is the behavior on PostgreSQL and Oracle, but should be made explicit, and potentially have a dedicated sequencer for each entity. The challenge is creating the DDL for these sequencers that are initialized based on a value from a select max (id) from EntityTable. I'm sure this is possible on MSSQL, but more challenging on oracle.
Alternatively, we can adopt the 'table-based' strategy which is proven to be more cross-platform friendly, tho slow when doing bulk inserts into the identity column (which is not something we do in our current webAPI anyways, so perhaps not a large issue). Further research is required.
The text was updated successfully, but these errors were encountered: