Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of clinton.begin@gmail.com
 designates 64.233.162.199 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=MQn/fmlUbbPWGe1B1OOuwKICMTG1RV+JEPpWxqkxpxSmggSp1pLdCUougO1OxlX52d0Uj1Qshz03oMKurFJriEHhAEA0MkIf0DydiRd8HtHTKt5ksxV9j/fPdn3BKdT0MaJh6OwwfageidHGBB1q9xgvqhVaxChTz0jPWPM2fbk=
Message-ID: <16178eb10512060738w5121b9d1wdbfd94ab17dad33c@mail.gmail.com>
Date: Tue, 6 Dec 2005 08:38:45 -0700
From: Clinton Begin <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: how to commit a connection?
In-Reply-To: <1b4364400512051105v4c094512i651a6ceecc8b1de0@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_10305_24565248.1133883525985"
References: <1b4364400512051105v4c094512i651a6ceecc8b1de0@mail.gmail.com>

------=_Part_10305_24565248.1133883525985
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Ahh...you'll want to force commits....

<transactionManager ....  commitRequired=3D"true">

The problem is that iBATIS only commits if it is aware of an actual update.
Bypassing the insert statement causes iBATIS to miss the fact that an updat=
e
has occurred.

Cheers,
Clinton

On 12/5/05, Leonardo Kenji Shikida <shikida@gmail.com> wrote:
>
> I have an application that uses ibatis and an older legacy database
> schema, both in the same mysql database.
>
> I would like to share the same connection to ibatis methods and the
> legacy code, so I could use transactions to control both applications
>
> I have a snippet as follows
>
> SqlMapClient dbclient =3D
> SqlMapClientBuilder.buildSqlMapClient(sqlMapConfigFileReader);
> Connection con =3D null;
> try{
>   dbclient.startTransaction();
>   con =3D dbclient.getCurrentConnection();
>   //////dbclient.insert("insertMyObject",new MyObject());
>   myClass.executeSomeSqlWithoutIbatisHere(con);
>   dbclient.commitTransaction();
> }catch(Exception e){
>   e.printStackTrace();
> }finally{
>   try{
>     dbclient.endTransaction();
>   }catch(Exception e2){
>     e2.printStackTrace();
>   }
> }
>
> this code does not commit, but if I uncomment the insert statement, it
> commits. So maybe dbclient checks for some flag or configures some
> scope or context in the insert method.
>
> no exception is raised in both situations
>
> how could I set this flag or what's the correct approach for this
> situation?
>
> seems clear to me that I could open a session, get the datasource,
> than get the connection, then close the connection, then close the
> session, etc etc etc, but I am not sure if it's the best way to do
> this.
>
> thanks in advance
>
> Kenji
> _______________________
> http://kenjiria.blogspot.com
> http://gaitabh.blogspot.com
>

------=_Part_10305_24565248.1133883525985
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br>
Ahh...you'll want to force commits....<br>
<br>
&lt;transactionManager ....&nbsp; commitRequired=3D&quot;true&quot;&gt;<br>
<br>
The problem is that iBATIS only commits if it is aware of an actual
update.&nbsp; Bypassing the insert statement causes iBATIS to miss the
fact that an update has occurred.<br>
<br>
Cheers,<br>
Clinton<br><br><div><span class=3D"gmail_quote">On 12/5/05, <b class=3D"gma=
il_sendername">Leonardo Kenji Shikida</b> &lt;<a href=3D"mailto:shikida@gma=
il.com">shikida@gmail.com</a>&gt; wrote:</span><blockquote class=3D"gmail_q=
uote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0=
pt 0.8ex; padding-left: 1ex;">
I have an application that uses ibatis and an older legacy database<br>sche=
ma, both in the same mysql database.<br><br>I would like to share the same =
connection to ibatis methods and the<br>legacy code, so I could use transac=
tions to control both applications
<br><br>I have a snippet as follows<br><br>SqlMapClient dbclient =3D<br>Sql=
MapClientBuilder.buildSqlMapClient(sqlMapConfigFileReader);<br>Connection c=
on =3D null;<br>try{<br>&nbsp;&nbsp;dbclient.startTransaction();<br>&nbsp;&=
nbsp;con =3D dbclient.getCurrentConnection
();<br>&nbsp;&nbsp;//////dbclient.insert(&quot;insertMyObject&quot;,new MyO=
bject());<br>&nbsp;&nbsp;myClass.executeSomeSqlWithoutIbatisHere(con);<br>&=
nbsp;&nbsp;dbclient.commitTransaction();<br>}catch(Exception e){<br>&nbsp;&=
nbsp;e.printStackTrace();<br>}finally{
<br>&nbsp;&nbsp;try{<br>&nbsp;&nbsp;&nbsp;&nbsp;dbclient.endTransaction();<=
br>&nbsp;&nbsp;}catch(Exception e2){<br>&nbsp;&nbsp;&nbsp;&nbsp;e2.printSta=
ckTrace();<br>&nbsp;&nbsp;}<br>}<br><br>this code does not commit, but if I=
 uncomment the insert statement, it<br>commits. So maybe dbclient checks fo=
r some flag or configures some
<br>scope or context in the insert method.<br><br>no exception is raised in=
 both situations<br><br>how could I set this flag or what's the correct app=
roach for this situation?<br><br>seems clear to me that I could open a sess=
ion, get the datasource,
<br>than get the connection, then close the connection, then close the<br>s=
ession, etc etc etc, but I am not sure if it's the best way to do<br>this.<=
br><br>thanks in advance<br><br>Kenji<br>_______________________<br><a href=
=3D"http://kenjiria.blogspot.com">
http://kenjiria.blogspot.com</a><br><a href=3D"http://gaitabh.blogspot.com"=
>http://gaitabh.blogspot.com</a><br></blockquote></div><br>

------=_Part_10305_24565248.1133883525985--