The SOLID database is a database from Solid Information Technology. AOLserver provides a database driver for the SOLID database. Since we no longer distribute Illustra, we recommend either the SOLID database or the Sybase database (see page 218) for use with AOLserver. SOLID is a reasonably-priced database that can be installed on many platforms. Temporary evalation copies can be downloaded from their web site, http://www.solidtech.com.
This database driver is installed in the same way as other database drivers. Use the Setup Server to add nssolid.so as a database driver. When you create a database pool for it, the correct format for the datasource is this:
TCP/IP hostname 1313
TCP/IP specifies the protocol with which the SOLID AOLServer driver will communicate with the SOLID database server. The hostname is the fully-qualified hostname on which the SOLID database server resides, and 1313 is the port on that server where it is listening.
If you're porting your database applications from Illustra to SOLID, you'll need to remove semicolons from the end of your SQL statements. Illustra accepted the semicolons, but did not require them. SOLID does not allow the semicolons.
If you are using the nssolid database driver on Solaris 2.5.1, you need to set the LD_PRELOAD environment variable as follows:
setenv LD_PRELOAD /usr/lib/libm.so.1
Note that the Solid database driver only works with nsdp under Irix.
Special thanks to Robert Locke for contributing the code for this module.