Issue with RJDBC

vioravis

Hi,

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:/vertica-jdk5-6.1.2-0.zip")

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.

Ravi

vioravis

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.