> [mailto:[EMAIL PROTECTED] 
> Subject: using a datasource connection pool resource with 
> username and password supplied by user
> But what I really want to do is to get a database user and 
> password from the user and (after validating it) write this 
> to a session cookie.  Then when the user interacts with the 
> database (which is all the time) the username and password 
> will be extracted from the cookie and used in the following
> way:

I don't think you can do this with a connection pool.  The connections
in the pool are opened once only, and persist for the life of the
application, not the session.  Any user (session) can end up using any
of the connections, which is why you have to configure the credentials
with the ressource.  I think if you want to authenticate on each
session, you'll have to dispense with the pool and suffer the overhead
of opening a DB connection each time.

Perhaps someone else has a better idea...

 - Chuck

MATERIAL and is thus for use only by the intended recipient. If you
received this in error, please contact the sender and delete the e-mail
and its attachments from all computers.

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to