connection pooling - BoneCP with Vertica -

i tried using bonecp pool vertica connections running errors

[bonecp-pool-watch-thread-vertica pool] error com.jolbox.bonecp.poolwatchthread - error in trying obtain connection. retrying in 7000ms java.sql.sqlexception: [vertica][jdbc](11760) cannot call setreadonly while connection in transaction.     @ com.jolbox.bonecp.connectionhandle.setreadonly(connectionhandle.java:1279)     @ com.jolbox.bonecp.connectionhandle.<init>(connectionhandle.java:254)     @ com.jolbox.bonecp.connectionhandle.<init>(connectionhandle.java:185)     @ com.jolbox.bonecp.poolwatchthread.fillconnections(poolwatchthread.java:114)     @ com.jolbox.bonecp.poolwatchthread.run(poolwatchthread.java:81)     @ java.util.concurrent.threadpoolexecutor$worker.runtask(threadpoolexecutor.java:886)     @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:908)     @ java.lang.thread.run(thread.java:662) 

this code using

    bonecpconfig bvcp = new bonecpconfig();     class.forname("com.vertica.jdbc.driver");     bvcp.setpoolname("vertica pool");     bvcp.setdefaultreadonly(false);     bvcp.setjdbcurl("jdbc:vertica://vertica-server:5433/schema");     bvcp.setuser("username");     bvcp.setpassword("vertica-pwd");      bonecpdatasource bds = new bonecpdatasource(bvcp);      jdbctemplate template = new jdbctemplate(ds);      list<map<string, object>> ret = template                 .queryforlist("select * table1 "); 

i tried same code oracle , hsql , works fine.

this vertica jdbc driver 5.1.1 , bonecp 0.8.0-rc1

any appreciated.

this problem resolved after upgraded vertica jdbc driver 6.1.2

apparently in 5.1.1 transaction started after connection made.