In R I have been using RJDBC on my local to connect to our Vertica cluster using:
> vdriver <- JDBC(driverClass="com.vertica.jdbc.Driver", classPath="C:/vertica-jdk5-6.1.2-0.jar")
vertica = dbConnect(vDriver, "jdbc:vertica://[server_name]:5433/[database]", "[uid]", "[password]")
For the past few days it has connected fine, & ran the desired queries.
However eventually I am get the following error:
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
I have verified that I am using the correct driver version and am able to connect with other tools such as DBeaver or DBVisualizer. Has anyone else had this issue? I have reinstalled RJDBC, used different R installations, restarted the system. nothing seems to work.
'RJDBC' was built under R version 2.15.3
R Version:
platform x86_64-pc-mingw32 arch x86_64
os mingw32
system x86_64, mingw32
status
major 2
minor 15.0
year 2012
month 03
day 30
svn rev 58871
language R
version.string R version 2.15.0 (2012-03-30)
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.
