Tuesday, December 30, 2008

cvs

To do the checkout process in windows:
Before start checking out in windows system,the directory must be configured in the cvs by the cvs admin.

The file must be marked as binary in the cvs

To mark a file as binary:

cvs admin -kb name_of_binary_file

Tuesday, December 16, 2008

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


Thursday, December 4, 2008

124 error

solution

1) Dont done a operation in empty table

2) One time u got this error , u will go to a another insatnce

Ant

Ant

Apache Ant is a software tool for automating software build processes. It is similar to make but is implemented using the Java language, requires the Java platform, and is best suited to building Java projects.


The most immediately noticeable difference between Ant and make is that Ant uses XML to describe the build process and its dependencies, whereas make has its Makefile format. By default the XML file is named build.xml.


Why another build tool when there is already make, gnumake, nmake, jam, and others? Because all those tools have limitations that Ant's original author couldn't live with when developing software across multiple platforms. Make-like tools are inherently shell-based: they evaluate a set of dependencies, then execute commands not unlike what you would issue on a shell. This means that you can easily extend these tools by using or writing any program for the OS that you are working on; however, this also means that you limit yourself to the OS, or at least the OS type, such as Unix, that you are working on.

Linux commands for mysql

tail -100f catalina.out
less catalina.out
----> to show the file (eg.catalina.out)


cat>f.name (press enter and ctrl+c) -->cleanup process

../bin/startup.sh instead of cd .., cd /bin/startup.sh

cp /home/cit146/Ayyachamy/pro/yumeetl/tmp/yumemetl_27_11_2008_04_13_binary.jar --> curent location to /home/cit146.......


rm -rf catalina.OUT ---> remove a file

cat server.xml | grep "grep used for searching purpose

cat server.xml | grep "wc -l

ps -ef | grep tomcat --->show how many tomcat are running

kill -9 8738

88]# scp server.xml root@192.168.1.146:/usr/local ---> copy a server.xml from 192.168.1.88 to 192.168.1.146

mysql>show processlist --> How many process ran in the current databas