Vertica JDBC Connection process/session id

Ram_Prasad

@SPID to get the session id of that connection, then i kill that process id when user clicks on cancel. Same way how to do for VERTICA?

Prasanta_Pal

To close a session
select * from sessions;  //get the session id and then close the session
select close_session('localhost.localdoma-13354:0xbeab');
select * from sessions;
dbadmin=> select session_id, statement_id, current_statement from sessions;

Ram_Prasad

I'm connecting through JDBC Connection so from that connection i need that particular connections session id to stop the process.