cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vadim Gritsenko <>
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,

>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