ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chris.mccau...@gsa.gov
Subject Re: Many DB sessions are left
Date Thu, 06 Dec 2007 14:34:35 GMT
<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2><DIV>The
JDBC implies explicit trasnaction control...this is in the code?</DIV><DIV><BR>&nbsp;</DIV><DIV>Thank&nbsp;you,&nbsp;<BR>Christopher<BR><BR>~~~~~~~~~~~~~~~~~<BR>Christopher&nbsp;McCauley<BR>Unisys&nbsp;Consultant<BR>GSA&nbsp;-&nbsp;Federal&nbsp;Acquisition&nbsp;Service<BR>CP3&nbsp;11028B<BR>(703)&nbsp;605&nbsp;9160<BR><A
href="mailto:chris.mccauley@gsa.gov" target=blank >chris.mccauley@gsa.gov</A><BR><A
href="mailto:chris.mccauley@unisys.com" target=blank >chris.mccauley@unisys.com</A><BR><DIV><BR></DIV><FONT
color=#990099>-----"Makoto Takiuchi" &lt;mtakiuch@kantei.co.jp&gt; wrote: -----<BR><BR></FONT><blockquote
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid;
MARGIN-RIGHT: 0px">To: lmeadors@apache.org<BR>From: "Makoto Takiuchi" &lt;mtakiuch@kantei.co.jp&gt;<BR>Date:
12/06/2007 04:02AM<BR>cc: user-java@ibatis.apache.org<BR>Subject: Re: Many DB
sessions are left<BR><BR><FONT face="Default Monospace,Courier New,Courier,monospace"
size=2  >Hi,<BR><BR>I am using the following <BR>&nbsp; &nbsp;
&nbsp; &lt;transactionManager type="JDBC" &gt;<BR>&nbsp; &nbsp;
&nbsp; &lt;dataSource type="SIMPLE"&gt;<BR><BR>Out system has 100/tps
transactions.<BR><BR>Always Oracle sessions &nbsp;was left (abount 300-500
sessions)<BR><BR><BR>&gt;Are you using a connection pool that is created
outside of iBATIS?<BR>&gt;<BR>&gt;Larry<BR>&gt;<BR>&gt;<BR>&gt;On
Dec 5, 2007 7:13 PM, 瀧内誠 &lt;mtakiuch@kantei.co.jp&gt; wrote:<BR>&gt;&gt;<BR>&gt;&gt;
Hi,<BR>&gt;&gt;<BR>&gt;&gt; I have a problem.<BR>&gt;&gt;<BR>&gt;&gt;
I use java1.5, iBatis2,3 Oracle10G, tomcat6.<BR>&gt;&gt;<BR>&gt;&gt;
Though servlet processing was over, a lot of Oracle sessions are left.<BR>&gt;&gt;
Do you know a solution?<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;
---------------part of program------------------------------<BR>&gt;&gt; Reader
reader = Resources.getResourceAsReader(RESOURCE_FILE);<BR>&gt;&gt; SqlMapClient
sqlMap =    SqlMapClientBuilder.buildSqlMapClient(reader);<BR>&gt;&gt; sqlMap.startTransaction();<BR>&gt;&gt;
List&lt;Map&gt; list1 = (List&lt;Map&gt;) sqlMap.queryForList("getData");<BR>&gt;&gt;
sqlMap.endTransaction ();<BR>&gt;&gt; sqlMap = null;<BR>&gt;&gt;
reader = null;<BR>&gt;&gt; list1 = null;<BR>&gt;&gt; ---------------part
of program------------------------------<BR>&gt;&gt;<BR>&gt;&gt;
Thank You in Advance<BR>&gt;&gt; Makoto Takiuchi<BR>&gt;&gt;<BR><BR></FONT></blockquote><br></DIV></FONT>

Mime
View raw message