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


Configure Apache Tomcat for Oracle manually for Application Center

If we want to manually set up and configure your Oracle database for Application Center with the Apache Tomcat server, use the following procedure.


Overview

Complete the Oracle database setup procedure before continuing.


Procedure

  1. Add the Oracle JDBC driver JAR file to the directory $TOMCAT_HOME/lib.
  2. Prepare an XML statement that defines the data source, as shown in the following code example. Insert this statement in the server.xml file, as indicated in Configuring Apache Tomcat for Application Center manually

    <Resource name="jdbc/AppCenterDS" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@oserver:1521:ORCL" username="APPCENTER" password="APPCENTER_password"/>

    Where APPCENTER after username= is the name of the system user with "CONNECT" access to the APPCNTR database that you have previously created, and APPCENTER_password after password= is this user's password. If you have defined either a different user name, or a different password, or both, replace these values accordingly.

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