Jethro's JDBC driver allows BI applications, SQL query tools, and other applications supporting JDBC, to connect to a Jethro instance, using the JDBC APIs.
The following sections specify the steps required for the installation and configuration of Jethro's JDBC driver:
Jethro's JDBC driver can be downloaded from the drivers download page.
It comes as a zip file or a tar.gz, and it needs to be unzipped to a folder (not a temporary one).
All the JAR files of which this driver is composed of, must be available to the JDBC client.
Every tool has its own way to reach these files, but typically, the full path to reach them should be defined in the Java application CLASSPATH.
Once the driver is in the CLASSPATH, you'll need to cofigure the following parameters, that will establish the connectivity between the newly installed driver, and the proper Jethro server(s)&instance.
In addition, you will need to provide a user name and a password (default is jethro/jethro)
The URL parameter includes a connection string with one or more JethroServer network addresses (Specifying multiple addresses turns on client-side load balancing).
The path of the logs may change from one system to another, due to a dependency with its environment variables.
Normally, the logs would be found under:
If you can't find it, starting from JDBC 3.9, the path of the JDBC logs can be retrieved by using the following command:
java -cp <full-path-to-the-jar-file> LoggerPath For example: java -cp /home/jethro/jethro-jdbc-3.9-standalone.jar LoggerPath
Any general-purpose SQL query tool should work with Jethro. The instructions below refer to SQL Workbench/J, but other tools should work similarly.
To configure JethroServer to work with SQL Workbench:
The Manage drivers dialog box appears: