Subject Show active database connections
Author Chong Yu Meng
Hi All,

I'm using DBCP and Tomcat to connect to a Firebird 1.5 database using
the Jaybird 1.5RC3 driver. I'm writing some documentation now on how
this is done, and I think I've got most of the kinks worked out, except
one : I need a way to verify that Tomcat is creating the database
connections on startup. On MySQL, you can check active connections by
doing a ps -ef. This doesn't seem to be the case on Firebird. When I do
a ps -ef, I always get just one fbguard process and one server process.
For my configuration of DBCP, it should start and maintain at least 5
connections at any one time.

Does anyone know how I can check the number of active connections on
Firebird 1,5 Super Server for Linux?

"Guns aren't lawful; nooses give; gas smells awful. So you might as well
-- Dorothy Parker
| Pascal Chong |
| email: chongym@... |
| |
| Please visit my site at : |
| If you're using my documentation, please read the Terms and |
| and Conditions at |