Skip to main content

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

  • September 2, 2013
  • 2 replies
  • 18 views
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.

    2 replies

    Tommaso_Motta
    • Tommaso_Motta
    • New Participant
    • November 11, 2013
    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
    • Govardhan
    • New Participant
    • July 16, 2014
    Hello,

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

    Regards
    Govardhan
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement