6.0 JDBC driver cannot connect to 5.1.5 server, front end protocol error

We are trying to upgrade our drivers to 6.0, while having most of databases on 5.1.5. Attempt to connect from JDBC 6.0 to 5.1.5 produces error. Is this expected behavior? vsql 6.0 connect to 5.1.5 just fine.

Output from 5.0 Drivers:
Vertica Database v5.1.5-0 Vertica JDBC Driver Vertica JDBC Driver 4.1.17

Output from 5.1 Drivers:
Vertica Database 05.01.0005 vertica.jar 05.01.0005

Output from 6.0 Drivers:
An error occurred while establishing the connection:
Long Message: [Vertica][VJDBC](100081) FATAL: unsupported frontend protocol 3.3: server supports 3.0 to 3.2

Type: java.sql.SQLException    Error Code: 100081    SQL State: HY000

Per the docs (Programmers Guide, Client Driver and Server Version Compatibility page - http://my.vertica.com/docs/6.0.0/HTML/index.htm#16472.htm) the 6.0 drivers are only compatible with version 6.0 server. The older drivers are forward compatible but the newer are not backward compatible.Anytime you see the "unsupported front end protocol" error it's an indication of a mismatch between driver and server.

Leave a Comment

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