Skip to main content

Issue with RJDBC

  • July 29, 2014
  • 1 reply
  • 10 views

vioravis
Forum|alt.badge.img+1
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



1 reply

vioravis
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • July 30, 2014
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.