Timothy Larson wrote: >Each session needs to be logged into the database with a >different username and password. >
Do you think it's a good idea? >How can I do this using a database pool? > There is no way unless you know SQL command to do it. The hole purpose of a pool is to "connect once", and avoid a lot of costly connects in a run. Vadim >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]>