cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Timothy Larson" <>
Subject Re: How to create db conn in action to use in esql or sql?
Date Fri, 27 Sep 2002 12:33:22 GMT
Each session needs to be logged into the database with a
different username and password.
How can I do this using a database pool?


>>>> 09/26/02 04:33PM >>>
>Timothy Larson wrote:
>>I need to create a database connection,
>Why not:
>1. Get connection from the pool,
>>do some security checks,
>>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.
>>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.

Please check that your question  has not already been answered in the
FAQ before posting.     <>

To unsubscribe, e-mail:     <>
For additional commands, e-mail:   <>

View raw message