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