We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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

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.

Comments

  • 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)


  • Hello,

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

    Regards
    Govardhan

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file