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
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?


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

	When you do first call DBCP creates minimum number of

	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.






	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


	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}"
	      <property value="${database_user}" name="JDBC.Username"/>
	      <property value="${database_password}" name="
	      <property value="10"
	      <property value="5" name="Pool.MaximumIdleConnections"/>
	      <property value="6000" name=" Pool.MaximumWait"/>
	This is my SQL-map-config like. How do I limit the number of
opened connections?

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

	How many connections are opened by Ibatis to make a simple
	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.


View raw message