My questions about JDBC connection

"Hello, I've observed that a JDBC Connection can only process one statement at a time, with the subsequent statement waiting for the previous one to complete.I believe this behavior might be due to the JDBC connection utilizing a single session_id in Vertica. Therefore, my questions are:
Can Vertica execute multiple queries concurrently within a single session?
Is it possible for the SESSIONS table in Vertica to hold multiple transactions for a single session?"


  • Options
    marcothesanemarcothesane - Select Field - Administrator

    It's one connection one active SQL statement.

    But it's JDBC; Java is good at multi threading; Vertica is good at managing a great number of active connections. Just connect your Java/JDBC application as many times as you want concurrent SQL statements running.

Leave a Comment

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