Return-Path: 
 <user-java-return-18159-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 40998 invoked from network); 19 Nov 2009 20:33:46 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 19 Nov 2009 20:33:46 -0000
Received: (qmail 69454 invoked by uid 500); 19 Nov 2009 20:33:45 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 69383 invoked by uid 500); 19 Nov 2009 20:33:45 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 69375 invoked by uid 99); 19 Nov 2009 20:33:45 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Nov 2009 20:33:45 +0000
X-ASF-Spam-Status: No, hits=-2.6 required=5.0
	tests=BAYES_00,HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of frengifo@gmail.com designates
 209.85.210.188 as permitted sender)
Received: from [209.85.210.188] (HELO mail-yx0-f188.google.com)
 (209.85.210.188)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Nov 2009 20:33:42 +0000
Received: by yxe26 with SMTP id 26so2292788yxe.4
        for <user-java@ibatis.apache.org>;
 Thu, 19 Nov 2009 12:33:21 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:reply-to:in-reply-to
         :references:date:message-id:subject:from:to:content-type;
        bh=NWR4+CIzFkMtGfB0PPil/ADuPvUMj5Iu1EOmxr50VcA=;
        b=X2DGTVDhZhqHVVFO+sdWO65njys1bbCIPJvSTaROdcwPwHutGHjsuVK2ml0KLXCcN+
         qie6BUfReavuq9QWFGPMWBdiw7vXs3qT0OIGf43zY1l5K4oK1zdTQXav/OeKkEJTil0B
         xAiems6JI4d0GbZJjmFmZ1FNJmGDi7a4ffeQ8=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:reply-to:in-reply-to:references:date:message-id
         :subject:from:to:content-type;
        b=BaLW0bmrSeNL8qteFlDnpZ46uv1tJQeeGBmkDhl9cJo0FPvdZ6TVpsHnHsKcBUU44M
         D6f43S9YNeoK77SqwmOMTqMxRZcPOS5OigsX/W+jv/ystZwOdTN8FHe1c/epNee03QXm
         C3YzJmO084/PmqWi/oGRZkklqX+THmkiqr4t0=
MIME-Version: 1.0
Received: by 10.213.96.202 with SMTP id i10mr1938467ebn.99.1258662800397;
 Thu,
	19 Nov 2009 12:33:20 -0800 (PST)
Reply-To: frengifo@gmail.com
In-Reply-To: <4B055DF4.8C1D.00A5.0@bop.gov>
References: <e5bb03110911191148l12b7b1d7pa662fe5bfeb9b5fe@mail.gmail.com>
	 <4B055DF4.8C1D.00A5.0@bop.gov>
Date: Thu, 19 Nov 2009 15:33:20 -0500
Message-ID: <e5bb03110911191233n4a2d5099qb962f5350289b0b9@mail.gmail.com>
Subject: Re: iBATIS 2.3.4 issues closing connections
From: Fernando Rengifo <frengifo@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=001636a7d9131c151f0478bf4570

--001636a7d9131c151f0478bf4570
Content-Type: text/plain; charset=ISO-8859-1

Hi Jeff,

Thank you very much for your time answering this question.

Mine looks as follows:

<transactionManager type="EXTERNAL">
  <property name="SetAutoCommitAllowed" value="false"/>
  <dataSource type="JNDI">
    <property name="DataSource" value="java:comp/env/jdbc/myapp"/>
  </dataSource>
</transactionManager>

Any ideas?

So, if I enable the commitRequired="true" do I have to use
startTransaction(), commitTransaction() and endTransaction() at any single
SQL?

Thank you again.

  -Fernando Rengifo.


On Thu, Nov 19, 2009 at 3:02 PM, Jeff Hibbs <jhibbs@bop.gov> wrote:

>  Fernando -
>
> I'm no expert, but I had a similar problem using DB2.  When we moved from
> Sun App servers to Glassfish I started having "open Threads"...Not sure if
> this is the same as what you're experiencing, but all I had to do was change
> my sqlMapConfig file to add the
>
> commitRequired="true" parm....so it looks like this:
>
>  <transactionManager type="JDBC" commitRequired="true">
>         <dataSource type="JNDI">
>             <property name="DataSource" value="java:comp/env/@
> isds.datasource.name@"/>
>         </dataSource>
>     </transactionManager>
>
> I hope this helps...Jeff Hibbs
>
> >>> Fernando Rengifo <frengifo@gmail.com> 11/19/2009 2:48 PM >>>
> Hi all,
>
> Thank you for your time to read this question.
> I really (really) appreciate your help on this.
>
> I have developed an application using iBATIS (what a great framework!).
> The project started on Feb 2009, and since Oct 2009 is under my client's
> server.
>
> We use JNDI to a DB2 iSeries Toolbox DataSource configured under Websphere
> 6.1 using j400.jar driver.
>
> Since yesterday, they have been noticing this problem with some tables at
> DB2 (iSeries) server.
> "....... *FILE in use".
>
> They have been making me questions about this issue because they think
> iBATIS does not close connections after any transaction.
> I have told them about iBATIS documentation, where it says
> startTransaction() and endTransaction() are called automatically if we
> don't.
>
> What I can tell you, is that I only use sqlMapper.update(), insert(),
> queryForObject(), queryForList() for simple queries.
>
> For batch queries, I use the startTransaction(), startBatch(),
> executeBatch(), commitTransaction(), endTransaction():
>
> Am I missing somthing ? Is this related to iBATIS?
>
> Thank you very much.
>
> -Fernando Rengifo.
>
>

