java.sql.SQLException: [Vertica][VJDBC](100023) Unexpected message type: ReadyForQuery

Dmitry_Meytin

Hello, I'm using c3po connection pool to upload the data to Vertica. I'm getting the following error sporadically. Please help! java.sql.SQLException: [Vertica][VJDBC](100023) Unexpected message type: ReadyForQuery. at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source) at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source) at com.vertica.core.VStatement.closeStatementOnServer(Unknown Source) at com.vertica.core.VStatement.close(Unknown Source) at com.vertica.jdbc.SStatement.close(Unknown Source) at com.vertica.jdbc.SPreparedStatement.close(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.close(NewProxyPreparedStatement.java:1811) at com.hp.maas.platform.logger.sink.VerticaSink.process(VerticaSink.java:154) at org.apache.flume.sink.DefaultSinkProcessor.process(DefaultSinkProcessor.java:68) at org.apache.flume.SinkRunner$PollingRunner.run(SinkRunner.java:147) Caused by: com.vertica.support.exceptions.GeneralException: [Vertica][VJDBC](100023) Unexpected message type: ReadyForQuery.

Tommaso_Motta

Hi, we have the same problem using Talend with JDBC driver 6.0:

Exception in component tVerticaOutput_3
java.sql.SQLException: [Vertica][VJDBC](100023) Unexpected message type: ReadyForQuery.
at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.jdbc.SPreparedStatement.<init>(Unknown Source)
at com.vertica.jdbc.VerticaPreparedStatementImpl.<init>(Unknown Source)
at com.vertica.jdbc.VJDBCObjectFactory.createPreparedStatement(Unknown Source)
at com.vertica.jdbc.SConnection.prepareStatement(Unknown Source)

Govardhan

Hello,

Is there any solution for the above error. Even i am receiving the same.

Regards
Govardhan