Mailing-List: contact user-cs-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-cs@ibatis.apache.org
Received-SPF: pass (hermes.apache.org: domain of ibatis.net@gmail.com
 designates 64.233.182.195 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=MO4NuqVNIP3cn4OSJ9eJjWGmMcFBQITbpvhuluT9As5MLa9w6L18ocdeDr+OEJ68k2fYaYR2AuRrt37OrhUwuoqt1ma/IORP5/+ifLHttkCadBo0hrgODQCr+M4eTRir6d/bptTCV65V4zwic8AEZgwLJt6UOMU3MnexbBVGfD0=
Message-ID: <f3534c960601041017u37db6d47h344a85a052d2853d@mail.gmail.com>
Date: Wed, 4 Jan 2006 19:17:24 +0100
From: Gilles Bayon <ibatis.net@gmail.com>
To: user-cs@ibatis.apache.org
Subject: Re: Nested / Multiple Transactions open on same thread?
In-Reply-To: <5f9068320601040939u1e74a7f5pb6bb6be6e72077e9@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4015_14056900.1136398644945"
References: <5f9068320601040911t7e322023ydb4fa8073f1bc09c@mail.gmail.com>
	 <5f9068320601040939u1e74a7f5pb6bb6be6e72077e9@mail.gmail.com>

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

Each SqlMapper use a different 'TLS' session store.
Which iBATIS version do you use ?


On 1/4/06, Michael Schall <mike.schall@gmail.com> wrote:
>
> I need the ability to have muliple transactions / connections open to
> the same database on the same thread at the same time.
>
> For example I want to:
> 1) Open a connection and transaction (Session1) to a database
> 2) Perform multiple inserts to tables in the database
> 3) Commit and close (Session1)
>
> Easy right.
>
> My problem is that in order to perform the multiple inserts I need to
> get / update information in another table.  I have created multiple
> DomSqlMapBuilders, configure them with different configuration files,
> and store them as separate SqlMapper instances.  So my example needs
> to look like
>
> 1) Open a connection and transaction (Session1 on SqlMapper1) to a
> database
> 2) Open a connection and transaction (Session2 on SqlMapper2) to the
> same database
> 3) Get and Increment Counter (Session2)
> 4) Commit and close (Session2)
> 5) Perform insert to table in the database using counter (Session1)
> 6) Open a connection and transaction (Session2) to the same database
> 7) Get and Increment Counter (Session2)
> 8) Commit and close (Session2)
> 9) Perform insert to table in the database using counter (Session1)
> 10) ...
> 11) Commit and close (Session1)
>
> If for any reason I need to rollback (Session1) at step 10, the
> actions performed on (Session2) should not be rolled back as they have
> been committed.
>
> However when I try and do step 2 SqlMapper2 is already in a
> transaction.  It seems like due to the way the session is stored in
> TLS, it will only allow for one session to be stored per thread.
>
> Is there a way to get this to work?  I can submit code if that helps.
>
> Thanks for your time.
> Mike
>

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

<div>Each SqlMapper use a different 'TLS' session store.</div>
<div>Which iBATIS version do you use ?<br><br>&nbsp;</div>
<div><span class=3D"gmail_quote">On 1/4/06, <b class=3D"gmail_sendername">M=
ichael Schall</b> &lt;<a href=3D"mailto:mike.schall@gmail.com">mike.schall@=
gmail.com</a>&gt; wrote:</span>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I need the ability to have mulip=
le transactions / connections open to<br>the same database on the same thre=
ad at the same time.
<br><br>For example I want to:<br>1) Open a connection and transaction (Ses=
sion1) to a database<br>2) Perform multiple inserts to tables in the databa=
se<br>3) Commit and close (Session1)<br><br>Easy right.<br><br>My problem i=
s that in order to perform the multiple inserts I need to
<br>get / update information in another table.&nbsp;&nbsp;I have created mu=
ltiple<br>DomSqlMapBuilders, configure them with different configuration fi=
les,<br>and store them as separate SqlMapper instances.&nbsp;&nbsp;So my ex=
ample needs<br>to look like
<br><br>1) Open a connection and transaction (Session1 on SqlMapper1) to a =
database<br>2) Open a connection and transaction (Session2 on SqlMapper2) t=
o the<br>same database<br>3) Get and Increment Counter (Session2)<br>4) Com=
mit and close (Session2)
<br>5) Perform insert to table in the database using counter (Session1)<br>=
6) Open a connection and transaction (Session2) to the same database<br>7) =
Get and Increment Counter (Session2)<br>8) Commit and close (Session2)<br>
9) Perform insert to table in the database using counter (Session1)<br>10) =
...<br>11) Commit and close (Session1)<br><br>If for any reason I need to r=
ollback (Session1) at step 10, the<br>actions performed on (Session2) shoul=
d not be rolled back as they have
<br>been committed.<br><br>However when I try and do step 2 SqlMapper2 is a=
lready in a<br>transaction.&nbsp;&nbsp;It seems like due to the way the ses=
sion is stored in<br>TLS, it will only allow for one session to be stored p=
er thread.
<br><br>Is there a way to get this to work?&nbsp;&nbsp;I can submit code if=
 that helps.<br><br>Thanks for your time.<br>Mike<br></blockquote></div><br=
>

------=_Part_4015_14056900.1136398644945--