ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Folashade Adeyosoye" <sharda...@gmail.com>
Subject RE: iBatis DAO - How to turn off data connection pool
Date Tue, 17 May 2005 14:53:45 GMT
Thanks for your response, I have actually been battling this for a while,
this is my situation.


1.	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)
2.	I am trying to swap out my written DAO pattern with the iBatis DAO
3.	Add an alternative SQLMAP implementation and also keep around my old
embedded SQL JDBC classes
4.	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
5.	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





From: Clinton Begin [mailto:clinton.begin@gmail.com] 
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.  


On 5/16/05, Folashade Adeyosoye <shardayyy@gmail.com> 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"/>





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





View raw message