JDBC error 11800

Moderator: NorbertKrupa

Post Reply
angian
Newbie
Newbie
Posts: 1
Joined: Fri May 27, 2016 10:14 am

JDBC error 11800

Post by angian » Fri May 27, 2016 10:50 am

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.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: JDBC error 11800

Post by JimKnicely » Wed Sep 21, 2016 4:34 pm

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
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “JDBC”