SOLVED - Help with Vertica connection

dazzdazz Member Posts: 2 Contributor I
edited November 2018 in Help

I have added a Vertica Database driver, and the jdbc_properties.xml file in C:\users\<user name>\  now shows the following:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
 <driver dbnameseparator="/" defaultport="5433" driver_jar="C:\Program Files (x86)\Vertica Systems\JDBC\vertica-jdk5-6.0.2-0.jar" drivers="com.vertica.jdbc.Driver" name="Vertica" urlprefix="jdbc:vertica://"/>

When I go to 'Manage Database Connections', and add a database connection, the URL defaults to  jdbc:vertica://
But when I click on 'Test Connection', it gives
"No suitable driver found for jdbc:vertica:// "

Will appreciate any help. I have successfully tested this same driver in "C:\Program Files (x86)\Vertica Systems\JDBC\vertica-jdk5-6.0.2-0.jar"  in DBVisualizer application.



  • Options
    dazzdazz Member Posts: 2 Contributor I
    Got it to work..needed to restart RapidMiner :\
Sign In or Register to comment.