The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Issue with RJDBC


I am trying to use RJDBC to connect R to Vertica 6.1.2 and have the corresponding JDBC driver zip file. I tried the following two commands:

drv <- JDBC("com.vertica.jdbc.Driver", "D:/")

conn <- dbConnect(drv, "jdbc:vertica://...//testdb?zeroDateTimeBehavior=convertToNull", "username", "password")

However, I get the following error when I try the second command:

Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1],  :   java.sql.SQLNonTransientConnectionException: [Vertica][VJDBC](5273) FATAL: Unsupported frontend protocol 3.4: server supports 3.0 to 3.3

The versions of Vertica and the JDBC driver match. I have used the same database and the corresponding driver a few months back and it worked fine. It suddenly stopped working. 

Could someone help me figure out what is causing this error?

Thank you.



  • Just found out what the issue is and fixed it. Apparently I had uninstalled Java version 6 recently and installed Java 8 in my system. I went back to Java version 6 and RJDBC is working fine now. It appears the higher versions of Java are not supported.

Leave a Comment

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