Chapter 4. Installing Libraries

As a first step you must install the openMDX and the database libraries and make them available to WebSphere. You can do this by navigating to Environment > Manage WebSphere Variables.

openMDX. Add a new variable by clicking new and add the entry with name OPENMDX_HOME and value ${WAS_INSTALL_ROOT}/openmdx/lib as shown in Figure 4-1
Database. For most databases there already exist corresponding environment variables. However, the value must be adapted to your environment. E.g. the Jdbc driver for Microsoft SQL Server 2000 should have the name MSSQLSERVER_JDBC_DRIVER_PATH and e.g. the value C:\pgm\Microsoft SQL Server 2000 Driver for JDBC\lib.

Figure 4-1. Add OPENMDX_HOME as WebSphere variable.

enlarge

So far you only have created the environment variables. You now must copy the required libraries to the directories that you have configured, e.g.

openMDX - Step 1. Copy the libraries openmdx-kernel.jar, openmdx-base.jar and openmdx-application.jar to the directory OPENMDX_HOME, e.g. C:\pgm\WebSphere\AppServer\openmdx\lib. Create the directory if it does not exist.
openMDX - Step 2. Copy the library openmdx-kernel.jar to the directory WebSphere\AppServer\lib\ext. The library is required by the WebSphere RMIC compiler when you deploy the EARs.
Database. Copy the libraries msbase.jar, mssqlserver.jar, msutil.jar to the directory MSSQLSERVER_JDBC_DRIVER_PATH, e.g. C:\pgm\Microsoft SQL Server 2000 Driver for JDBC\lib.

Save the changes you have made so far.

Make sure that you copy the library openmdx-kernel.jar to the directory WebSphere\AppServer\lib\ext. Otherwise the deployment of the openCRX applications will fail.