ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrea Selva <selva.an...@gmail.com>
Subject Re: Execute in the same transaction
Date Wed, 27 Jan 2010 09:13:59 GMT
Hi,
i think that the statements are executed in 2 transaction because your
connection pool contains more than one connection.
To execute the two in the same transaction i suppose you should do something
like this:
<your_sqlMap_cleint_instance>.startTransaction();
<your_sqlMap_cleint_instance>.queryForList("*selectTestObject*");
<your_sqlMap_cleint_instance>.endTransaction();

This is what i will do, i hope this coul help
 Andrea

On Tue, Jan 26, 2010 at 1:29 PM, Tom Henricksen <TomH@a-t-g.com> wrote:

>
>
> I’m calling the select statement *selectTestObject* in a transaction but
> it is very surprising that select=*"TEMPVsp.selectById" *runs on a
> different connection. Is there a way that* *select=*"TEMPVsp.selectById” *executes
> in the same transaction as* selectTestObject. *
>
>
>
> <resultMap class=*"Test"* id=*"TestMap"*>
>
>             <result column=*"ID"* property=*"id"*/>
>
>             <result column=*"TEMPID"* property=*"temp"* select=*
> "TEMPVsp.selectById"*/>
>
> </resultMap>
>
>
>
> <select id=*"selectTestObject"* parameterClass=*"map"* resultMap=*
> "TestMap"*>
>
>
>
>                   SELECT
>
>                         ID,
>
>                         *TEMPID*
>
>                   FROM
>
>                         TESTTABLE
>
>                   WHERE
>
>                       ID = #id#
>
>
>
> </select>
>
>
>
> Thanks,
>
> PK
>

Mime
View raw message