The solidDB JDBC driver is installed during the installation of the solidDB server. Depending on your environment, you might need to set various configuration settings before you use the solidDB JDBC driver.
The installation package also includes the solidDB JDBC driver as a separate JAR file so that you can install only the JDBC drivers.
Default installation directory
The solidDB JDBC driver is installed into the jdbc directory.
If your application is on a different computer from the solidDB server, you must copy the JDBC driver file to the computer where the application is located.
▪ 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. 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 whether your Java environment 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: