DbSchema is connecting to Vertica using JDBC Drivers.
What are JDBC Drivers?
JDBC drivers are Java library files with the extension '.jar', used by Java applications to connect to the database.
Usually they are provided by the same company which developed the database software.
DbSchema is an Vertica Client which already includes
the Vertica JDBC driver. DbSchema can configure the Vertica JDBC URL and test the connectivity.
What is the JDBC URL?
The URL is a string (text) with a specific format containing information about the host where the database is running, the port, username, database name, etc.
The URL format is specific to each driver.
Any wrong character in the URL may make the database connectivity fail.
Therefore we recommend installing DbSchema and try to get connected, and you will find the JDBC URL in the connection dialog.
Driver Information
- Required File(s):vertica_5.1.4_jdk_5.jar
- Java Driver Class: com.vertica.jdbc.Driver
- URL: jdbc:vertica://HOST:PORT/DB
- Website: Vertica
Download Vertica JDBC Driver
The driver files are compressed in a zip file.
for any issues with the driver, you can write to us.