Backend-Tomcat

JDBC Driver

Copy JDBC Driver:mysql-connector-java-5.1.20-bin.jar to /usr/local/apache-tomcat-7.0.55/lib

Config Database Connection

Config DBCP(Data Base Connection Pool) in /usr/local/apache-tomcat-7.0.55/conf/server.xml put the following contents to Host component.

<Context path="/NepenthesDemo" docBase="NepenthesDemo"  debug="5" reloadable="true" crossContext="true">
                   <Resource name="jdbc/NepenthesDemo" auth="Container" type="javax.sql.DataSource"
                   maxActive="50" maxIdle="30" maxWait="10000"
                   username="root" password="" driverClassName="com.mysql.jdbc.Driver"
                   url="jdbc:mysql://localhost:3306/NepenthesDemo?autoReconnect=true"/>
               </Context>

Create Web Application

Open Terminal and execute the following commands to open Finder navigated to the specified location.

cd /usr/local/apache-tomcat-7.0.55/webapps
open -a Finder .

Create folder NepenthesDemo under /usr/local/apache-tomcat-7.0.55/webapps

Create folder WEB-INF under /usr/local/apache-tomcat-7.0.55/webapps/NepenthesDemo

Create folder lib under /usr/local/apache-tomcat-7.0.55/webapps/NepenthesDemo/WEB-INF

Copy the following libs to /usr/local/apache-tomcat-7.0.55/webapps/NepenthesDemo/WEB-INF/lib

commons-email-1.4.jar

commons-fileupload-1.1.jar

commons-io-1.2.jar

jackson-annotations-2.0.6.jar

jackson-core-2.0.6.jar

jackson-databind-2.0.6.jar

javax.mail.jar

nepenthes-3.0.jar

Create web.xml file with the following content and save to /usr/local/apache-tomcat-7.0.55/webapps/NepenthesDemo/WEB-INF

<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4">
  <display-name>NepenthesDemo</display-name>
  <description>Welcome to NepenthesDemo</description>
  <context-param>
      <param-name>DBCP</param-name>
      <param-value>jdbc/NepenthesDemo</param-value>
  </context-param>
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/NepenthesDemo</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>
 </web-app>

Conclusion

Now you have finished Tomcat configuration linked with MySQL database. In order to make the new web application working properly,make sure to shutdown Tomcat and start it again. Then visit http://localhost:8088,if there is no error,that means your configuration is correct.

cd /usr/local/apache-tomcat-7.0.55/bin
sudo ./shutdown.sh
sudo ./startup.sh

Next:Create Service