ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chen, Tim" <Tim.C...@NielsenMedia.com>
Subject RE: Conections Opened
Date Fri, 11 Aug 2006 14:04:34 GMT
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!

	 



Mime
View raw message