Options
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?"
0
Answers
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.