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.