My questions about JDBC connection

guadalupefrazierguadalupefrazier
in General Discussion

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

Answers

  • 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...