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
COPY %s FROM STDIN
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$1.run(EntityStorageVertica.java:484)

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
Hi,

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:
https://my.vertica.com/docs/7.2.x/HTML/ ... ltSets.htm