JDBC Driver Details
- Virtuoso JDBC Driver Information Page
- About Virtuoso JDBC 4.1 Driver JAR File
- About Virtuoso JDBC 4.1 TLS Driver JAR File
- Driver Name: virtuoso.jdbc4.Driver
- JAR File Location, following installation on macOS: /Library/Java/Extensions/virtjdbc4.jar
Steps:
-
Determine docker container virtual folder to which physical folder “/Library/Java/Extensions/virtjdbc4.jar” (or some alternative) is to be mapped e.g., “/virtjdbc4.jar”
-
Start Zeppelin Docker Image using -v /Library/Java/Extensions/virtjdbc4.jar:/virtjdbc4.jar
docker run -p 8080:8080 -v /Library/Java/Extensions/virtjdbc4.jar:/virtjdbc4.jar --rm --name zeppelin apache/zeppelin:0.8.1
- Configure custom Virtuoso Interpreter for group “jdbc” via “http://localhost:8080/#/interpreter” UI
Once configured, you can inject SQL into notebook paragraphs that return contents in tables, graphs etc…
As per usual, the final challenge is figuring out how to make HTTP URIs live hyperlinks within these notebooks.
Related