Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Name and version of the database you are using:

Oracle 10g

Hi,

We are currently using a Spring and Hibernate environment on top of an Oracle 10g database. 10g has many facilities to automatically filter data based on the database user id. We also want to use triggers that automatically provide audit information based on the database user. Therefore, setting up the database pool with a single user, like is most common with hibernate and spring doesn't work for us.

Is there a best practice or a pattern that is out there for either pooling connections for specific users or changing the user/password on the fly?

We are using the C3PO pooling manager.

Certainly there is the method of getting a configuration, setting the properties and then creating another session factory, but the overhead for that appears to be too large.

Any help on this would be greatly appreciated.

Thanks.