1 Reply Latest reply on Oct 16, 2013 4:18 PM by shawkins

    Continuous requests are not allowed to be transactional ?

    markaddleman

      I've finally gotten back to playing around with continuous executions and anonymous procedure blocks.  In a new test case, I'm trying to execute "BEGIN SELECT * FROM delay; END"  delay is a regular table served up by a custom translator. Teiid throws an exception saying "Continuous requests are not allowed to be transactional."  What's weird is that, in a different test case but similar code, I don't get this message.  Any hint as to what's going on?

      "BEGIN SELECT * FROM delay; END"

        • 1. Re: Continuous requests are not allowed to be transactional ?
          shawkins

          The transaction autowrap logic in nearly all scenarios will determine that a transaction is needed when running a procedure with an isolation level higher than read committed.  If delay just maps to a single source table, then it seems like we are over detecting here.  If you don't want it to be transactional, then use txnAutoWrap=OFF.  Of if you do want a transaction around just the block, then use BEGIN ATOMIC.

           

          Steve