some changes in tomcat

[cit146@cit146 bin]$ export JAVA_HOME=/usr/java/jdk1.6.0_03/

[cit146@cit146 bin]$ export CATALINA_HOME=/home/cit146/software/apache-tomcat-5.5.20/

export CLASSPATH=/home/cit146/software/apache-tomcat-5.5.20/common/lib/servlet-api.jar

[cit146@cit146 bin]$ ./startup.sh
Using CATALINA_BASE: /home/cit146/software/apache-tomcat-5.5.20/
Using CATALINA_HOME: /home/cit146/software/apache-tomcat-5.5.20/
Using CATALINA_TMPDIR: /home/cit146/software/apache-tomcat-5.5.20//temp
Using JRE_HOME: /usr/java/jdk1.6.0_03/
[cit146@cit146 bin]$



paste yumemetl.war from home/cit146/dist to /home/cit146/software/apache-tomcat-5.5.20/webapps

paste yumeetl.xml in /home/cit146/software/apache-tomcat-5.5.20/conf/Catalina/localhost


edit server.xml in /home/cit146/software/apache-tomcat-5.5.20/conf [url values]


paste mysql.jar in /home/cit146/software/apache-tomcat-5.5.20/common/lib


edit log4jconfiguratio.xml and quartz.properties /home/cit146/software/apache-tomcat-5.5.20/webapps/yumeetl/WEB-INF/classes
[ * change param value="[%d] [%t] %-5p %c %X{processid} - %m%n"
* (if u want show the output) ]

insert export CATALINA_OPTS="-Dlog4j.configuration=log4jconfiguration.xml" in catalina.sh (before # Get standard environment variables PRGDIR=`dirname "$PRG"`)



Firing process
----------------------


First truncate the following table

delete from QRTZ_CRON_TRIGGERS where TRIGGER_NAME='com.yumecorp.etl.martcleanup_process';
delete from QRTZ_TRIGGERS where TRIGGER_NAME ='com.yumecorp.etl.martcleanup_process';
delete from QRTZ_JOB_DETAILS where JOB_NAME='com.yumecorp.etl.martcleanup_process';

insert into quartz_job_details,quartz_cron_triggers, qyartz_triggers

for eg,

INSERT INTO QRTZ_JOB_DETAILS (JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, REQUESTS_RECOVERY, JOB_DATA) VALUES
('com.yumecorp.etl.martcleanup_process', 'com.yumecorp.etl', NULL, 'com.yumecorp.etl.ETLProcessJob', 0, 0, 0, 0, 'jndiName=java:comp/env/jdbc/yume\nmartjndi=yumemart\nportaldb=qadb\nfilePath=martcleanup_etlprocess.xml');

INSERT INTO QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP, JOB_NAME, JOB_GROUP, IS_VOLATILE, DESCRIPTION, NEXT_FIRE_TIME, PREV_FIRE_TIME, TRIGGER_STATE, TRIGGER_TYPE, START_TIME, END_TIME, CALENDAR_NAME, MISFIRE_INSTR, JOB_DATA) VALUES
('com.yumecorp.etl.martcleanup_process', 'com.yumecorp.etl', 'com.yumecorp.etl.martcleanup_process', 'com.yumecorp.etl', 0, NULL, -1, -1, "WAITING", "CRON", -1, 0, NULL, 0, NULL);

INSERT INTO QRTZ_CRON_TRIGGERS(TRIGGER_NAME, TRIGGER_GROUP, CRON_EXPRESSION,TIME_ZONE_ID) VALUES
('com.yumecorp.etl.martcleanup_process', 'com.yumecorp.etl', '0 15,45 * * * ?', NULL);

Mis Fire
-------------

update QRTZ_TRIGGERS set NEXT_FIRE_TIME=-1 where TRIGGER_NAME='com.yumecorp.etl.martcleanup_process';


show the output in
/home/cit146/software/apache-tomcat-5.5.20/bin/yumeappserver.log