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 qiaobing@gmail.com designates
 64.233.182.201 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:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=H+6VwkJawKgEwC7BvLM/A2ddiVtcXokUE+e/zRaggD7RwKcPE5rtxmFO64glb/rMDpUzJkhrHjj33pCo8eU658r1Ta+UMc2/mikPP9BrbmySAX7lg9leBag9tfDodbtzotc6Ks3GB7A/zxbf2K6lFvmPLmUEgbt4x4Lr4Mp7CG4=
Message-ID: <82ad83f705081503304305d45a@mail.gmail.com>
Date: Mon, 15 Aug 2005 11:30:10 +0100
From: Bing Qiao <qiaobing@gmail.com>
To: user-java@ibatis.apache.org
Subject: IMPLICIT_TRANSACTIONS and sqlmap Transaction
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,

I'm using sqlmap transaction in java to call a stored procedure:
/******************************************/
try {
      Treasury.startTransaction();
      rtn =3D ServiceFacade.updateActionStatus(this.getPayment().
          getPaymentid());
      if (rtn) {
        Treasury.commitTransaction();
      }

    }
    finally {
      Treasury.endTransaction();
    }

public static boolean updateActionStatus(int paymentid) {
    try {
      sqlmap.update("updateActionStatus", new Integer(paymentid));
    }
    catch (Exception e) {
      return false;
    }
    return true;
  }
/***************************************************/
updateActionStatus is mapped to a stored procedure.

It seems that to make the transaction work, I can't use SET
IMPLICIT_TRANSACTIONS OFF in this stored procedure without putting
something like a query before it.

In other words, if I call two stored procedures in the transaction
block. If the first one is a query and the second one an update with
SET IMPLICIT_TRANSACTIONS OFF in it. The transaction works.

However, if the update is called first, the transaction does not work.

BTW, the update stored procedure has its own transactions too.

I could drop the  SET IMPLICIT_TRANSACTIONS OFF to make it work. But
there are dozens of others. Could somebody advice a right way to use
both sqlmap transaction in java and MS SQL Server's transactions in
stored procedures. And how to handle the SET IMPLICIT_TRANSACTIONS
OFF.

Thanks very much!

Bqiao