Return-Path: 
 <ibatis-user-java-return-2210-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 89642 invoked from network); 9 May 2005 18:26:15 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 9 May 2005 18:26:15 -0000
Received: (qmail 59966 invoked by uid 500); 9 May 2005 18:28:58 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 59931 invoked by uid 500); 9 May 2005 18:28:57 -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 59863 invoked by uid 99); 9 May 2005 18:28:56 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from mail.plateau.com (HELO newmail.plateau.com) (63.105.186.130)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 09 May 2005 11:28:55 -0700
Received: by newmail.plateau.com with Internet Mail Service (5.5.2653.19)
	id <KNFNQ6LD>; Mon, 9 May 2005 14:24:10 -0400
Message-ID: <53C527E2212BC849B14091DACFA944C86039AB@newmail.plateau.com>
From: Ming Xue <ming.xue@plateau.com>
To: "'ibatis-user-java@incubator.apache.org'"
	 <ibatis-user-java@incubator.apache.org>
Subject: RE: Possible Connection Leak
Date: Mon, 9 May 2005 14:24:09 -0400 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N


Do you mean I do not need Transaction in SqlMap at all (removing the
TransactionManager tag) ?

Thanks for any clarification.

-----Original Message-----
From: Henry Lu [mailto:zhlu@umich.edu]
Sent: Monday, May 09, 2005 2:23 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Possible Connection Leak


No. You config JNDI in the spring.xml instead.

-Henry

Ming Xue wrote:

> Hi
>  
> I am using the SpringDAO framework,  basically the SqlMapDAOSupport 
> and SqlMapTemplate,  the Transaction is acturally controlled by 
> Spring,  in this case, how should I config the transaction of SqlMap,  
> should I use External Type ?
>  
>   <transactionManager type="EXTERNAL">
>     <dataSource type="JNDI">
>       <property name="DataSource" value="java:/PlateauDS"/>
>     </dataSource>
>   </transactionManager>
>  
> Here is my DAO
>  
> public class MyDAO extends SqlMapDAOSupport implements MyDAOService
>  
> {
>     public void myMethod () {
>  
>         getSqlMapClientTemplate().insert("insertAccount", account);
>  
>     }
>  
> }
>  
> The transaction is started in the EJB level, which calls the DAO, and 
> a EJB may call any number of DAO to do the job, in this case,
> do I need to put in the SQLMap.startTransaction  in the DAO code ?
>  
> Thanks
> Ming
>  
>  
>  
>
> [Ming Xue] 
>  
>  
>  -----Original Message-----
> *From:* Clinton Begin [mailto:clinton.begin@gmail.com]
> *Sent:* Monday, May 09, 2005 1:04 PM
> *To:* ibatis-user-java@incubator.apache.org
> *Subject:* Re: Possible Connection Leak
>
>     Yes, the approach I suggested should be used regardless of your
>     transaction type.
>
>     Cheers,
>     Clinton
>
>     On 5/9/05, *Rafiq, Adnan* <arafiq@carreker.com
>     <mailto:arafiq@carreker.com>> wrote:
>
>         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
>             <mailto:clinton.begin@gmail.com>]
>             *Sent:* Saturday, May 07, 2005 9:30 PM
>             *To:* ibatis-user-java@incubator.apache.org
>             <mailto: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?
>
>
>