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?


  • Options
    Prasanta_PalPrasanta_Pal - Select Field - Employee
    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;

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