> From: Pid [mailto:p...@pidster.com]
> Subject: Re: How to turn off JNDI datasource connection pooling
>
> I'm getting a little confused trying to follow this thread.

There was a distinct lack of specifics in the beginning.  However, I think I 
understand why he's doing this.  As Keith mentioned, he's using a legacy DB 
that likely implements its own access restrictions based on credentials 
supplied on the connection.  Once the connection is established, the 
credentials cannot be changed.  When a new end-user logs in, that user will 
need a connection specific to that userid.  (How do I know this?  We've got the 
same situation on our mainframes.)

> Keith: you want to use DataSources to define the location
> of the DB via JNDI, but earlier you said you wanted to
> supply authentication credentials on a per user basis.

Those are not incompatible requirements.  The DataSource interface includes a 
getConnection() method that takes a userid and password as arguments.

> When you say 'per user' do you mean 'per client of my business',
> or do you mean actual individual end-users of the application,
> (the former I presume)?

I think the latter; as mentioned above, most mainframe DBs do their own 
authentication and authorization checks.

> I'm also not clear on why you're dead set against using connection
> pooling, would you mind explaining?

He actually said he might try pooling later, but if so, he'll need a pool per 
client userid, not a global one.  (Been there, done that.)

 - Chuck


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY 
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: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to