Listing Apache Derby Active Connections

Question

Is it possible to query apache derby for a list of current connections/active sessions? Any system tables etc?

thanks,

Phillip

Answer 1

The SYSCS_DIAG tables will let you get a list of the active transactions, but that's not the same as the list of connections or sessions.

You can get somewhat close to what you want by using the JMX beans to access the Network Server. There's some docs here: http://wiki.apache.org/db-derby/DerbyJMXQuickStart

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