Running vertica 9.0.0-2 using latest JDBC driver 9.0.x with Java 8.
We get a connection from our tomcat pool, we perform a number of operations ending with two batch inserts followed by a commit (batches are fairly small first < 100, second < 1000). Then on closing the connection to add back to connection pool we get the following stack overflow exception.
Have tried reproducing on our test system, but have been unable to. However on our production system with the same data set it was very repeatable.
Exception in thread "Thread-4" java.lang.StackOverflowError
at com.vertica.core.VConnection.getStreamingBatchInsert(Unknown Source)
at com.vertica.jdbc.VerticaStatementSharedImpl.validateClearBatch(Unknown Source)
at com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.clearBatch(Unknown Source)
at com.vertica.jdbc.common.SPreparedStatement.close(Unknown Source)
at com.vertica.jdbc.common.SStatement.checkIfOpen(Unknown Source)
at com.vertica.jdbc.common.SPreparedStatement.clearBatch(Unknown Source)
at com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.clearBatch(Unknown Source)
at com.vertica.jdbc.common.SPreparedStatement.close(Unknown Source)
at com.vertica.jdbc.common.SStatement.checkIfOpen(Unknown Source)
.... repeats ...