I have the unfortunate task of having to deal with a customer that requires the web application I'm building to connect to and interact with the database with the oracle credentials (login/password) the user provides. (due to auditing requirements)

I'm trying to figure out how to benefit from connection pooling but implement this requirement.

So I guess I'm trying to figure out how to use connection pooling (maybe with a generic oracle account), but perform selects/inserts/updates/deletes with user specified credentials, on the fly.

Can hibernate support this, and if so, what section of hibernate documentation can I read up on?

Thanks a lot,
-John

May be you can use SessionFactory.openSession(java.sql.Connection).

You can use the JDBC to get the connection object using the usual DriverManager.getConnection() and then use this connection to open a hibernate session.