Skip to main content

Error Connecting to vertica using Jdbc

  • September 29, 2015
  • 1 reply
  • 9 views

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.

1 reply

Adrian_Oprea_1
Forum|alt.badge.img+1
  • Participating Frequently
  • September 30, 2015

 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