You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by 瀧内誠 <mt...@kantei.co.jp> on 2007/12/06 03:13:50 UTC

Many DB sessions are left

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

Re: Many DB sessions are left

Posted by Makoto Takiuchi <mt...@kantei.co.jp>.

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, 瀧内誠 <mt...@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
>>

Re: Many DB sessions are left

Posted by Larry Meadors <lm...@apache.org>.

Are you using a connection pool that is created outside of iBATIS?

Larry


On Dec 5, 2007 7:13 PM, 瀧内誠 <mt...@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
>