This content has been marked as final.
Show 4 replies
-
1. Re: How to execute a stored procedure when getting a connection from datasource
jesper.pedersen Nov 19, 2013 11:57 PM (in response to raylite3)You posted the answer yourself Yes, <connection-listener> is the element you want.
-
2. Re: How to execute a stored procedure when getting a connection from datasource
raylite3 Nov 20, 2013 1:34 PM (in response to jesper.pedersen)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?
Thanks!
-
3. Re: How to execute a stored procedure when getting a connection from datasource
jesper.pedersen Nov 21, 2013 1:35 AM (in response to raylite3)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.
HTH
-
4. Re: How to execute a stored procedure when getting a connection from datasource
raylite3 Nov 21, 2013 2:44 AM (in response to jesper.pedersen)Thanks , that helps !