Jboss port changes : 1. Goto the deploy folder of the server instance you use. 2. Goto the jbossweb-tomcat55.sar inside that deploy folder. 3. Find the file named server.xml inside that folder. (tomcat service file).
SELECT s.total,temp.code ,s.subject_id,temp.academicRecord_id,temp.examDate,temp.TYPE,temp.educationLevel_id FROM school_ilms.subjectresult s RIGHT JOIN ( (SELECT er.id,e.code,er.academicRecord_id,er.examDate,e.TYPE ,e.educationLevel_id FROM school_ilms.exam e RIGHT JOIN (school_ilms.examresult er ) ON (e.id=er.exam_id) WHERE e.TYPE='G' OR e.type='S') AS temp) ON(s.examResult_id=temp.id);
This is configuring the tomcats : making one tomcat into base and run remaining instances CATALINA_BASE=/home/stp/tomcat8080 /usr/apache-tomcat-6.0.20/bin/catalina.sh start tail -f tomcat8080/logs/catalina.out COPY FILE FROM CONF cp /usr/apache-tomcat-6.0.20/conf/* tomcat8080/conf/ TO EDIT THE SERVER.XML IN TOMCATS for i in 1 2; do sed -e s/8080/808$i/g -e s/8005/$((8005+$i*100))/g -e s/8009/$((8009+$i*100))/g conf/server.xml > tomcat808$i/conf/server.xml ; done CREATE TOMCAT INSTANCES for i in 1 2; do cp -r tomcat8080 tomcat808$i; done TO COPY THE CONF FILE INTO TOMCATS cp tomcat8080/conf/server.xml conf/