You posted the answer yourself Yes, <connection-listener> is the element you want.
Great! Can you clarify if the listener will execute in a separate classloader (separate from my WAR classloader)? And can it access thread locals perhaps that I set in my webapp?
It is executed in the thread getting the connection. You should use configuration properties to configure the listener.
See a simple test case in the IronJacamar code @ adapters/src/test/java/org/jboss/jca/adapters/jdbc/spi/ConnectionListenerTestCase.java on the 1.1 branch.
Thanks , that helps !