This article addresses an issue in which the JDBC Driver encounters an “Unknown Message Type” error when establishing a connection to an earlier version of Vertica, and provides the corresponding resolution.
Environment
- Vertica Analytics Database version 9.1 or earlier
- OpenText Analytics Database / Vertica JDBC Driver version 9.2 or later
Situation
When attempting to connect to Vertica version 7.2 using JDBC Driver version 23.3, the following exception is thrown:
java.sql.SQLException: [Vertica][VJDBC](100022) Unknown message type: .at com.vertica.io.ProtocolStream.receiveOneResponseMessage(Unknown Source)at com.vertica.io.ProtocolStream.readMessage(Unknown Source)at com.vertica.io.ProtocolStream.skipUntilReady(Unknown Source)at com.vertica.io.ProtocolStream.resetProtocolState(Unknown Source)at com.vertica.core.VConnection.handleError(Unknown Source)at com.vertica.dataengine.VQueryExecutor.handleExecuteResponse(Unknown Source)at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source)at com.vertica.jdbc.common.SStatement.executeNoParams(SStatement.java:3349)at com.vertica.jdbc.common.SStatement.executeNoParams(SStatement.java:3258)at com.vertica.jdbc.common.SStatement.executeQuery(SStatement.java:1160)at DBConnection.connect(DBConnection.java:10)
Find complete article on support portal
