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?
- call oracle procedures (e.g. dbms_application_info.set_client_info)
- call set role command
- update some usage data columns
See if a connection validation checker can do the job for you. See org.jboss.jca.adapters.jdbc.spi.ValidConnectionChecker