JDBC Connection Pool
Please provide an example of how to initialise/setup a Vertica Connection Pool using JDBC/Java.
I would like to setup a Connection Pool (e.g. 10 connections) and run each connection in Parallal, executing multiple queries.
I see the following available in JDBC - can you provide an example on how to use it?
I've currently setup a single connection, but would like to use ConnectionPoolDataSource:
Properties myProp = new Properties();
conn = DriverManager.getConnection("jdbc:vertica:....etc...",myProp);