datasource interceptor?

[herb]

I need to do some sql stuff on the sql connection before the connection is delivered to module (this can be a war or ejb module).

Is there a way to implement something like a datasource interceptor in AS 7? Or is there a way to put the datasoure in a datasource wrapper, so that every time getConnection() is called, the getConnection() of the warpper is called, and in the wrapper I can do the sql stuff, befroe the connection is delivered to JPA.

[jaikiran]

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?

[herb]

e.g.

• call oracle procedures (e.g. dbms_application_info.set_client_info)
• call set role command
• update some usage data columns
• ...

[jesper.pedersen]

See if a connection validation checker can do the job for you. See org.jboss.jca.adapters.jdbc.spi.ValidConnectionChecker