I agree w/ Lary, this is a bad idea.
.V


Clinton Begin wrote:

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?











--
RiA-SoA w/JDNC <http://www.SandraSF.com> forums
- help develop a coomunity
My blog <http://www.sandrasf.com/adminBlog>

Reply via email to