We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Issue with RJDBC — Vertica Forum

Issue with RJDBC

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



Comments

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file