No suitable driver found for jdbc:vertica

BHIFP

Using the following in a makefile to create a .jar on one of EON nodes, while /opt/vertica/java/vertica-jdbc.jar does exist, I still got
error code: 123
No suitable driver found for jdbc:vertica

$(BUILD_DIR)/JavaTransformLib.jar : src/main/java/tech/xxxx/.java $(JAVA_BUILDINFO) $(BUILD_DIR)/.exists
-rm -rf $(BUILD_DIR)/JavaTransformLib
mkdir $(BUILD_DIR)/JavaTransformLib
$(JAVAC) -g -cp $(SDK_JAR)/bin/VerticaSDK.jar $(JAVA_BUILDINFO) -d $(BUILD_DIR)/JavaTransformLib
cd src/main/java; $(JAVAC) -g -cp $(SDK_JAR)/java/vertica-jdbc.jar:$(SDK_JAR)/bin/VerticaSDK.jar tech/xxxx/.java -d $(BUILD_DIR)/JavaTransformLib
cd $(BUILD_DIR)/JavaTransformLib; $(JAR) cf $(BUILD_DIR)/JavaTransformLib.jar .

We are running EON 10.1.1-6
Any idea why? Thanks

BHIFP

Answered by our SA:

Makefile will not work because it doesn’t copy the vertica-jdbc.jar to the server nodes.

Please see the example at https://www.vertica.com/docs/11.0.x/HTML/Content/Authoring/SQLReferenceManual/Statements/CREATELIBRARY.htm

You will need to use DEPENDS to add vertica-jdbc.jar to the classpath, e.g.:

CREATE LIBRARY mylib AS '/path/to/java_udx'
DEPENDS '/path/to/jars/vertica-jdbc.jar:/path/to/jars/that.jar' LANGUAGE 'Java';