Each session needs to be logged into the database with a different username and password. How can I do this using a database pool?
Tim >>>> [EMAIL PROTECTED] 09/26/02 04:33PM >>> >Timothy Larson wrote: > >>I need to create a database connection, >Why not: >1. Get connection from the pool, >2. >>do some security checks, >3. >>set a user role >And then, >>run queries against the database. >Using ESQL+XSP or SQL transformer. >PS It's really bad idea to create connection per request. > >Vadim > >>I made an action to do all of the setup, but I do not know how >>to make xsp/esql or xsl/sql use the established connection. >> >>Any ideas how to make esql or sql use a previously created >>database connection? Unless there is a trick, I do not think >>I can use connection pools for this, because the security >>checks and role setting has to be done per user. >> >>If I find a solution, I will share it with the list. >> >>Tim --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
