Return-Path: 
 <ibatis-user-java-return-2206-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 17197 invoked from network); 9 May 2005 15:47:51 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 9 May 2005 15:47:51 -0000
Received: (qmail 65532 invoked by uid 500); 9 May 2005 15:48:47 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 65463 invoked by uid 500); 9 May 2005 15:48:45 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 65426 invoked by uid 99); 9 May 2005 15:48:45 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=HTML_50_60,HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from smtp2.carreker.com (HELO smtp2.carreker.com) (209.163.213.32)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 09 May 2005 08:48:44 -0700
Received: from DALVIR01.carreker.com (unknown [172.21.1.14])
	by smtp2.carreker.com (Postfix) with SMTP id 04BD0158257
	for <ibatis-user-java@incubator.apache.org>;
 Mon,  9 May 2005 10:45:23 -0500 (CDT)
Received: From DALVIR01R.carreker.com ([127.0.0.1]) by DALVIR01.carreker.com
 (WebShield SMTP v4.5 MR1a);
	id 1115653521880; Mon, 9 May 2005 10:45:21 -0500
Received: from DALEXC03.carreker.com ([172.16.15.1]) by DALVIR01R.carreker.com
 with Microsoft SMTPSVC(5.0.2195.5329);
	 Mon, 9 May 2005 10:45:21 -0500
Received: by dalexc03.carreker.com with Internet Mail Service (5.5.2657.72)
	id <KK12MBVB>; Mon, 9 May 2005 10:45:21 -0500
Message-ID: <745691AF0880C64E8F02CFB140A3872D031896@DALEXC05.carreker.com>
From: "Rafiq, Adnan" <arafiq@carreker.com>
To: "'ibatis-user-java@incubator.apache.org'"
	 <ibatis-user-java@incubator.apache.org>
Subject: RE: Possible Connection Leak
Date: Mon, 9 May 2005 10:45:18 -0500 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2657.72)
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C554AD.E273583F"
X-OriginalArrivalTime: 09 May 2005 15:45:21.0710 (UTC)
 FILETIME=[1BC894E0:01C554AE]
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C554AD.E273583F
Content-Type: text/plain;
	charset="iso-8859-1"

Thanks Clinton.
 
We are using session beans to manage transactions in our application.
Moreover, since we have multiple databases involved we are using XA-
drivers.
 
Will the approach you mentioned still work in this scenario?

-----Original Message-----
From: Clinton Begin [mailto:clinton.begin@gmail.com]
Sent: Saturday, May 07, 2005 9:30 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Possible Connection Leak



Do ALL of your SqlMap calls follow this pattern:

try {
  sqlMap.startTransaction();
  //...do work
  sqlMap.commitTransaction();
} finally {
  sqlMap.endTransaction();
}

Clinton



On 5/6/05, Rafiq, Adnan < arafiq@carreker.com <mailto:arafiq@carreker.com> >
wrote: 

I am using a transaction manager type = JTA in my sql-map-config.xml file.
After running the application for a while, I am getting the following
message in my Weblogic 8.1 console:

<May 6, 2005 5:09:08 PM CDT> <Warning> <Common> <BEA-000620> <Forcibly 
releasing
inactive resource "weblogic.jdbc.common.internal.ConnectionEnv@57bebf" back
into the pool "TP_BOFA_SYS".>

According to BEA, there is a connection leak somewhere. Is it possible that 
iBatis is not properly closing a connection after obtaining it?

Has anyone else come across a similar issue?




------_=_NextPart_001_01C554AD.E273583F
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 6.00.2800.1476" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=664454315-09052005><FONT face=Arial color=#0000ff size=2>Thanks 
Clinton.</FONT></SPAN></DIV>
<DIV><SPAN class=664454315-09052005><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=664454315-09052005><FONT face=Arial color=#0000ff size=2>We are 
using session beans to manage transactions in our application. Moreover, since 
we have multiple databases involved we are using XA- 
drivers.</FONT></SPAN></DIV>
<DIV><SPAN class=664454315-09052005><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=664454315-09052005><FONT face=Arial color=#0000ff size=2>Will 
the approach you mentioned still work in this scenario?</FONT></SPAN></DIV>
<BLOCKQUOTE>
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> Clinton Begin 
  [mailto:clinton.begin@gmail.com]<BR><B>Sent:</B> Saturday, May 07, 2005 9:30 
  PM<BR><B>To:</B> ibatis-user-java@incubator.apache.org<BR><B>Subject:</B> Re: 
  Possible Connection Leak<BR><BR></FONT></DIV><BR>Do <SPAN 
  style="FONT-WEIGHT: bold">ALL </SPAN>of your SqlMap calls follow this 
  pattern:<BR><BR>try {<BR>&nbsp; sqlMap.startTransaction();<BR>&nbsp; //...do 
  work<BR>&nbsp; sqlMap.commitTransaction();<BR>} finally {<BR>&nbsp; 
  sqlMap.endTransaction();<BR>}<BR><BR>Clinton<BR><BR><BR>
  <DIV><SPAN class=gmail_quote>On 5/6/05, <B class=gmail_sendername>Rafiq, 
  Adnan</B> &lt;<A href="mailto:arafiq@carreker.com">arafiq@carreker.com</A>&gt; 
  wrote:</SPAN>
  <BLOCKQUOTE class=gmail_quote 
  style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">I 
    am using a transaction manager type = JTA in my sql-map-config.xml 
    file.<BR>After running the application for a while, I am getting the 
    following<BR>message in my Weblogic 8.1 console:<BR><BR>&lt;May 6, 2005 
    5:09:08 PM CDT&gt; &lt;Warning&gt; &lt;Common&gt; &lt;BEA-000620&gt; 
    &lt;Forcibly <BR>releasing<BR>inactive resource 
    "weblogic.jdbc.common.internal.ConnectionEnv@57bebf" back<BR>into the pool 
    "TP_BOFA_SYS".&gt;<BR><BR>According to BEA, there is a connection leak 
    somewhere. Is it possible that <BR>iBatis is not properly closing a 
    connection after obtaining it?<BR><BR>Has anyone else come across a similar 
    issue?<BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C554AD.E273583F--