Vertica connection pool - VerticaCopyStream

Moderator: NorbertKrupa

Post Reply
aton
Newbie
Newbie
Posts: 1
Joined: Tue Jul 16, 2013 1:35 am

Vertica connection pool - VerticaCopyStream

Post by aton » Tue Jul 16, 2013 3:38 pm

Hi,

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.

Post Reply

Return to “JDBC”