RE: iBatis DAO - How to turn off data connection pool

[Folashade Adeyosoye]

Thanks for your response, I have actually been battling this for a while, this is my situation.   I currently have a system that works, but with embedded SQL in my classes, and the classes and implementation are well separated using interfaces and implementation classes. (   Action classes à API calls that delegates à    JDBC implementation classes) I am trying to swap out my written DAO pattern with the iBatis DAO Add an alternative SQLMAP implementation and also keep around my old embedded SQL JDBC classes The JDBC classes do not use JNDI to lookup the database connections, I have a DatabaseConnection Manager class that creates a pool of up to 20 connections and manages them Right now I just need the DAO part to work with out using the SQLMAP portion, this is a future task to do.   And I would like to basically use the dao.xml to switch between both implementations.   Thanks   From: Clinton Begin [mailto:[EMAIL PROTECTED] Sent: Monday, May 16, 2005 4:03 PM To: ibatis-user-java@incubator.apache.org Subject: Re: iBatis DAO - How to turn off data connection pool   What are you trying to achieve by doing that?  You can't really "turn off" pooling with SimpleDataSource, but you could try one of the other implementations or write your own to achieve that.  Cheers, Clinton On 5/16/05, Folashade Adeyosoye <[EMAIL PROTECTED]> wrote: How can I turn off the Database connection pool in the dao.xml        <transactionManager type="JDBC">       <property name="DataSource" value="SIMPLE"/>       <property name="JDBC.Driver" value="${driver}"/>       <property name="JDBC.ConnectionURL" value="${url}"/>       <property name="JDBC.Username" value="${username}"/>       <property name="JDBC.Password" value="${password}"/>       <property name="JDBC.DefaultAutoCommit" value="true"/>       <property name="Pool.MaximumActiveConnections" value="10"/>       <property name="Pool.MaximumIdleConnections" value="5"/>       <property name="Pool.MaximumCheckoutTime" value="120000"/>     </transactionManager>       I tried changing the       <property name="Pool.MaximumActiveConnections" value="0"/> and   <property name="Pool.MaximumIdleConnections" value="0"/>, but I got an exception     exception is thrown - java.lang.IndexOutOfBoundsException: Index: 0, Size: 0     Thanks