This content has been marked as final.
Show 3 replies
-
1. Re: datasource interceptor?
jaikiran Jul 2, 2011 12:29 AM (in response to herb)herb wrote:
I need to do some sql stuff on the sql connection before the connection is delivered to module
What kind of SQL stuff? Setting connection properties?
-
2. Re: datasource interceptor?
herb Jul 2, 2011 6:33 AM (in response to jaikiran)e.g.
- call oracle procedures (e.g. dbms_application_info.set_client_info)
- call set role command
- update some usage data columns
- ...
-
3. Re: datasource interceptor?
jesper.pedersen Jul 5, 2011 3:22 PM (in response to herb)See if a connection validation checker can do the job for you. See org.jboss.jca.adapters.jdbc.spi.ValidConnectionChecker