*After Install Tomcat7 need to confurigation in Tomcat7/conf*
/* Server.xml*/  (Put these <GlobalNamingResources>)

 <Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="10" jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;             org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;" jmxEnabled="true" logAbandoned="true" maxActive="100" maxWait="10000" minEvictableIdleTimeMillis="30000" minIdle="10" name="jdbc/EMRDBConnection" password="yarago123" removeAbandoned="true" removeAbandonedTimeout="60" testOnBorrow="true" testOnReturn="false" testWhileIdle="true" timeBetweenEvictionRunsMillis="30000" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/yghealthcarecombined?useUnicode=true&amp;characterEncoding=UTF-8" username="root" validationInterval="30000" validationQuery="SELECT 1"/>
          
          
          <!-- OPTHALSTOCK DB PROPERTIES-->
          
            <Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="10" jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;             org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;" jmxEnabled="true" logAbandoned="true" maxActive="100" maxWait="10000" minEvictableIdleTimeMillis="30000" minIdle="10" name="jdbc/OpthalDBConnection" password="yarago123" removeAbandoned="true" removeAbandonedTimeout="60" testOnBorrow="true" testOnReturn="false" testWhileIdle="true" timeBetweenEvictionRunsMillis="30000" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/ophthalstock?zeroDateTimeBehavior=convertToNull" username="root" validationInterval="30000" validationQuery="SELECT 1"/>
		  
		  <!-- OPTICAl DB PROPERTIES -->
		
		<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="10" jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;             org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;" jmxEnabled="true" logAbandoned="true" maxActive="100" maxWait="10000" minEvictableIdleTimeMillis="30000" minIdle="10" name="jdbc/OPTICALDBConnection" password="yarago123" removeAbandoned="true" removeAbandonedTimeout="60" testOnBorrow="true" testOnReturn="false" testWhileIdle="true" timeBetweenEvictionRunsMillis="30000" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/ygopticals?zeroDateTimeBehavior=convertToNull" username="root" validationInterval="30000" validationQuery="SELECT 1"/>

		<!-- PHARMACY DB PROPERTIES -->

		<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="10" jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;             org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;" jmxEnabled="true" logAbandoned="true" maxActive="100" maxWait="10000" minEvictableIdleTimeMillis="30000" minIdle="10" name="jdbc/PHARMADBConnection" password="yarago123" removeAbandoned="true" removeAbandonedTimeout="60" testOnBorrow="true" testOnReturn="false" testWhileIdle="true" timeBetweenEvictionRunsMillis="30000" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/ygpharmacy?zeroDateTimeBehavior=convertToNull" username="root" validationInterval="30000" validationQuery="SELECT 1"/>
		
<!-- Insurance DB Connection -->
		<Resource auth="Container"
			driverClassName="com.mysql.jdbc.Driver"
			factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
			initialSize="10"
			jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState; org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;"
			jmxEnabled="true" logAbandoned="true" maxActive="100" maxWait="10000"
			minEvictableIdleTimeMillis="30000" minIdle="10"
			name="jdbc/InsuranceDBConnection" password="yarago123"
			removeAbandoned="true" removeAbandonedTimeout="60"
			testOnBorrow="true" testOnReturn="false" testWhileIdle="true"
			timeBetweenEvictionRunsMillis="30000" type="javax.sql.DataSource"
			url="jdbc:mysql://localhost:3306/yginsurance?zeroDateTimeBehavior=convertToNull"
			username="root" validationInterval="30000" validationQuery="SELECT 1" />


/*tomcat-users.xml*/  (If User name password has been not created during install)
<user username="manager" password="123" roles="manager-gui" />


/*web.xml*/(Put these in <servlet> almost 244 line number)
<init-param>
            <param-name>mappedfile</param-name>
            <param-value>false</param-value>
        </init-param>
		
/*context.xml*/  (Put these in <Context>)
<ResourceLink name="jdbc/EMRDBConnection"
                global="jdbc/EMRDBConnection"
                auth="Container"
                type="javax.sql.DataSource" />
                 <ResourceLink name="jdbc/OpthalDBConnection"
                global="jdbc/OpthalDBConnection"
                auth="Container"
                type="javax.sql.DataSource" />
				<ResourceLink name="jdbc/OPTICALDBConnection"
                global="jdbc/OPTICALDBConnection"
                auth="Container"
                type="javax.sql.DataSource" />
                 <ResourceLink name="jdbc/PHARMADBConnection"
                global="jdbc/PHARMADBConnection"
                auth="Container"
                type="javax.sql.DataSource" />
<ResourceLink auth="Container"
		global="jdbc/InsuranceDBConnection" name="jdbc/InsuranceDBConnection"
		type="javax.sql.DataSource" />
				
				
/*bin*/   (Put mysql jar file under tomcat7 lib folder like C:\Program Files\Apache Software Foundation\Tomcat7\lib)