cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Timothy Larson" <Tdlar...@ci.canton.oh.us>
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?

Tim

>>>> vadim.gritsenko@verizon.net 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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message