JDBC Connection Pool

verticarulez

Hi,

 

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?

     javax.sql.ConnectionPoolDataSource

 

I've currently setup a single connection, but would like to use ConnectionPoolDataSource:

 

Connection conn; 

Properties myProp = new Properties();

myProp.put("user", "n");

myProp.put("password", "t");

myProp.put("loginTimeout", "60");

myProp.put("binaryBatchInsert", "true");

 

conn = DriverManager.getConnection("jdbc:vertica:....etc...",myProp);

 

 

Thanks,

Amrit