ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Makoto Takiuchi <mtaki...@kantei.co.jp>
Subject Re: Many DB sessions are left
Date Thu, 06 Dec 2007 09:02:10 GMT

Hi,

I am using the following 
       <transactionManager type="JDBC" >
       <dataSource type="SIMPLE">

Out system has 100/tps transactions.

Always Oracle sessions  was left (abount 300-500 sessions)


>Are you using a connection pool that is created outside of iBATIS?
>
>Larry
>
>
>On Dec 5, 2007 7:13 PM, 瀧内誠 <mtakiuch@kantei.co.jp> wrote:
>>
>> Hi,
>>
>> I have a problem.
>>
>> I use java1.5, iBatis2,3 Oracle10G, tomcat6.
>>
>> Though servlet processing was over, a lot of Oracle sessions are left.
>> Do you know a solution?
>>
>>
>> ---------------part of program------------------------------
>> Reader reader = Resources.getResourceAsReader(RESOURCE_FILE);
>> SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
>> sqlMap.startTransaction();
>> List<Map> list1 = (List<Map>) sqlMap.queryForList("getData");
>> sqlMap.endTransaction ();
>> sqlMap = null;
>> reader = null;
>> list1 = null;
>> ---------------part of program------------------------------
>>
>> Thank You in Advance
>> Makoto Takiuchi
>>

Mime
View raw message