The solidDB® JDBC Driver (SolidDriver2.0.jar) is installed during solidDB® server installation. Depending on your environment, you might need to set various configuration settings before you use 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.
▪The jdbc directory contains also the solidDB® Data Store Helper Class (SolidDataStoreHelper.jar) for use with WebSphere.
▪The samples/jdbc directory in the solidDB® installation directory contains Java code samples that use the solidDB® JDBC Driver. Instructions for running the sample are available in the readme.txt file, which is available in the same directory.
Requirements for Java environment
▪Ensure that you have a working Java runtime or development environment that supports JDBC API specification release 2.0.
▪Check from your Java environment documentation whether it can use compressed bytecode. The SolidDriver2.0.jar contains the solidDB® JDBC Driver classes in compressed bytecode format 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.
Setting the CLASSPATH environmental variable
The CLASSPATH environment variable for your environment must include the solidDB® JDBC Driver .jar file installation path.
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 through the Control Panel: Control Panel > System > Advanced > Environment Variables
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: