Re: Many DB sessions are left

[chris . mccauley]

The JDBC implies explicit trasnaction control...this is in the code?

 

Thank you, 
Christopher

~~~~~~~~~~~~~~~~~
Christopher McCauley
Unisys Consultant
GSA - Federal Acquisition Service
CP3 11028B
(703) 605 9160
[EMAIL PROTECTED]
[EMAIL PROTECTED]

-----"Makoto Takiuchi" <[EMAIL PROTECTED]> wrote: -----

To: [EMAIL PROTECTED]
From: "Makoto Takiuchi" <[EMAIL PROTECTED]>
Date: 12/06/2007 04:02AM
cc: user-java@ibatis.apache.org
Subject: Re: Many DB sessions are left

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, 瀧内誠 <[EMAIL PROTECTED]> 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
>>