Clever Geek Handbook

List of active Apache Derby connections

Can Apache Derby be queried for a list of current connections / active sessions? Any system tables, etc.?

+2


source to share


1 answer


SYSCS_DIAG tables will allow you to get a list of active transactions, but they are not the same as a list of connections or sessions.

You can get close to what you want by using JMX beans to access the webserver. There are several docs here: http://wiki.apache.org/db-derby/DerbyJMXQuickStart



If the current JMX beans don't give you everything you need, you can improve them to provide more information.

+2


source






More articles:


All Articles