Configuring SDO for relational databases on WebSphere Portal 5.1

In order to leverage the JDBC mediator for SDO while developing portlets that use the Relational Record or Relational List data components, there are specific steps that you must complete to enable the capability on a remote portal server or the WebSphere® Portal 5.1 Test Environment.

Depending on whether you require SDO JDBC support on a remote server and/or the test environment, follow one or both of these sets of instructions:
  1. To install the SDO JDBC mediator on a remote WebSphere Portal 5.1 server, visit the IBM® WebSphere Portal and Lotus® WebSphere Catalog site. Download the "SDO JDBC Mediator for Portal 5.1" package, and follow the instructions on how to install it.
  2. To set up the mediator to run in the local WebSphere Portal 5.1 Test Environment, follow these steps:
    1. In the Servers view, open the server instance that is defined for the WebSphere Portal 5.1 Test Environment.
    2. In the Server editor, select the Portal tab.
    3. In the Shared Library section, click the Add External JARs button.
    4. Locate jdbcmediator.jar in your Rational® product installation, and click Open. The file should be located in a path that includes: ~\runtimes\base_v6_stub\lib. The JAR file is added to the Shared Library list.
    5. Save the server configuration file. A new library, TestEnvironmentLib to be created and added to the application classloader, along with the SDOMediatorsLib library. This will provide the appropriate runtime library for SDOs using relational databases.
You can post questions and feedback about this configuration in the Rational tools newsgroups. Newsgroups can be accessed from Support Links in the Support Assistant, available by selecting the Help > IBM Support Assistant menu option.
Related tasks
Testing and debugging portlets
Defining local servers for testing portlets
Associating servers with projects
Accessing EIS data using WPAI SDO
Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.