1) have you closed your connections in a finally block? opening a new connection for each call is sever.. it *should* be getting some connections from the pool.
2) have you tried playing with maxRequests in <settings>?
3) how many connections before the error msg? (have a dba check for you if you aren't sure) is it possible that you just have the limit set too high?
4) if all else fails use a JNDI connection and setup the connection pool within your container.


From: Renato Silveira [mailto:renatosilveira@gmail.com]
Sent: Friday, August 11, 2006 9:52 AM
To: user-java@ibatis.apache.org
Subject: Re: Conections Opened

I still have this problem. Every single call I made a new connection is opened. The DaoManager is started just one time. And the connection remain opened for a  long time until oracle returns a error of max number of connections opened.

Any ideas to solve this problem?

tks!




On 8/11/06, Mkhitaryan, Aram <Aram.Mkhitaryan@lycos-europe.com > wrote:

When you do first call DBCP creates minimum number of connections

and uses these connections until all connections are busy(active/running) and new connection is created.

 

If you compare first call and second, the first one should take much time then second one.

 

But if "every call I do a new connection is created" that only can mean that your calls are too fast and DBCP

can't create connections automatically and creates during call.

 

Best,

Aram

 


From: Renato Silveira [mailto:renatosilveira@gmail.com]
Sent: Friday, August 11, 2006 3:45 AM
To: user-java@ibatis.apache.org
Subject: Re: Conections Opened

 

Hi,

I have configured the maxActive connection with 10 but every call I do a new connection is created.

 <transactionManager type="JDBC">
    <dataSource type="DBCP">
      <property value="${database_driver}" name=" JDBC.Driver"/>
      <property value="${database_url}" name="JDBC.ConnectionURL"/>
      <property value="${database_user}" name="JDBC.Username"/>
      <property value="${database_password}" name=" JDBC.Password"/>
      <property value="10" name="Pool.MaximumActiveConnections"/>
      <property value="5" name="Pool.MaximumIdleConnections"/>
      <property value="6000" name=" Pool.MaximumWait"/>
    </dataSource>
  </transactionManager>

This is my SQL-map-config like. How do I limit the number of opened connections?

tks!

On 8/10/06, Renato Silveira <renatosilveira@gmail.com> wrote:

Hi,

How many connections are opened by Ibatis to make a simple query?

In my sql-map-config, using SimpleDataSource (pool), the maxnumber of connection are like this:
<property value="1" name=" Pool.MaximumActiveConnections"/>
<property value="1" name="Pool.MaximumIdleConnections"/>
But Ibatis open 4 connections at least.

Cheers!