For up-to-date product documentation, see the IBM MobileFirst Foundation Developer Center.

Configure Liberty profile for Oracle manually for Application Center

We can set up and configure your Oracle database manually for Application Center with WebSphere® Application Server Liberty profile by adding the JAR file of the Oracle JDBC driver.

Before you begin

Before continuing, set up the Oracle database.

Procedure

1. Add the JAR file of the Oracle JDBC driver to $LIBERTY_HOME/wlp/usr/shared/resources/oracle.

   If that directory does not exist, create it.

2. If you are using JNDI, configure the data sources in the $LIBERTY_HOME/wlp/usr/servers/mobileFirstServer/server.xml file as shown in the following JNDI code example:

   Note: In this path, we can replace mobileFirstServer with the name of your server.

   <!-- Declare the jar files for Oracle access through JDBC. -->
   <library id="OracleLib">
     <fileset dir="${shared.resource.dir}/oracle" includes="*.jar"/>
   </library>
   
   <!-- Declare the IBM Application Center database. -->
   <dataSource jndiName="jdbc/AppCenterDS" transactional="false">
     <jdbcDriver libraryRef="OracleLib"/>
     <properties.oracle driverType="thin"
                        serverName="oserver" portNumber="1521"
                        databaseName="ORCL"
                        user="APPCENTER" password="APPCENTER_password"/>
   </dataSource>

   where

   • APPCENTER after user= is the user name,
   • APPCENTER_password after password= is this user's password, and
   • oserver is the host name of your Oracle server (for example, localhost if it is on the same machine).

   Note: For more information on how to connect the Liberty server to the Oracle database with a service name, or with a URL, see the WebSphere Application Server Liberty Core 8.5.5 documentation, section properties.oracle.

3. We can encrypt the database password with the securityUtility program in <liberty_install_dir>/bin.

What to do next

For more steps to configure Application Center, see Deploy the Application Center WAR files and configuring the application server manually.

Parent topic: Configure the Oracle database manually for IBM MobileFirst Platform Application Center