Hello,
Is there a clean way of affecting the prepared statement creation behaviour on save or update?
Background:
I'm using a WLS datasource and connection pool. I need to use a oracle.sql.STRUCT in a UserType and the WLS docs says that creating STRUCTS is "not supported" unless you get the underlying vendor connection using a getVendorConnection() call.
If I get the underlying vendor connection I get a penalty ("dirty" connections can't be returned to the pool), so I want to be a little bit smart about when I do this.

pseudo code:
if MyUserType.isdirty() then create PreparedStatement by using getVendorConnection() kind of thing...

I'm using a closed sourced library so there is no way coding around the oracle.sql.STRUCT :(.

Any ideas? Can events/interceptors be used or are they called too early/late?

Regards,
Johan