Connecting Vertica to R through JDBC

Moderator: NorbertKrupa

Post Reply
shubham
Newbie
Newbie
Posts: 1
Joined: Fri Jul 06, 2018 7:51 am

Connecting Vertica to R through JDBC

Post by shubham » Fri Jul 06, 2018 8:00 am

Hi, 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](5273) FATAL:
Unsupported frontend protocol 3.8: server supports 3.0 to 3.6


Also i tried with all the client driver versions available on myVertica.com :

1)vertica-jdbc-9.1.0-0
2)vertica-jdbc-8.1.1-18
3)vertica-jdbc-8.0.1-6
4)vertica-jdbc-7.1.2-0
5)vertica-jdbc-7.2.3-0

Post Reply

Return to “JDBC”