SOLVED - Help with Vertica connection

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

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"?>
<drivers>
 <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://"/>
</drivers>

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

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.

Thanks!


Answers

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