Tuesday, 30 August 2016

[H2] How to check table lock in H2 database

SELECT * FROM INFORMATION_SCHEMA.LOCKS;

SELECT * 
  FROM INFORMATION_SCHEMA.LOCKS
 WHERE TABLE_SCHEMA = '<SCHEMA_NAME>'
   AND TABLE_NAME = '<TABLE_NAME>'
;

No comments:

Post a Comment