Error Connecting to vertica using Jdbc

vivek789

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.

Adrian_Oprea_1

 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