Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica JDBC Connection process/session id

@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?


  • 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;

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.