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]>
