ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brent Ryan" <br...@blackboard.com>
Subject RE: Oracle DB using a wireless connection causes connection leaks
Date Fri, 28 Apr 2006 23:29:32 GMT
This is using these configs:
   <transactionManager type="JDBC">
     <dataSource type="DBCP">
        <property name="JDBC.Driver" value="${driver}"/>
        <property name="JDBC.ConnectionURL" value="${url}"/>
        <property name="JDBC.Username" value="${username}"/>
        <property name="JDBC.Password" value="${password}"/>
        <property name="Pool.MaximumActiveConnections" value="100"/>
        <property name="Pool.MaximumIdleConnections" value="5"/>
        <property name="Pool.MaximumWait" value="60000"/>
        <property name="Pool.LogAbandoned" value="false"/>
        <property name="Pool.RemoveAbandoned" value="false"/>
        <property name="Pool.RemoveAbandonedTimeout" value="50000"/>
There are multiple connections established even after the application
has been stopped completely.  This problem only occurs when on a
wireless connection.  I'm on a windows machine connecting to Oracle 9i
on Redhat linux 3 server.  I can't explain why this happens, but it
 From: Eric T. Blue [mailto:ericblue76@gmail.com] 
Sent: Friday, April 28, 2006 2:44 PM
To: user-java@ibatis.apache.org
Cc: lmeadors@apache.org
Subject: Re: Oracle DB using a wireless connection causes connection


TCP connection/state behavior should not vary depending on your physical
connection type (802.3 vs 802.11).  Plus I don't think a different
driver should matter.  A given connection should go into TIME_WAIT and
CLOSE immediately following a JDBC connection close(). Are you using a
connection pool, or is your data source configured as SIMPLE?    Do you
see a single connection in ESTABLISHED state (to remote port 1521), or
multiple connections.  If you're killing the client application and you
still see the TCP state as ESTABLISHED, then this is indeed a strange
problem.  If you're on Windows and you want to find out what thread or
application owns a given TCP connection you should check out some of the
tools from sysinternals ( http://www.sysinternals.com/).




Process Explorer

On 4/28/06, Brent Ryan <bryan@blackboard.com> wrote: 

	When I'm plugged into the network I don't have this problem.  I
	have this problem when I'm on wireless.  I don't think this is a
	issue either.  I think it has something to do with the oracle
	because I've run into something similar with straight JDBC calls
	I thought I read a while back that there was a different JDBC
	driver you should use instead of the THIN driver if using
	But maybe I'm just blowing smoke too.. Who knows?
	-----Original Message-----
	From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com]
On Behalf
	Of Larry Meadors
	Sent: Friday, April 28, 2006 9:15 AM
	To: user-java@ibatis.apache.org
	Subject: Re: Oracle DB using a wireless connection causes
	I did a search for "if(isWireless()) leakConnection();" and
didn't find 
	anythingso if you unplug your toaster, and put the dog out - I
bet it
	fixes it. ;-)
	Just kidding..I do not see any way that this could be iBATIS
related -
	it is even hard to imagine that a bad jdbc driver would do that.
Are you 
	absolutely positive that it happens when plugged in, too?
	On 4/28/06, Brent Ryan <bryan@blackboard.com> wrote:
	> I had a project I was developing on using iBatis and Oracle
where I 
	> ran into this issue.  The only reason I was using wireless was
	> I was on my laptop and I noticed that when you called
	> dao.endTransaction() that my connection stayed in the
	> state even after killing the program completely.
	> Has anyone else had these issues with wirelss?  And is there a
way to
	> avoid this?  Like a different JDBC oracle driver...
	> Thanks, 
	> Brent
	> This e-mail is intended only for the personal and confidential
use of
	> the
	> recipient(s) named above.
	> It may include Blackboard confidential and proprietary
	> and is not for redistribution.

View raw message