Re: [dbcp] in DBCP 1.4 - Any auto-reconnect property available ?
On 1/15/19 2:59 PM, Matt Sicker wrote: One idea might be to invoke a crafted query for your connection check that fails every so often so it'll be forced to reconnect, though I haven't tried that before. I was thinking the same thing. I am not sure how to do it, but I vaguely recall it being possible to get information about an Oracle session via SQL query. If your validation query could check when the connection was established it could fail if it was too old. Validation failures cause connections to be closed and subsequent borrows will cause new ones to be created. You could set this up using either testOnBorrow or testOnReturn (or both). Of course, the best is to upgrade to DBCP 2 where the connection lifetime property you want is directly available. Phil On Tue, 15 Jan 2019 at 14:39, RAJIV S wrote: Hi Team, In DBCP 1.4 is there any property which can help to disconnect and reconnect DB connection with in some specified time ? Actually , We are using DBCP 1.4 version in our application. It's a standalone Java processor code , developer some years ago, works well till now. Recently we encounter a problem that Oracle SWAM memory grows continuously due to high usage . DBAs suggested to disconnect and reconnect db connection from this java application with some specified time. I am unable to find relevant property or documentation help. Please someone help me if anyone knows how do deal this situation. -- Regards, Rajiv.S - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: [dbcp] in DBCP 1.4 - Any auto-reconnect property available ?
One idea might be to invoke a crafted query for your connection check that fails every so often so it'll be forced to reconnect, though I haven't tried that before. On Tue, 15 Jan 2019 at 14:39, RAJIV S wrote: > > Hi Team, > > > In DBCP 1.4 is there any property which can help to disconnect and > reconnect DB connection with in some specified time ? > > > Actually , We are using DBCP 1.4 version in our application. It's a > standalone Java processor code , developer some years ago, works well till > now. > > Recently we encounter a problem that Oracle SWAM memory grows continuously > due to high usage . DBAs suggested to disconnect and reconnect db > connection from this java application with some specified time. > > I am unable to find relevant property or documentation help. > > Please someone help me if anyone knows how do deal this situation. > -- > Regards, > > Rajiv.S -- Matt Sicker - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
[dbcp] in DBCP 1.4 - Any auto-reconnect property available ?
Hi Team, In DBCP 1.4 is there any property which can help to disconnect and reconnect DB connection with in some specified time ? Actually , We are using DBCP 1.4 version in our application. It's a standalone Java processor code , developer some years ago, works well till now. Recently we encounter a problem that Oracle SWAM memory grows continuously due to high usage . DBAs suggested to disconnect and reconnect db connection from this java application with some specified time. I am unable to find relevant property or documentation help. Please someone help me if anyone knows how do deal this situation. -- Regards, Rajiv.S
[dbcp] in DBCP 1.4 - Any auto-reconnect property available ?
Hi Team, In DBCP 1.4 is there any property which can help to disconnect and reconnect DB connection with in some specified time ? Actually , We are using DBCP 1.4 version in our application. It's a standalone Java processor code , developer some years ago, works well till now. Recently we encounter a problem that Oracle SWAM memory grows continuously due to high usage . DBAs suggested to disconnect and reconnect db connection from this java application with some specified time. I am unable to find relevant property or documentation help. Please someone help me if anyone knows how do deal this situation. -- Regards, Rajiv.S