Found that setting this:
<prop key="hibernate.allow_update_outside_transaction">true</prop>
That the error: javax.persistence.TransactionRequiredException: Executing an update/delete query
goes away and the memory optimized table is created.