We could support DataSource.getConnection(username,password), but I
wonder how many datasources actually implement that properly? For
example:
sqlMapClient.setAuthentication(username, password);
or maybe...
sqlMapClient.openSession (username, password);
Remember though, I'd wonder how many datasources actually implement
the getConnection(user,pass) properly....
Thoughts?
Clinton
On Tue, 21 Dec 2004 10:56:05 -0700, Larry Meadors
<[EMAIL PROTECTED]> wrote:
> This can be done, and being the guy who wrote the code to do, I would
> *strongly* advocate *not* doing it.
>
> Essentially, you need to set up a connection pool per user. There is a
> package to do it in CVS using proxool, but it is not supported.
>
> Larry
>
> >>> [EMAIL PROTECTED] 12/21/04 8:09 AM >>>
> Yes, there is a previous example of how to do this, I believe it is on
> the old SourceForge forum, if I'm not mistaken. I'll go search for the
> link to the particular thread if I can find it.
>
> On Tue, 21 Dec 2004 08:58:18 -0600, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> >
> > I'm using the ibatis DAO framework and SQLMapping to develop a web
> > application and it is working great. I used Hibernate on the last
> project,
> > but the client insisted on having more control over the SQL.
> SQLMapping
> > takes care of that. Now the DBA is insisting that each user
> authenticate
> > with their own Oracle ID and password. Can I pass in the connection
> > credentials at run time rather than use what is in the config file?
> >
>
>
