I would like to make use of "memory optimized table" feature of MSSQL 2016. I do not see how to do this using hibernate.
Microsoft SQL Server
Status? Upgrading from hibernate 3 to 5.4.8.Final results in error:
javax.persistence.TransactionRequiredException: Executing an update/delete query
when trying to create Memory Optimized Table outside of a user transaction.
FYI, trying to create a Memory Optimized Table inside a user transaction results in SQL Server returning this error:
caused by: com.microsoft.sqlserver.jdbc.SQLServerException: DDL statements ALTER, DROP and CREATE inside user transactions are not supported with memory optimized tables.
Found that setting this:
That the error: javax.persistence.TransactionRequiredException: Executing an update/delete query
goes away and the memory optimized table is created.