Hi all,
I'm using appfuse with Oracle as backend.
For security reasons and load configuration I need that each user logged in use his database account to query the database.
For the authentication, a generic account is used to query the database. Once the user is logged in, application should switch to use a new datasource configured with his database account.
I implemented this solution using UserCredentialsDataSourceAdapter, it works fine but this solution create an overhead in the backend. In fact, a new physical connection to the database is create for very call.
What I'm looking for is how to maintain the physical connection opened along the web session ? Any reccomandation ?
Ramzi
