Page 1 of 1

JDBC error 11800

Posted: Fri May 27, 2016 10:50 am
by angian
Hi all.
We are loading data into our Vertica db through a
SQL statement, feeded by a PipedInputStream.

Sporadically we get the following error:

2016-05-27 01:39:36.014 TE>> WARNING: pool-2-thread-8: error copying data [com.ti.serviceGuard.dataModel.values.dao.vertica.EntityStorageVertica$AsynchEntityManager$Writer$1 run()]
2016-05-27 01:39:36.014 TE>> java.sql.SQLException: [Vertica][JDBC](11800) Transaction callbacks are not allowed during explicit JDBC API transaction calls.
2016-05-27 01:39:36.014 TE>> at com.vertica.jdbc.common.SConnection.notifyBeginTransaction(Unknown Source)
2016-05-27 01:39:36.014 TE>> at com.vertica.jdbc.common.STransactionStateListener.notifyBeginTransaction(Unknown Source)
2016-05-27 01:39:36.014 TE>> at com.vertica.jdbc.VerticaCopyStream.start(Unknown Source)

2016-05-27 01:39:36.014 TE>> at com.ti.serviceGuard.dataModel.values.dao.vertica.EntityStorageVertica$AsynchEntityManager$Writer$

Does anybody know what that means? How comes it is not deterministic? How can I fix it?
Thank you.

Re: JDBC error 11800

Posted: Wed Sep 21, 2016 4:34 pm
by JimKnicely

You might be getting this error because the version of the Vertica JDBC driver you are using does not support Multiple Active Result Sets (MARS). This feature was added in version 7.2.x.

If this is the case, check out the documentation here: ... ltSets.htm