Execute in the same transaction

[Tom Henricksen]

 

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