The solidDB JDBC Driver (SolidDriver2.0.jar) is installed during solidDB installation. You can verify the installation by using a sample Java program that is provided in the solidDB package. Depending on your environment, you might need to set various configuration settings before using the solidDB JDBC driver.
Default installation directory
The solidDB JDBC Driver is installed during the solidDB server installation into the jdbc directory.
If your application is on a different computer than the solidDB server, you must copy the JDBC driver file to the computer where the application is located.
Notes
▪ The jdbc directory also contains the solidDB Data Store Helper Class (SolidDataStoreHelper.jar) for use with IBM WebSphere Application Server.
▪ The samples/jdbc directory in the solidDB installation directory contains Java code samples that use the solidDB JDBC driver, see solidDB JDBC driver samples.
Requirements for Java environment
Before you start, check the following prerequisites:
▪ Ensure that you have a working Java runtime or development environment that supports JDBC API specification release 2.0.
▪ Check your Java environment documentation to see whether the environment can use compressed bytecode. The SolidDriver2.0.jar contains the solidDB JDBC Driver classes in compressed bytecode format that is usable by most Java virtual machines. However, some environments (such as Microsoft J++) require uncompressed bytecode. If your environment requires uncompressed bytecode, you must extract the SolidDriver2.0.jar file by using a tool that supports long file names.
▪ The CLASSPATH environment variable for your environment must include the installation path for the solidDB JDBC driver .jar file.
– On Windows
The installation adds the default solidDB JDBC Driver installation path to the system CLASSPATH environment variable automatically.
You can check and set the system CLASSPATH environment variable by using the Control Panel:
Control Panel > System > Advanced > Environment Variables
– On Linux and UNIX
Set your CLASSPATH environment variable to include the solidDB JDBC Driver (SolidDriver2.0.jar) installation path.
For example, in Bourne shell, use the following command:
If you are using a shell other than the Bourne shell, modify this command to make it appropriate for your shell.
Verifying the installation with sample1.java
The sample1.java sample application (available in the samples/jdbc directory) can be used for validating the solidDB JDBC driver installation, see solidDB JDBC driver samples.