--001636a7d9131c151f0478bf4570
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Jeff,=A0<div><br></div><div>Thank you very much for your time answering =
this question.</div><div><br></div><div>Mine looks as follows:</div><div><b=
r></div><div><div>&lt;transactionManager type=3D&quot;EXTERNAL&quot;&gt;</d=
iv>
<div>=A0=A0&lt;property name=3D&quot;SetAutoCommitAllowed&quot; value=3D&qu=
ot;false&quot;/&gt;</div><div>=A0=A0&lt;dataSource type=3D&quot;JNDI&quot;&=
gt;</div><div>=A0=A0 =A0&lt;property name=3D&quot;DataSource&quot; value=3D=
&quot;java:comp/env/jdbc/myapp&quot;/&gt;</div>
<div>=A0=A0&lt;/dataSource&gt;</div><div>&lt;/transactionManager&gt;</div><=
/div><div><br></div><div>Any ideas?</div><div><br></div><div>So, if I enabl=
e the commitRequired=3D&quot;true&quot; do I have to use startTransaction()=
, commitTransaction() and endTransaction() at any single SQL?</div>
<div><br></div><div>Thank you again.</div><div><br clear=3D"all"> =A0 -Fern=
ando Rengifo.<br>
<br><br><div class=3D"gmail_quote">On Thu, Nov 19, 2009 at 3:02 PM, Jeff Hi=
bbs <span dir=3D"ltr">&lt;<a href=3D"mailto:jhibbs@bop.gov">jhibbs@bop.gov<=
/a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:=
0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">



<div style=3D"margin:4px 4px 1px;font:10pt Tahoma">
<div>Fernando - </div>
<div>=A0</div>
<div>I&#39;m no expert, but I had a similar problem using DB2.=A0 When we m=
oved from Sun App servers to Glassfish I started having &quot;open Threads&=
quot;...Not sure if this is the same as what you&#39;re experiencing, but a=
ll I had to do was change my sqlMapConfig file to add the </div>

<div>=A0</div>
<div>commitRequired=3D&quot;true&quot; parm....so it looks like this:</div>
<div>=A0</div>
<div>=A0&lt;transactionManager type=3D&quot;JDBC&quot; commitRequired=3D&qu=
ot;true&quot;&gt;<br>=A0=A0=A0=A0=A0=A0=A0 &lt;dataSource type=3D&quot;JNDI=
&quot;&gt;<br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 &lt;property name=3D&quot;D=
ataSource&quot; value=3D&quot;java:comp/env/@<a href=3D"http://isds.datasou=
rce.name" target=3D"_blank">isds.datasource.name</a>@&quot;/&gt;<br>
=A0=A0=A0=A0=A0=A0=A0 &lt;/dataSource&gt;<br>=A0=A0=A0 &lt;/transactionMana=
ger&gt;</div>
<div>=A0</div>
<div>I hope this helps...Jeff Hibbs<br><br>&gt;&gt;&gt; Fernando Rengifo &l=
t;<a href=3D"mailto:frengifo@gmail.com" target=3D"_blank">frengifo@gmail.co=
m</a>&gt; 11/19/2009 2:48 PM &gt;&gt;&gt;<br></div><div><div></div><div cla=
ss=3D"h5">
<span style=3D"font-size:13px;font-family:arial, sans-serif;border-collapse=
:collapse">
<div>Hi all,</div>
<div><br></div>
<div>Thank you for your time to read this question.</div>
<div>I really (really) appreciate your help on this.</div>
<div><br></div>
<div>I have developed an application using iBATIS (what a great framework!)=
.</div>
<div>The project started on Feb 2009, and since Oct 2009 is under my client=
&#39;s server.</div>
<div><br></div>
<div>We use JNDI to a DB2 iSeries Toolbox DataSource configured under Websp=
here 6.1 using j400.jar driver.</div>
<div><br></div>
<div>Since yesterday, they have been noticing this problem with some tables=
 at DB2 (iSeries) server.</div>
<div>&quot;....... *FILE in use&quot;.</div>
<div><br></div>
<div>They have been making me questions about this issue because they think=
 iBATIS does not close connections after any transaction.</div>
<div>I have told them about iBATIS documentation, where it says startTransa=
ction() and endTransaction() are called automatically if we don&#39;t.</div=
>
<div><br></div>
<div>What I can tell you, is that I only use sqlMapper.update(), insert(), =
queryForObject(), queryForList() for simple queries.</div>
<div><br></div>
<div>For batch queries, I use the startTransaction(), startBatch(), execute=
Batch(), commitTransaction(), endTransaction():</div>
<div><br></div>
<div>Am I missing somthing ? Is this related to iBATIS?</div>
<div><br></div>
<div>Thank you very much.</div>
<div><br></div></span>-Fernando Rengifo.<br><br>

    <div>
     =20
    </div>
  </div></div></div>
</blockquote></div><br></div>

--001636a7d9131c151f0478bf4570--