Home
Discussions
Community Q&A
SOLVED - Help with Vertica connection
dazz
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!
Find more posts tagged with
AI Studio
Accepted answers
All comments
dazz
Got it to work..needed to restart RapidMiner
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)