Cancel Vertica statement from JDBC
i would like to have the ability to cancel long running statements upon demand.
i managed to kill statements through vsql cli with the following query:
select INTERRUPT_STATEMENT('session_id', stmt_number);
now, i would like to do it through JDBC. it seems that preparedStatement.cancel() does not kill the statement. in addition, connection.close() or connection.abort(executorService) do not work either.
my next thought is to run the INTERRUPT_STATEMENT from JDBC. my questions are:
1. is there a built in way to kill statements from JDBC?
2. how can i get session id and statement id from JDBC?