<user name="raju" password="raju" roles="admin,manager" />Tags:Problem Logging into Tomcat, Tomcat Manager access denaid, Can't logging into Tomcat webserver, Unable to logging into tomcat manager
Posted by Nagaraju Veeranala at 11:31 AM 0 comments
The table script and data script for employee, dept, salgarade is available at DB Script
A: Select * from dept
A: Select * from emp
A: Select ename, job from emp
A: Select ename, sal from emp
A: Select empno, sal+nvl(comm, 0) from emp
A: Select ename, 12*sal as annualsal from emp
A: Select ename from emp where deptno=10
A: Select ename from emp where job='CLERK' and sal > 1000
A: Select empno, ename from emp where comm is not null
A: Select ename from emp where comm is null
A: Select ename from emp where job in ('CLERK','SALESMAN','ANALYST') and sal>2000
A: Select ename from emp where (months_between(sysdate, hiredate)/12)>30
A: Select ename from emp where (hiredate < '30-Jun-90') or hiredate > '31-JUN-90'
A: Select sysdate from dual
A: Select ename from emp where deptno in (10,20,40) or job in('CLERK','SALESMAN','ANALYST')
A: Select ename from emp where ename like 'S%'
A: Select ename from emp where ename like '%S'
A: Select ename from emp where ename like '_A%'
A: Select ename from emp where length(ename)=5
OR
A: Select ename from emp where ename like '_____'
A: Select * from emp where job <> 'MANAGER'
OR
A: Select * from emp where job != 'MANAGER'
A: Select * from emp where job not in ( 'SALESMAN','ANALYST','CLERK')
A: Select count(*) from emp
A: Select sum(sal)+sum(nvl(comm,0)) totalSAL from emp
A: Select max(sal) from emp
A: Select min(sal) from emp
A: Select avg(sal) from emp
A: Select max(sal) from emp where job=’CLERK’
A: Select max(sal) from emp where deptno=20
A: Select min(sal) from emp where job=’SALESMAN’
A: Select avg(sal) from emp where job=’MANAGER’
A: Select sum(sal) from emp where deptno=20 and job='ANALYST'
A: Select ename from emp order by sal
A: Select ename from emp order by sal desc
A: Select * from emp order by ename
A: Select empno,ename,deptno,sal from emp order by ename,deptno,sal
A: Select ename, (sal*12) from emp
A: Select ename,(sal*15)/100 hra,(sal*10)/100 da,(sal*5)/100 pf, (sal*(sal*0.15)*(sal*0.10))-sal*0.05 totalsalary from emp
A: Select DEPTNO,count(DEPTNO) from emp group by deptno
A: Select job,count(job) from emp group by job
A: Select deptno, sum(sal) totalsal from emp group by deptno
A: Select deptno, max(sal) maxsal from emp group by deptno
A: Select job, sum(sal) totalsal from emp group by job
A: Select job, min(sal) minsal from emp group by job
A: Select deptno, count(deptno) from emp group by deptno having count(deptno)>3
A: Select job, sum(sal) totalsal from emp group by job having sum(sal)>8000
A: Select job, count(job) from emp group by job having count(job)>3
A: Select ename from emp where sal = (select max(sal) from emp)
A: Select empno,ename from emp where job='CLERK' and sal=(select max(sal) from emp where job='CLERK')
A: Select empno,ename from emp where job='SALESMAN' and sal=(select max(sal) from emp where job='CLERK')
A: Select empno,ename from emp where job='CLERK' and sal>(select sal from emp where ename='JAMES') and sal<(select sal from emp where ename='SCOTT')
A: Select ename from emp where sal>(select sal from emp where ename='JAMES') or sal<(select sal from emp where ename='SCOTT')
A: Select ename from emp e where sal=(select max(sal) from emp where deptno= e.deptno)
A: Select ename from emp e where sal=(select max(sal) from emp where job= e.job)
A: Select ename from emp where deptno=(select deptno from dept where dname='ACCOUNTING')
A: Select ename from emp where deptno=(select deptno from dept where loc='CHICAGO')
A: Select job,sum(sal) from emp group by job having sum(sal)> (select max(sal) from emp where job='MANAGER')
A: Select ename, sal from emp WHERE deptno=10 and sal=(select max(sal) from emp)
A: Select ename, sal from emp where deptno = 10 and sal > all(select sal from emp where deptno !=10)
A: Select upper(ename) from emp
A: Select lower(ename) from emp
A: Select initcap(ename) from emp
A: Select length('naga') from dual
A: Select ename,length(ename) from emp
A: Select concat(empno, ename) from emp
A: Select substr('oracle',2,3) from dual
A: Select instr('computer maintenance corporaton','a',1,1) from dual
A: Select replace('allen’s','a','b') FROM dual
A: Select ENAME, replace('BOSS','MANAGER') FROM emp where job='MANAGER'
A: Select empno,ename,decode(deptno,10,'ACCOUNTING',20,'RESEARCH',30,'SALES') from emp
A: Select months_between(sysdate,'15-june-1985')*30 from dual
A: Select months_between(sysdate,'15-june-1985') from dual
A: Select replace('15-aug-1947',sysdate) from dual
A: Select ename || 'has joined the company on' || to_char(hiredate,'ddth month day year') FROM emp
A: Select next_day(sysdate,'saturday') from dual
A: Select to_char(sysdate,'hh:mi:ss') from dual
A: Select sysdate-90 FROM dual
A: Select job from emp where deptno=20 INTERSECT select job from emp where deptno=10
A: Select DISTINCT job from emp where deptno in(10,20)
A: Select job FROM emp where job not in (select job from emp WHERE deptno in (20,30,40))
OR
A: Select job FROM emp WHERE deptno=10 and job not in (SELECT job FROM emp where deptno <> 10)
A: Select * from emp where empno not in (select empno FROM emp where empno in (select mgr FROM emp))
OR
A: Select * from emp where empno not in (Select DISTINCT mgr from emp where mgr is not null)
A: Select ename,dname,grade from emp,dept,salgrade where emp.deptno=dept.deptno and dname='SALES' and sal between losal and hisal and grade=3
A: Select* from emp where empno in (select mgr from emp)) INTERSECT (select * from emp where empno not in (select empno from emp where empno in (select mgr from emp))
A: Select * FROM emp where length(ename) > 4
A: Select * FROM dept where dname like 'S%' and loc like '%O'
A: Select * from emp where mgr in (select empno from emp WHERE ename='JONES')
A: Select ename from emp where sal+(sal*0.2) > 3000
A: Select e.ename, d.dname from emp e, dept d where e.deptno= d.deptno
A: Select e.ename from emp e, dept d where e.deptno= d.deptno and d.dname='SALES'
A: Select e.ename, d.dname,e.sal,e.comm from emp e, dept d where e.deptno= d.deptno and d.loc='CHICAGO' and e.sal between 2000 and 5000
A: Select * from emp e1 where e1.sal>(select e2.sal from emp e2 where e1.mgr= e2.empno)
A: Select * from emp e1 where e1.deptno=(select e2.deptno from emp e2 where e1.mgr= e2.empno)
A: Select ename from emp where mgr is null
A: Select grade,ename from emp, salgrade where grade!=4 and deptno in (10,30) and hiredate < to_date('31-dec-82') and sal BETWEEN losal and hisal
A: Update emp set sal=sal+sal*0.1 where comm is null
A: Select * from emp e, dept d where e.hiredate<'31-dec-82' and e.deptno= d.deptno and (d.loc='NEWYORK' or d.loc='CHICAGO')
A: Select e.ename,e.job,d.dname,d.loc from emp e,dept d where e.deptno= d.deptno and e.job='MANAGER'
A: Select e.ename, e.mgr MGRNO, e1.ename MGRNAME from emp e, emp e1 where e.mgr=e1.empno and e1.ename='JONES'
A: Select ename, sal, grade, hisal from emp, salgrade where ename='FORD' and sal=hisal and sal between losal and hisal
A: Select e.ename,e.job,d.dname, grade, e1.ename from emp e,emp e1,dept d, salgrade where e.deptno= d.deptno and e.mgr=e1.empno and e.sal between losal and hisal
A: Select ename,job,sal,grade from emp,dept,salgrade where emp.deptno= dept.deptno and sal between losal and hisal and job<>'CLERK' order by sal desc
A: Select e.ename,e.job,e1.ename MGRNAME from emp e, emp e1 where e.mgr=e1.empno(+)
A: Select e.ename from emp e where 5>(select count(*) from emp e1 where e.sal>e1.sal)
A: Select ename from emp where sal=(select max(sal) from emp)
Posted by Nagaraju Veeranala at 11:26 AM 0 comments
Labels: Database
Employee Table Script
CREATE TABLE emp (
empno decimal(4,0) NOT NULL,
ename varchar(10) default NULL,
job varchar(9) default NULL,
mgr decimal(4,0) default NULL,
hiredate date default NULL,
sal decimal(7,2) default NULL,
comm decimal(7,2) default NULL,
deptno decimal(2,0) default NULL
);
Employee Insert Scripts
INSERT INTO emp VALUES ('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20');
INSERT INTO emp VALUES ('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30');
INSERT INTO emp VALUES ('7521','WARD','SALESMAN','7698','1981-02-22','1250.00','500.00','30');
INSERT INTO emp VALUES ('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20');
INSERT INTO emp VALUES ('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30');
INSERT INTO emp VALUES ('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30');
INSERT INTO emp VALUES ('7782','CLARK','MANAGER','7839','1981-06-09','2450.00',NULL,'10');
INSERT INTO emp VALUES ('7788','SCOTT','ANALYST','7566','1982-12-09','3000.00',NULL,'20');
INSERT INTO emp VALUES ('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10');
INSERT INTO emp VALUES ('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30');
INSERT INTO emp VALUES ('7876','ADAMS','CLERK','7788','1983-01-12','1100.00',NULL,'20');
INSERT INTO emp VALUES ('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30');
INSERT INTO emp VALUES ('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20');
INSERT INTO emp VALUES ('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10');
commit;
Department Table Script
CREATE TABLE dept (
deptno decimal(2,0) default NULL,
dname varchar(14) default NULL,
loc varchar(13) default NULL
);
Department Insert Scripts
INSERT INTO dept VALUES ('10','ACCOUNTING','NEW YORK');
INSERT INTO dept VALUES ('20','RESEARCH','DALLAS');
INSERT INTO dept VALUES ('30','SALES','CHICAGO');
INSERT INTO dept VALUES ('40','OPERATIONS','BOSTON');
commit;
Tags:MySql Employee table,insert scripts, MySql Department table,insert scripts, MySql Salgrade table,insert scripts, MySql employee,dept create table scripts, MySql Employee,Dept insert scripts
Posted by Nagaraju Veeranala at 11:23 AM 0 comments
Labels: Database
Employee Table Script
CREATE TABLE EMP
(EMPNO NUMERIC(4) NOT NULL,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR NUMERIC(4),
HIREDATE DATETIME,
SAL NUMERIC(7, 2),
COMM NUMERIC(7, 2),
DEPTNO NUMERIC(2));
Employee Insert Scripts
INSERT INTO EMP VALUES
(7369, 'SMITH', 'CLERK', 7902, '17-DEC-1980', 800, NULL, 20);
INSERT INTO EMP VALUES
(7499, 'ALLEN', 'SALESMAN', 7698, '20-FEB-1981', 1600, 300, 30);
INSERT INTO EMP VALUES
(7521, 'WARD', 'SALESMAN', 7698, '22-FEB-1981', 1250, 500, 30);
INSERT INTO EMP VALUES
(7566, 'JONES', 'MANAGER', 7839, '2-APR-1981', 2975, NULL, 20);
INSERT INTO EMP VALUES
(7654, 'MARTIN', 'SALESMAN', 7698, '28-SEP-1981', 1250, 1400, 30);
INSERT INTO EMP VALUES
(7698, 'BLAKE', 'MANAGER', 7839, '1-MAY-1981', 2850, NULL, 30);
INSERT INTO EMP VALUES
(7782, 'CLARK', 'MANAGER', 7839, '9-JUN-1981', 2450, NULL, 10);
INSERT INTO EMP VALUES
(7788, 'SCOTT', 'ANALYST', 7566, '09-DEC-1982', 3000, NULL, 20);
INSERT INTO EMP VALUES
(7839, 'KING', 'PRESIDENT', NULL, '17-NOV-1981', 5000, NULL, 10);
INSERT INTO EMP VALUES
(7844, 'TURNER', 'SALESMAN', 7698, '8-SEP-1981', 1500, 0, 30);
INSERT INTO EMP VALUES
(7876, 'ADAMS', 'CLERK', 7788, '12-JAN-1983', 1100, NULL, 20);
INSERT INTO EMP VALUES
(7900, 'JAMES', 'CLERK', 7698, '3-DEC-1981', 950, NULL, 30);
INSERT INTO EMP VALUES
(7902, 'FORD', 'ANALYST', 7566, '3-DEC-1981', 3000, NULL, 20);
INSERT INTO EMP VALUES
(7934, 'MILLER', 'CLERK', 7782, '23-JAN-1982', 1300, NULL, 10);
commit;
Department Table Script
CREATE TABLE DEPT
(DEPTNO NUMERIC(2),
DNAME VARCHAR(14),
LOC VARCHAR(13) );
Department Insert Scripts
INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS');
INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO');
INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');
commit;
Salgrade Table Script
CREATE TABLE SALGRADE
(GRADE NUMERIC,
LOSAL NUMERIC,
HISAL NUMERIC);
Salgrade Insert Scripts
INSERT INTO SALGRADE VALUES (1, 700, 1200);
INSERT INTO SALGRADE VALUES (2, 1201, 1400);
INSERT INTO SALGRADE VALUES (3, 1401, 2000);
INSERT INTO SALGRADE VALUES (4, 2001, 3000);
INSERT INTO SALGRADE VALUES (5, 3001, 9999);
commit;
Tags:Oracle Employee table,insert scripts, Oracle Department table,insert scripts, Oracle Salgrade table,insert scripts, Oracle employee,dept create table scripts, Oracle Employee,Dept insert scripts
Posted by Nagaraju Veeranala at 11:18 AM 0 comments
Labels: Database
Setup is actually pretty straightforward. To use SVN in standalone mode (without Apache), just download the installer (I used svn-1.6.15-setup.exe).
Installing Subversion
- Double-click on the installer and run through it. Shouldn't take too long. Once installed, add an environment variable for SVN_EDITOR. You can do this by right-click on my Computer > Properties. Go to advanced. Hit the Environmental Variables button. Just add another in there called SVN_EDITOR with a value of C:\windows\notepad.exe
Creating a Repository
- Now you need to create a repository. Go to the command prompt (Start > run > cmd). type "svnadmin create D:\Programming\MySVNRepos". (Change the path to whatever path you want to use.) The repos is basically a special directory that will hold your files as well as various subversion config options.
Modifying Security and Authentication Settings
- Next up, you need to modify the permissions and users. Navigate to the folder you just created. In my example, I used D:\Programming\MySVNRepos". In this directory, you will find a few folders. One folder will be called conf. Navigate to it and double-click on the svnserv.conf file. Opening it with notepad will be fine.
- The svnserv.conf file in a configuration file for the svnserv executible. For our purposes, just uncomment out the following lines:
anon-access = read
auth-access = write
password-db = passwd
- Save your changes. And double-click on the passwd file in the same directory. The file stores all usernames and passwords in the format:
$username = $password
- Make sure the [Users] line is uncommented and you can just add a new line for your username and password. For example, if you wanted your username to be josh and your password to be testing, just create a line like this:
josh = testing
- Save it and you're done configuring.
Serving Your Repos for the First Time
Now, you can test it out. Go to the command prompt again and type:
svnserve --daemon --root "D:\Programming\MySVNRepos"
Change the path to your specified path. Once this is done, the daemon should be listening and waiting for requests.
Creating your First Project folder
- Next, we can create a project folder in subversion. To do this, open up a new command prompt. We can't use the old one as our daemon will shutdown. Once you're in the new window, type the following:
svn mkdir svn://localhost/TestProject
- Once you type this in, notepad will appear (assuming you set the SVN_EDITOR variable at the very beginning). This is basically used for the log so you can just leave it be for our test example and close it out.
- After you close out notepad, subversion will ask for your username and password. However, keep in mind, it may also ask for your computer's Admin password. If it does, you can simply type in your computer's admin password. Once you hit return, you can then go ahead and type in your subversion username and then your subversion password. Your subversion username and password is exactly what you typed in the passwd file. (i.e. user: josh pass:testing)
- If you've successfully typed in your username and password, it should say Commited Revision 1. This is a good thing.
Finishing Up
- After that's completed, you're basically done. Your subversion repos has been setup. However, we have a few problems.
1. You probably don't want the command window up all the time when running your subversion daemon.
2. Accessing subversion via command prompt is ok, but it could be better.
Running svnserv as a Windows Service
If you're running XP (Win2k, Win2k3, or Vista), you can tell the process to run as a service. Stop your existing svnserv daemon by closing out of the existing command prompt window. Now, go to the command prompt (again). Type:
sc create svnrepos binpath= "\"C:\program files\subversion\bin\svnserve.exe\" --service --root \"D:\Programming\MySVNRepos" displayname= "Subversion Repository" depend= Tcpip start= auto
Ed. Note: The key/value pairs must be in the form key=_value where the underscore is representative of a space. Also, if you mess up here and the service is still installed, you will need to uninstall the service. You can do so by using sc delete svnrepos (or whatever service name you used). You will need to log off and back on for the service to be completely uninstalled. Also, the "Subversion Repository" is simply a label, you may also call this whatever you'd like.
This simply creates a new service in Windows. Of course, you will need to replace "D:\Programming\MySVNRepos" with the path to your repos that you created. Assuming that you install subversion in the default location, you should just have to run that. Now, just start it by typing:
net start svnrepos
You're done. If you want to change some service settings, such as turning on auto start, just go to Start > run. Type services.msc. Find the service with the Display Name set to "Subversion Repository", right-click on it and select Properties. You can change a few different things in there.
Download TortoiseSVN
Go to tortoisesvn.tigris.org and download TortoiseSVN. The tool is essentially a Windows shell extension that allows you to execute SVN commands from Windows Explorer. It's, honestly, the only subversion tool you really need if you're on a Windows computer. Once you install this, you can then view your repos via a tree view type situation.
For example, go to start > run and type:
svn://localhost
If your service/daemon is started, you should be able to expand the nodes to view your projects and files. You can also create new folders and do a plethora of different tasks in it as well. Also, if you go into Windows explorer, and right-click on any folder, you'll see a new TortoiseSVN submenu, with a few different options. You can then easily import an entire project folder into subversion with ease.
Posted by Nagaraju Veeranala at 5:54 AM 0 comments
Labels: SVN
Spring batch is used to run the number of tasks parallelly
In this section, we will see Spring Batch in action by looking into an example. This example simply prints message in console
In Spring Batch, a Tasklet represents the unit of work to be done and in our example case, this would be printing a message.
Look at the following example
The following class implements Tasklet interface. this interface contains execute method. we have to override this method with our functionality.
In our example we are simply printing the passed message
HelloWorldTasklet.java
package com.raj.spring.batch.helloWorld;
import org.springframework.batch.core.StepContribution;
import org.springframework.batch.core.scope.context.ChunkContext;
import org.springframework.batch.core.step.tasklet.Tasklet;
import org.springframework.batch.repeat.RepeatStatus;
/**
* @author nagarajuv
*
*/
public class DynamicJobParameters implements JobParametersIncrementer {
public class HelloWorldTasklet implements Tasklet {
private String printMessage;
public void setPrintMessage(String printMessage) {
this.printMessage = printMessage;
}
// @Override
public RepeatStatus execute(StepContribution stepContribution,
ChunkContext chunkContext) throws Exception {
System.out.println("In Hello World Tasklet.!");
System.out.println("Welcome to spring batch --"+printMessage);
return RepeatStatus.FINISHED;
}
}
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<bean id="jobLauncher" class="org.springframework.batch.core.launch.support.SimpleJobLauncher">
<property name="jobRepository" ref="jobRepository"/>
</bean>
<!-- DATASOURCE, TRANSACTION MANAGER AND JDBC TEMPLATE -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/mydbtest" />
<property name="username" value="raju" />
<property name="password" value="raju" />
</bean>
<!-- JOB REPOSITORY - WE USE IN-MEMORY REPOSITORY FOR OUR EXAMPLE -->
<bean id="jobRepository" class="org.springframework.batch.core.repository.support.JobRepositoryFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="transactionManager" ref="transactionManager"/>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- With out DB connection -->
<!--
<bean id="jobRepository" class="org.springframework.batch.core.repository.support.SimpleJobRepository">
<constructor-arg>
<bean class="org.springframework.batch.core.repository.dao.MapJobInstanceDao"/>
</constructor-arg>
<constructor-arg>
<bean class="org.springframework.batch.core.repository.dao.MapJobExecutionDao" />
</constructor-arg>
<constructor-arg>
<bean class="org.springframework.batch.core.repository.dao.MapStepExecutionDao"/>
</constructor-arg>
<constructor-arg>
<bean class="org.springframework.batch.core.repository.dao.MapExecutionContextDao"/>
</constructor-arg>
</bean>
<bean id="transactionManager" class="org.springframework.batch.support.transaction.ResourcelessTransactionManager"/>
-->
</beans>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<import resource="applicationContext.xml"/>
<bean id="welcomeTasklet" class="com.raj.spring.batch.helloWorld.HelloWorldTasklet">
<property name="printMessage" value="Santosh"/>
</bean>
<bean id="printTasklet" class="com.raj.spring.batch.helloWorld.HelloWorldTasklet">
<property name="printMessage" value="Nagaraju"/>
</bean>
<bean id="taskletStep" abstract="true"
class="org.springframework.batch.core.step.tasklet.TaskletStep">
<property name="jobRepository" ref="jobRepository"/>
</bean>
<bean id="helloWorldJob" class="org.springframework.batch.core.job.SimpleJob">
<property name="restartable" value="true" />
<property name="name" value="helloWorldJob" />
<property name="steps">
<list>
<bean parent="taskletStep">
<property name="tasklet" ref="welcomeTasklet"/>
<property name="transactionManager" ref="transactionManager"/>
</bean>
<bean parent="taskletStep">
<property name="tasklet" ref="printTasklet"/>
<property name="transactionManager" ref="transactionManager"/>
</bean>
</list>
</property>
<property name="jobRepository" ref="jobRepository"/>
</bean>
</beans>
Through spring batch CommandLineJobRunner we can run this example by passing jobxml file name,jobname.package com.raj.spring.batch.helloWorld;
import org.springframework.batch.core.launch.support.CommandLineJobRunner;
/**
* @author nagarajuv
*
*/
public class Main {
public static void main(String[] args) {
CommandLineJobRunner.main(new String[]{"helloWorldJob.xml", "helloWorldJob"});
}
}
Posted by Nagaraju Veeranala at 5:18 AM 0 comments
Labels: SpringBatch
For Database configuration in spring batch we need to run the sql script.
The following are the sql scripts for different databases.
The sql scripts are availalble at spring-batch-core jar. we can simply extract the jar for these scripts
other wise you can simply download from the following location
Spring-Batch-All-Scripts
/* To empty the tables */
DELETE FROM BATCH_STEP_EXECUTION_CONTEXT;
DELETE FROM BATCH_JOB_EXECUTION_CONTEXT;
DELETE FROM BATCH_STEP_EXECUTION;
DELETE FROM BATCH_JOB_EXECUTION;
DELETE FROM BATCH_JOB_PARAMS;
DELETE FROM BATCH_JOB_INSTANCE;
/* To view the data in the tables */
select * from BATCH_JOB_INSTANCE;
select * from BATCH_JOB_PARAMS;
select * from BATCH_JOB_EXECUTION;
select * from BATCH_STEP_EXECUTION;
select * from BATCH_JOB_EXECUTION_CONTEXT;
select * from BATCH_STEP_EXECUTION_CONTEXT;
Tags:Spring batch job scripts for different databases. Spring batch Mysql scripts
Posted by Nagaraju Veeranala at 1:58 AM 0 comments
Labels: SpringBatch
so many people looks for updating cron trigger with new cron expression. updating cron expression is very easy
First get the existing cron and now create new cronTrigger with the existing cron trigger details
The following code will explains how to reschedule job with new cron expression
UpdatingCronExp.java
package com.raj;
/**
* @author nagarajuv
*
*/
public class UpdatingCronExp {
public void updateCronExpression(org.quartz.impl.StdScheduler stdSchedular, Supplier supplier, String triggerName) {
CronTrigger cronTrigger = (CronTrigger) stdSchedular.getTrigger(triggerName, groupName);
String newCronExpression = "0 20 9 * * ?"
try {
// Creating a new cron trigger
CronTrigger updatedCronTrigger = new CronTrigger();
updatedCronTrigger.setJobName(cronTrigger.getJobName());
updatedCronTrigger.setName(triggerName);
updatedCronTrigger.setCronExpression(newCronExpression);
// Reschedule the job with updated cron expression
stdSchedular.rescheduleJob(triggerName, groupName, updatedCronTrigger);
} catch (ParseException e) {
e.printStackTrace();
}
}
}
Posted by Nagaraju Veeranala at 9:41 AM 0 comments
Labels: QuartzJob
So many people looks for struts flow
Please find the following step by step process
Struts Flow
1) When application server gets started container loads the web.xml
2) When first the request is made from a JSP/HTML/XSLT to the server with a particular URI(/something.do) the control first reaches Web.xml file.
3) It checks the mapping for /something.do in web.xml and finds the ActionServlet and loads ActionServlet.
......
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
.....
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
4) As part of loading ActionServlet calls the init() as every other servlet does.
(Note: ActionServlet extends HttpServlet only)
......................
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
........................
5) In init() it takes the init-parameters as struts-config.xml and loads the xml file.
6) Then the ActionServlet calls the process() method of RequestProcessor class.
7) process() method checks for the appropriate action in the action mapping for current request and maps the URI to the action in the struts-config.xml.
8) Then it creates an object to ActionForm associated to that action.
9) It then calls the setters and reset() methods in the form bean(Which extends ActionForm) corresponds to the mapped action.
10) If the action tag in struts-config.xml contains validate "true" then the validate method is called.
11) if any validation errors it return to view component (any jsp XSLT) which is specified as an attribute of input "/error.jsp"
12) if there are no validation errors it then search for execute method in the action class and executes it.
13) execute method performs the bussinesslogic which you provide and returns with an ActionForward key.
14) Now the returned key is searched in the mapped action which is specified as forward tag.
15) It looks for the appropriate view component and performs the getters on that action form corresponding to this view component and loads the view page in the browser.
Tags:Struts step by step flow in detail
Posted by Nagaraju Veeranala at 12:54 PM 0 comments
Labels: Struts
org.springframework.batch.core.repository.JobInstanceAlreadyCompleteException: A job instance already exists and is complete for parameters={}. If you want to run this job again, change the parameters.
Solution for the above exception is:
The meaning of the above exception is one instancce(instance name) is already exists in db
To avoid the above exception we have to follow the following process
The following class is used to set job parameters dynamically
DynamicJobParameters.java
package raj.spring.batch;
import java.util.Calendar;
import java.util.Date;
import org.springframework.batch.core.JobParameters;
import org.springframework.batch.core.JobParametersBuilder;
import org.springframework.batch.core.JobParametersIncrementer;
/**
* @author nagarajuv
*
*/
public class DynamicJobParameters implements JobParametersIncrementer {
Date date = null;
public JobParameters getNext(JobParameters parameters) {
date = new Date();
parameters = new JobParametersBuilder().addLong("currentTime", new Long(System.currentTimeMillis())).toJobParameters();
return parameters;
}
}
<bean id="fileWritingJob" class="org.springframework.batch.core.job.SimpleJob" incrementer="dynamicJobParameters"> <bean id="dynamicJobParameters" class="com.ecomputercoach.DynamicJobParameters" />
Job job = null;
JobParametersBuilder builder = null;
JobParameters jobParameters = null;
JobLauncher launcher = null;
ApplicationContext context = AppContext.getApplicationContext();
job = (Job) context.getBean("myjob");
builder = new JobParametersBuilder();
builder.addLong("currentTime", new Long(System.currentTimeMillis()));
jobParameters = builder.toJobParameters();
launcher = (JobLauncher) context.getBean("jobLauncher");
launcher.run(job, jobParameters);
Posted by Nagaraju Veeranala at 12:22 PM 0 comments
Labels: SpringBatch
Accessing the appolication context in java class is very easy. if you want to access the application context beans in any java class we have to set the application context at the time of server loading for that follow the
following process
The following class is used to set values in the application context dynamically.
AppContext.java
package com.raj;
import org.springframework.context.ApplicationContext;
/**
* @author nagarajuv
*
*/
public class AppContext {
private static ApplicationContext ctx;
/**
* Injected from the class "ApplicationContextProvider" which is automatically loaded during Spring-Initialization.
*/
public static void setApplicationContext(ApplicationContext applicationContext) {
ctx = applicationContext;
}
/**
* Get access to the Spring ApplicationContext from everywhere in your Application.
*
* @return
*/
public static ApplicationContext getApplicationContext() {
return ctx;
}
}
package com.raj;
import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import com.raj.AppContext;
/**
* @author nagarajuv
*
*/
public class ApplicationContextProvider implements ApplicationContextAware {
public void setApplicationContext(ApplicationContext ctx) throws BeansException {
// Wiring the ApplicationContext into a static method
AppContext.setApplicationContext(ctx);
}
}
<?xml version="1.0"?> <!DOCTYPE faces-config PUBLIC "-//Sun Microsystems, Inc.//DTD JavaServer Faces Config 1.1//EN" "http://java.sun.com/dtd/web-facesconfig_1_1.dtd"> <!-- Application Context Provider --> <bean id="contextApplicationContextProvider" class="com.raj.ApplicationContextProvider"></bean>
Posted by Nagaraju Veeranala at 12:14 PM 0 comments
Labels: Spring
© Copyright - Nagaraju@Google | A Blogger por Blog and Web
