How would we provide the user/password? >>> [EMAIL PROTECTED] 12/22/04 11:56 AM >>> I agree too, but some users don't have a choice.
It's too bad that getConnection(user,pass) isn't a reliable option... I wonder if we should do it anyway for those who have good drivers? Clinton On Wed, 22 Dec 2004 12:33:45 -0600, Vic Cekvenich <[EMAIL PROTECTED]> wrote: > 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> >
