Configuring and using the Oracle JDBC driverAdded by IBM on October 1, 2012 | Version 1 (Original)
|After you have fully installed IBM® Mobile Portal Accelerator and performed any migration tasks, you can configure WebSphere® Portal and Multi-Channel Server (MCS) to use the appropriate Oracle JDBC driver so that it can communicate with your Oracle database. (Refer to the topic Software requirements for a list of supported versions.)
Follow these steps to configure WebSphere
Portal and MCS to use the appropriate Oracle JDBC driver so that it can communicate with your supported Oracle database.
- Download the Oracle JDBC driver from the Oracle JDBC Drivers Downloads web page.
Place the JAR file in a directory on your WebSphere Portal server.
- The JDBC driver for Oracle Release 188.8.131.52 is ojdbc6.jar.
Note: If you are configuring within a cluster, place the JAR file on every node in the cluster. Add the JAR file to the CLASSPATH on each node.
Add the Oracle JDBC driver to the Java™ Virtual Machine (JVM) classpath of the WebSphere Portal server and remove the previous Oracle driver from the JVM classpath.
Edit wp_root/wp.mobile/wp.mobile.mcs/repository/bin/ImportPolicies.sh as follows:
Update the JVM classpath as follows:
- Log in to the WebSphere Application Server Integrated Solutions Console.
- Click Servers -> Application Servers.
- Click the name of your WebSphere Portal server.
- Under Server Infrastructure, click Java and Process Management, and then click the Process Definition link.
- Under Additional Properties, click the Java Virtual Machine link.
- In the Classpath field, delete the entry for your previous Oracle JDBC driver and add an entry for the new Oracle JDBC driver using the following command:
oracle_driver_path is the directory path for the Oracle JDBC driver on the WebSphere Portal server
oracle_JDBC_driver_name is the JDBC driver filename
- Click Apply.
- Save the configuration changes.
If you have a profile or script that sets the JDBC_DRIVER environment variable, modify it to specify the path to the new Oracle JDBC driver in place of the previous Oracle JDBC driver.
Restart the portal server using the following commands:
- Add the path to the Oracle JDBC driver to the end of the CLASSPATH= line.
- Remove the path to the previous Oracle JDBC driver file.
Parent topic: Configuring
Hardware and software requirements
[[Variable names used in the information center for user supplied informationmpa8|wp_profile_root]]/bin/stopServer.sh server_name -username WAS_admin -password WAS_admin_password_value
[[Variable names used in the information center for user supplied informationmpa8|wp_profile_root]]/bin/startServer.sh server_name
[[Variable names used in the information center for user supplied informationmpa8|wp_profile_root]]\bin\stopServer server_name -username WAS_admin -password WAS_admin_password_value
[[Variable names used in the information center for user supplied informationmpa8|wp_profile_root]]\bin\startServer server_name
is the name of the WebSphere
Application Server instance (for example, WebSphere_Portal