1 Reply Latest reply: Aug 2, 2008 7:49 AM by georgev63 RSS

    Help: Database trasactions in ADDT

    mohnkhan Community Member
      Hi all,
      First of all, I have done some research, and have come to certain conclusions but this may be my prejudice. It somebody here can throw more light on it.. you are most welcome.
      1. Does ADDT do or support database transactions ?
      a. If it does how to invoke it ?
      b. If it doesn't then the how do we explicitly do this ?
      2. In My case I am using a very unusual combination of Classic ASP+MySQL + host of ActiveX components.
      I plan to have 3 triggers built called as
      a. TrigTransStart which will start a new transaction.
      b. TrigTransCommit Which will commit the current transaction.
      c. TrigTransRollback which will rollback the transaction.
      and
      Implementation Details:
      call this TrigTransStart Before the transaction as a starter with priority 1.

      TrigTransCommit is called indirectly through a Linked Second Transaction and the end trigger is the one attached to it.
      TrigTransRollback is called on error at any level in any transaction.

      Note: later may add save points etc., if needed. and implement them as triggers.
      All these triggers would actually call stored procedures which would do this transaction handling in database.

      Background Stuff: I am have a Accounting / Billing type feature implemented and working fine using ADDT.

      Possibly I am on a completely wrong track.
      If anybody has already done this please.. throw some light!.

      For sure I will share and open source

      Thanks for reading my this long boring concept.

      mohnkhan
        • 1. Re: Help: Database trasactions in ADDT
          georgev63 Community Member
          Mohnkhan, let me see if I understand this correctly. You have several mySQL database transactions that you would like to call in your application using ADDT server behaviors. SQL database transactions can be called explicitly using standard SQL code in custom ADDT transactions (that you can of course link together and do all kinds of wonderful stuff with). This scenario implies that you already have one of more SQL transactions in your database and you call them via custom ADDT transactions. I don't think you would be able to call separate components of an SQL transaction in your application as each SQL transaction is treated as a single unit by the server, that is it is either committed or rolled back in its entirety.