named parameter bind only works on the where clause. what if you want different schema at runtime for the table part. such as
'select * from :tablename where ...'
'update :tablename set ..."
You will find the above won't work in your @Query annotation
You can get the single result, the first result, result lists or result stream.
use executeUpdate to update or delete records in the table
Not allowed to create transaction on shared EntityManager
Caused by: java.lang.IllegalStateException: Not allowed to create transaction on shared EntityManager - use Spring transactions or EJB CMT instead
Please call joinTransaction before execute update sql