Anyone has experience with a java connection pool (outside from a J2EE container) that provides raw Vertica connections? I tried to use the VerticaCopyStream object which receives as input a VerticaConnection. But the connection pools: c3p0, DBCP and BoneCP create a proxy over the database connection causing an class cast exception during the casting to a VerticaConnection.
VerticaCopyStream stream = new VerticaCopyStream((VerticaConnection)ds.getConnection() , copy.build())
If a use the DriverManagerDataSource from Spring, I can create the VerticaConnection but according Spring docs: "This class is not an actual connection pool; it does not actually pool Connections."
Any help will be appreciated.