Configuring Apache Tomcat for MySQL manually for Application Center

If you want to manually set up and configure your MySQL database for Application Center with the Apache Tomcat server, use the following 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 Configuring 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"/>