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?
