"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?"
Question
My questions about JDBC connection
+1It'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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
