java.sql.SQLNonTransientConnectionException: [Vertica][VJDBC](5273) FATAL:
Unsupported frontend protocol 3.8: server supports 3.0 to 3.6.
This is the error i am getting and the code for this script is :
drv <- JDBC(driverClass="com.vertica.jdbc.Driver",
classPath="C:/Users/sbiswas/Downloads/vertica-jdbc-9.1.0-0.jar")
conn <- dbConnect(drv, paste0("jdbc:vertica://",client.hostname,":5433/",client.dbname)
,user=client.username , password=client.password)
result <- paste0("SELECT * FROM ",paste0(client.table_name),sep="")
temp <- dbGetQuery(conn,result)