squirel sql

To get a connection to the database

Name: Give any name

Driver:Mysql Driver

URL:jdbc:mysql://local host:port no/database name

User:root

Password:give the required pasword.


Before adding alias,add Mysql driver
Right click mysql driver->extra class path add mysql.jar
(mysql.jar added externally)
then give ok.

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

mysql

1)To know the instances that are running
mysqld_multi report

2)To start the instance
mysqld_multi start

3)To use the database in the instance
mysql -u demouser -p -h 192.168.1.88 -P 4007 qamart;

To run the process in tomcat server

1)Run the build.xml in the program
when u run a war file will be created in a folder.
ex:yumeetl.war will be created in the folder temp

2)Copy the war file and paste in the webapps folder

3)edit the log4configuration.xml whether the path is correctly denoted.
file:/home/sathish/tomcat/webapps/yumeetl/WEB-INF/classes/log4configuration.xml

4)copy and paste yumeetl.xml to /home/sathish/tomcat/conf/Catalina/localhost

5)edit server.xml whether url value is correct

6)Start the tomcat server

To start the process

execute queries in qadb.
truncate table and insert in QRTZ_TRIGGERS, QRTZ_CRONTRIGGERS, QRTZ_JOBDETAILS
update QRTZ_TRIGGERS,

To view log tail -100f yumeappserver.log
To remove rm*.

TOMCAT

TO START TOMCAT

1)Go to tomcat/bin.

2)Set environment variables

a) export JAVA_HOME=/usr/java/jdk1.6.0_03/
b)export CATALINA_HOME=/usr/local/tomcat

3)Enter the command to start
./startup.sh