HSQL - identify number of open connection

问题:

I'm using embedded HSQL database server. Is there any way to identify number of open connection alive?

回答1:

Yes.

SELECT COUNT(*) FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS