How do I look at the JDBC connection pool after JBoss has started up to see that the connections have been allocated and stored? What sort of java object are the Oracle connections stored in? and where do I find it so I can look at it at runtime?
I did not see anything through the web console that would let me take a peek.
I put a log4j appender to print everything out when JBoss starts up but did not see any messages about allocating connections to Oracle. I assume that when JBoss starts up it gets the min setting of connections to the database.
I realize Hibernate has it's own connection pool but want to point Hibernate to use the JBoss database connection pool if possible but want to check things out and see that the right amount of connections have been allocated and monitor getting a connection and returning it to the pool.
Use jmx-console and look at the mbean named jboss.jca:service=ManagedConnectionPool,name=XXX where XXX is the JNDI name of your data source.