ReactiveEntityStore - cancel a long-running query

[pdjstone]

Using Requery on Android with RxJava, is it possible to cancel a long running query? Something like this:

Disposable d = store.select(...).get().observable().subscribe(...);
...
in onPause:
d.dispose();

I have an issue where the connection pool is blocked until the long-running query is completed, even if the user leaves the activity.

[pdjstone]

For Android it looks like requery would need to use CancellationSignal for SQLite. For backends using JDBC, Statement.cancel() would have to be used. I guess the requery API would then need to expose these in a generic way. The Requery RxJava extensions would then be able to take advantage of this.