cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vadim Gritsenko <vadim.gritse...@verizon.net>
Subject Re: How to create db conn in action to use in esql or sql?
Date Fri, 27 Sep 2002 12:34:15 GMT
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
>
>  
>
>>>>>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