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

Configure Apache Tomcat for MySQL manually for Application Center

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

Complete the MySQL database setup procedure before continuing.

Procedure

1. Add the MySQL Connector/J JAR file to the $TOMCAT_HOME/lib directory.
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 Configure Apache Tomcat for Application Center manually.

     <Resource name="jdbc/AppCenterDS"
               auth="Container"
               type="javax.sql.DataSource"
               maxActive="100"
               maxIdle="30"
               maxWait="10000"
               username="worklight"
               password="worklight"
               driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://server:3306/APPCNTR"/>

Parent topic: Configure the MySQL database manually for Application Center