The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Connecting Vertica to R through JDBC

edited July 2018 in General Discussion

Connecting Vertica to R through JDBC

I am trying to connect vertica database and access it with R.For this i came across ODBC and RJDBC. While moving forward with RJDBC , i installed all the client drivers and packages needed in R. The Vertica server has version 8.0.1 and client driver was 8.0.x for windows(I also tried in ubuntu with client drivers for the same) I also checked Java versions in both the platforms and it was 1.8.0_171. The error i am getting while making a connection with R is:

Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1], :
java.sql.SQLNonTransientConnectionException: [Vertica]VJDBC FATAL:
Unsupported frontend protocol 3.8: server supports 3.0 to 3.6

Also i tried with all the client driver versions available on

My code in R is:
drv <- JDBC(driverClass="com.vertica.jdbc.Driver",

conn <- dbConnect(drv, paste0("jdbc:vertica://",client.hostname,":5433/",client.dbname),user=client.username , password=client.password)


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file