Error Connecting to vertica using Jdbc
Could not connect to database.
java.sql.SQLException: No suitable driver found for jdbc:vertica://xxxxxxxxxxxxxx:5433/xxxxxxxx/
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at vertica.JdbctoVertica.main(JdbctoVertica.java:45)
I am trying to connect to the remote vertica db using jdbc driver. I gave the righjt jar, but still i am facing this error. i can connect the vertica with DBvisualizer. Could you please guide me in fixing the issue. Thanks in advance.
0
Comments
Try to create and odbc connection and point to the right vertica driver.if this works then jdbc should work as well.
Here is a small how to create and odbc conneciton step by step