Return-Path: Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 5489 invoked by uid 99); 22 Dec 2004 15:49:10 -0000 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=FORGED_RCVD_HELO X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.plumcreek.com (HELO cfo-msg.plumcreek.net) (208.4.182.150) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 22 Dec 2004 07:49:07 -0800 Received: from plumcreek-MTA by cfo-msg.plumcreek.net with Novell_GroupWise; Wed, 22 Dec 2004 08:48:59 -0700 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.2 Date: Wed, 22 Dec 2004 08:48:52 -0700 From: "Larry Meadors" To: , Subject: Re: Connecting using User's Credentials Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Checked: Checked I have never seen one that does that as I expected it to. >>> clinton.begin@gmail.com 12/22/04 8:24 AM >>> 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 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 > 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? > > > >