Hi,
It came to move well.
such as follows
<property name="Pool.MaximumActiveConnections" value="1"/>
<property name="Pool.MaximumIdleConnections" value="0"/>
Thank you
Makoto Takiuchi
[EMAIL PROTECTED] さんは書きました:
>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: [email protected]
>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
>>>
>
>
