2 Replies Latest reply on Oct 30, 2012 3:25 AM by Rakesh Balguri

    Creating a continuous translator

    Rakesh Balguri Expert

      Hi,

       

      I am creating a custom translator extending the H2ExecutionFactory and my Execution extends the  JDBCQueryExecution and implements the ReusableExecution to make the translator continuous.

      Now, if I execute a SQL select * from test, Teiid will continuously execute this SQL and returns the results back to the client.

       

      The normal flow is execute(), next() and reset(). This flow will be executed continuously.

       

      I tried with throwing the DataNotAvailableException but that did not solve my problem.

       

      Is there a way to pause the execution after execute() and next() and then after some event (Example: a trigger) has occurred, resume the execution and then pause until the event is reoccurred?

       

      Thanks

      Rakesh.