My application is using an Oracle datasource, which is defined in configuration file which I name oracle-ds.xml which I drop into JBoss.
I give it the JNDI name: <jndi-name>jdbc/OracleDSLocal</jndi-name> which my application then looks up.
I wondering though, is there any way I can information on
1. Is a connection pool being used?
2. When a connection is actually in use?
Webshpere has an application called Tivoli where I can get this info, just wondering does JBoss have anything similar.
Have a look at the jmx-console. Access jmx-console at http://localhost:8080/jmx-console. On this page under jboss.jca, you will find a link like name=myDS,service=ManagedConnectionPool (where myDS is the jndi-name of your datasource). Click on this link and you will be forwarded to a page which will have the connection count and other details about this connection pool.