We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Vertica JDBC Connection process/session id — Vertica Forum

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?

Comments

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

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file