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
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.