commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Carman <ja...@carmanconsulting.com>
Subject Re: [dbcp] Re: Oracle session excess over maxActive
Date Thu, 11 Mar 2010 02:17:33 GMT
Have you considered using Spring's JDBC support, or something like it?
 What you need to do is write/use one piece of code that makes sure
you manage your connections, etc. correctly and use that wherever you
want to do JDBC "stuff."

On Wed, Mar 10, 2010 at 12:10 AM, sic <sic_1234@naver.com> wrote:
>
> Yeah, I'll check whether I close PreparedStatements, Statements and ResultSet
> objects properly on my code.
> Then I think I've already use testOnBorrow without stating clearly <property
> name="testOnBorrow" value="true"/> since it's default value is true.
> If it occurs again, I'll monitor the number of opened connections by the
> netstat command, thanks.
>
> And I'm addressing the appropriate configuration in my case.
> I can understand that 5 connections(maxActive(=15) - maxIdle(same as
> minIdle=10)) are destroyed and created continuously.
> So I'm going to set "maxIdle" property to a negative value(or more than
> maxActive value) in order not to destroy connections.
>
> However dropping both of these(e.g. maxIdle = 5, minIdle = 2) as you
> remarked above, it's likely to force the pool to destroy excess connections
> and create them more extremely.
> I wonder what means "dropping both of these" and want to point out my
> misunderstanding.
>
> BTW, I'll observe the DB session states after upgrading to the latest
> version and eliminating the aggressive abandoned connection cleanup,
> checking my closing code.
>
> regards,
> sic
> --
> View this message in context: http://n4.nabble.com/Oracle-session-excess-over-maxActive-tp1584311p1586964.html
> Sent from the Commons - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
> For additional commands, e-mail: user-help@commons.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org


Mime
View raw message