Hi All. I am not able to connect to Vertica via JDBC, always getting error:
An error occurred while calling z:java.lang.Class.forName. : java.lang.ClassNotFoundException:
com.vertica.jdbc.Driver at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
Environment:
hue v4.7;
Centos 7;
Vertica client and JDBC drivers are installed: vertica-jdbc-9.2.1-0.jar
CLASSPATH is set: export CLASSPATH=/opt/vertica/java/lib/vertica-jdbc-9.2.1-0.jar’
hue.ini:
[[[vertica]]]
name=Vertica
interface=jdbc
options=’{“url”: “jdbc:vertica://172.28.54.86:5433”, “driver”: “com.vertica.jdbc.Driver”, “user”: “xxx”, “password”: “yyy”}’