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 Thu, 26 Sep 2002 20:33:33 GMT
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