We’ve had a lot of success using the ARP JDBC plugin framework.
We’d like to be able to make pre/post SQL calls whenever a connection is retrieved/returned to the connection pool; if we had to override
JdbcConf.newPlugin and provide an extended version of
JdbcStoragePlugin that would be fine. We’d also like to have access to the querying user at this scope, so we could set session parameters on the database. These querying user details are outside the scope of dataset security, that we could achieve with
In practice I think this would mean
JdbcRecordReader would need the username, and during
setup it could pass us a copy along with the
connection object already pulled from the pool, and again on
close for cleanup.