Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
Received-SPF: pass (hermes.apache.org: domain of bdruth@gmail.com designates
 64.233.184.198 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
        b=VwgRjrgoBqRoy4sdNpc5+o6+2k+Jvlidbl3GOWHRPescwigOj885X/Yz02EBFc/3qQh0ZT28AfAAYVt9P6nvNQVuCm+xV1y6kIqlZAYQYIjPneeQFAG0DVgFWKsuxuQouDbIBC51vXMQYVRGwEMdDxCwyZX0zljx5GGPjR1jo2I=
Message-ID: <bcd06dea050324062052dd1948@mail.gmail.com>
Date: Thu, 24 Mar 2005 08:20:31 -0600
From: Brice Ruth <bdruth@gmail.com>
Reply-To: Brice Ruth <bdruth@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Re: Connection Proxy Authentication
In-Reply-To: <20050324054036.36627.qmail@web51102.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
References: <20050324054036.36627.qmail@web51102.mail.yahoo.com>

My first shot at this (and I may be corrected), is that since iBATIS
uses standard JDBC methods to handle connections & pools, you'll
probably need to either find a wrapper or write a wrapper around the
OCI connection pool that exposes a standard javax.sql.DataSource.

Cheers!
Brice Ruth


On Wed, 23 Mar 2005 21:40:36 -0800 (PST), Temesgen Habtemariam
<temesgen_h@yahoo.com> wrote:
>  
> Hello, 
> 
> I am trying to evaluate if IBATIS will work with a DB security requirements
> on our project. We use Oracle DB and WLS. Our application is required to
> make database user authentication on all queries/updates. The only way we
> can do this and support connection pooling is by using Oracle's
> OracleOCIConnectionPool DataSource. OracleOCIConnectionPool Datasource can
> return a connection proxy that is bound to specific user with something
> like: 
> 
> Connection c = dataSource.getProxyConnection (String proxytype, Properties
> userProp); 
> 
> All our database access has to be through a connection proxy that is bound
> to a specific user with an account in the database. Meaning we can't just
> use getConnection method to get a connection from the datasource. We have to
> use getProxyConnection and pass specific information about the requesting
> user. 
> 
> I am kind of new to IBATIS so before I spend a lot of effort can anyone tell
> me if this is something IBATIS can be configured to handle. 
> 
> Thanks!!
> 
>  ________________________________
> Do you Yahoo!?
>  Yahoo! Small Business - Try our new resources site! 
> 
>