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 <[EMAIL PROTECTED]> 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! > >
