Re: Possible Connection Leak

Mon, 09 May 2005 11:27:57 -0700 

Exactly.

-Henry

Ming Xue wrote:

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:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 2:23 PM
To: [email protected]
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:[EMAIL PROTECTED]
*Sent:* Monday, May 09, 2005 1:04 PM
*To:* [email protected]
*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* <[EMAIL PROTECTED]
   <mailto:[EMAIL PROTECTED]>> 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:[EMAIL PROTECTED]
           <mailto:[EMAIL PROTECTED]>]
           *Sent:* Saturday, May 07, 2005 9:30 PM
           *To:* [email protected]
           <mailto:[email protected]>
           *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* <[EMAIL PROTECTED]
           <mailto:[EMAIL PROTECTED]>> 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
               "[EMAIL PROTECTED]" 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?









Reply via email to