ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vic Cekvenich <...@friendvu.com>
Subject Re: Connecting using User's Credentials
Date Wed, 22 Dec 2004 18:33:45 GMT
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
><Larry.Meadors@plumcreek.com> 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
>>
>>    
>>
>>>>>bdruth@gmail.com 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, stevem@teamics.com
>><stevem@teamics.com> 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>

Mime
View raw message