Skip to main content

[ibatchprocess~ibatchprocess:1] added source code for Batch Job

  • From:
  • To:
  • Subject: [ibatchprocess~ibatchprocess:1] added source code for Batch Job
  • Date: Tue, 6 Dec 2011 10:33:43 +0000

Project:    ibatchprocess
Repository: ibatchprocess
Revision:   1
Author:     prabir_kumar
Date:       2011-12-06 10:33:36 UTC
Link:       

Log Message:
------------
added source code for Batch Job


Revisions:
----------
1


Added Paths:
------------
BatchJobServer/bin/server/parser/SimpleXMLSchemaParser.class
BatchJobServer/src/common/JobSchedular.java
BatchJobServer/src/server/listener/ConnectionHandler.java
BatchJobServer/src/server/validator
BatchJobServer/src/logger/ILogger.java
BatchJobServer/bin/server/validator/XMLSchemaValidator.class
BatchJobServer/bin/logger/ILoggerFactory.class
BatchJobServer/src/test/ClientSocket.java
BatchJobServer/bin
BatchJobServer/lib/ojdbc14.jar
BatchJobServer/src/server/artifacts/ObjectFactory.java
BatchJobServer/bin/server/parser/SAXSchemaHandler.class
BatchJobServer/lib/jaxb-impl.jar
BatchJobServer/src/server/artifacts/RunFrequecyDtls.java
BatchJobServer/bin/common/AttributeMap.class
BatchJobServer/bin/test
BatchJobServer/bin/common/JobMetadataBean.class
BatchJobServer/bin/common/JobExecutor.class
BatchJobServer/src/server/parser/SimpleXMLSchemaParser.java
BatchJobServer/lib/cron4j-2.2.4.jar
BatchJobServer/bin/server/conf
BatchJobServer/bin/test/CadillacJob.class
BatchJobServer/bin/server/validator
BatchJobServer/src/test
BatchJobServer/src/common/JobMetadataBean.java
BatchJobServer/bin/test/jobconfig.xml
BatchJobServer/bin/server/parser/ParseFailException.class
BatchJobServer/src/server/validator/IValidator.java
BatchJobServer/.classpath
BatchJobServer/bin/server/listener
BatchJobServer/src/server/artifacts/Description.java
BatchJobServer/src/server/parser/SAXSchemaHandler.java
BatchJobServer/bin/server/validator/SimpleXMLSchemaValidator.class
BatchJobServer/logs/cadillac_log.log
BatchJobServer/logs/EMS_log.log
BatchJobServer/src/server/artifacts/LoggerInfo.java
BatchJobServer/src/test/CadillacJob.java
BatchJobServer/src/common/DatabaseManager.java
BatchJobServer/bin/test/ClientSocket.class
BatchJobServer
BatchJobServer/src/server/validator/XMLSchemaValidator.java
BatchJobServer/bin/test/EMSJob.class
BatchJobServer/lib/log4j-1.2.16.jar
BatchJobServer/bin/server/validator/IValidator.class
BatchJobServer/src/server/BatchJobManager.java
BatchJobServer/src/server/artifacts/SharedDatasource.java
BatchJobServer/src/common/RunningJobsMetadata.java
BatchJobServer/src/test/EMSJob.java
BatchJobServer/bin/server
BatchJobServer/bin/server/listener/ConnectionHandler.class
BatchJobServer/src/server/conf
BatchJobServer/src/server
BatchJobServer/bin/logger/ILogger.class
BatchJobServer/bin/server/artifacts/Datasource.class
BatchJobServer/src/server/artifacts/BatchJobs.java
BatchJobServer/bin/server/parser/XMLSchemaParser.class
BatchJobServer/src/common/QueryRequestBean.java
BatchJobServer/src/common/JobTask.java
BatchJobServer/bin/server/BatchJobManager.class
BatchJobServer/src/server/parser
BatchJobServer/bin/server/artifacts/RunFrequecyDtls.class
BatchJobServer/src/logger/LogLog.java
BatchJobServer/logs/job_server_log.log
BatchJobServer/bin/common/JobExecutor$1.class
BatchJobServer/bin/server/parser
BatchJobServer/bin/common/RunningJobsMetadata.class
BatchJobServer/bin/common/QueryRequestBean.class
BatchJobServer/bin/common/QueryMetadata.class
BatchJobServer/logs/cadillac_log.log.1
BatchJobServer/src/server/parser/IParser.java
BatchJobServer/bin/server/parser/IParser.class
BatchJobServer/src/test/TestSchemaParser.java
BatchJobServer/bin/server/artifacts/Batchjob.class
BatchJobServer/.project
BatchJobServer/bin/common/CommandProcessor.class
BatchJobServer/src/server/Version.java
BatchJobServer/bin/common/JobTask.class
BatchJobServer/bin/server/jobserverlog.properties
BatchJobServer/src/server/listener
BatchJobServer/bin/server/artifacts/ObjectFactory.class
BatchJobServer/src/server/artifacts/Datasource.java
BatchJobServer/bin/common/DatabaseManager.class
BatchJobServer/bin/server/artifacts/SharedDatasource.class
BatchJobServer/src/common/CommandParser.java
BatchJobServer/lib/jaxb-api.jar
BatchJobServer/bin/server/artifacts
BatchJobServer/src/common/AttributeMap.java
BatchJobServer/src/server/validator/SimpleXMLSchemaValidator.java
BatchJobServer/lib/mysql-connector-java-3.1.6-bin.jar
BatchJobServer/lib
BatchJobServer/src/server/parser/XMLSchemaParser.java
BatchJobServer/src/logger/ILoggerFactory.java
BatchJobServer/src/common/InvalidCommandException.java
BatchJobServer/src/server/jobserverlog.properties
BatchJobServer/src/test/TestUnmershalData.java
BatchJobServer/bin/common/JobTaskListener.class
BatchJobServer/src/server/parser/ParseFailException.java
BatchJobServer/bin/server/artifacts/Description.class
BatchJobServer/src/test/TestSchemaValidation.java
BatchJobServer/src/server/listener/ServerSocketListener.java
BatchJobServer/bin/server/JobConfigurator.class
BatchJobServer/src/common/QueryMetadata.java
BatchJobServer/bin/common/JobSchedular.class
BatchJobServer/bin/common/CommandParser.class
BatchJobServer/bin/server/artifacts/BatchJobs.class
BatchJobServer/src/server/artifacts/package-info.java
BatchJobServer/src/common/CommandDictionary.java
BatchJobServer/src/common/ScheduleFailException.java
BatchJobServer/bin/server/artifacts/package-info.class
BatchJobServer/src/common/JobExecutor.java
BatchJobServer/src/server/test.xsd
BatchJobServer/src/test/jobconfig.xml
BatchJobServer/src/common/JobContext.java
BatchJobServer/bin/server/conf/batchjob1.0.xsd
BatchJobServer/bin/server/Version.class
BatchJobServer/bin/common/InvalidCommandException.class
BatchJobServer/src/common/JobTaskListener.java
BatchJobServer/src/logger
BatchJobServer/bin/server/test.xsd
BatchJobServer/bin/test/TestUnmershalData.class
BatchJobServer/bin/common/JobContext.class
BatchJobServer/src/server/artifacts
BatchJobServer/src/common/CommandProcessor.java
BatchJobServer/bin/common
BatchJobServer/src/common
BatchJobServer/logs
BatchJobServer/bin/common/ScheduleFailException.class
BatchJobServer/src/server/artifacts/BatchjobBaseElements.java
BatchJobServer/bin/server/artifacts/LoggerInfo.class
BatchJobServer/src
BatchJobServer/bin/test/TestSchemaParser.class
BatchJobServer/bin/server/listener/ServerSocketListener.class
BatchJobServer/src/server/conf/batchjob1.0.xsd
BatchJobServer/src/server/artifacts/Batchjob.java
BatchJobServer/bin/test/TestSchemaValidation.class
BatchJobServer/src/test/ClientSocket.class
BatchJobServer/bin/server/validator/ValidationFaliException.class
BatchJobServer/src/server/listener/ConnectionHandler.class
BatchJobServer/bin/common/CommandDictionary.class
BatchJobServer/bin/server/listener/QueryResponseBean.class
BatchJobServer/src/server/JobConfigurator.java
BatchJobServer/logs/EMS_log.log.1
BatchJobServer/bin/logger
BatchJobServer/src/server/listener/QueryResponseBean.java
BatchJobServer/src/server/validator/ValidationFaliException.java
BatchJobServer/bin/server/parser/SimpleXMLSchemaParser$1.class
BatchJobServer/bin/logger/LogLog.class
BatchJobServer/bin/server/artifacts/BatchjobBaseElements.class


Diffs:
------
Index: BatchJobServer/.classpath
===================================================================
--- BatchJobServer/.classpath   (revision 0)
+++ BatchJobServer/.classpath   (revision 1)
@@ -0,0 +1,11 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<classpath>
+       <classpathentry kind="src" path="src"/>
+       <classpathentry kind="con" 
path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
+       <classpathentry kind="lib" path="lib/jaxb-impl.jar"/>
+       <classpathentry kind="lib" path="lib/log4j-1.2.16.jar"/>
+       <classpathentry kind="lib" path="lib/cron4j-2.2.4.jar"/>
+       <classpathentry kind="lib" 
path="lib/mysql-connector-java-3.1.6-bin.jar"/>
+       <classpathentry kind="lib" path="lib/ojdbc14.jar"/>
+       <classpathentry kind="output" path="bin"/>
+</classpath>
Index: BatchJobServer/.project
===================================================================
--- BatchJobServer/.project     (revision 0)
+++ BatchJobServer/.project     (revision 1)
@@ -0,0 +1,17 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<projectDescription>
+       <name>BatchJobServer</name>
+       <comment></comment>
+       <projects>
+       </projects>
+       <buildSpec>
+               <buildCommand>
+                       <name>org.eclipse.jdt.core.javabuilder</name>
+                       <arguments>
+                       </arguments>
+               </buildCommand>
+       </buildSpec>
+       <natures>
+               <nature>org.eclipse.jdt.core.javanature</nature>
+       </natures>
+</projectDescription>
Index: BatchJobServer/logs/job_server_log.log
===================================================================
--- BatchJobServer/logs/job_server_log.log      (revision 0)
+++ BatchJobServer/logs/job_server_log.log      (revision 1)
@@ -0,0 +1,10 @@
+2011-12-05 22:00:02 BatchJobManager [INFO] Starting BatchJobManager v1.0.0
+2011-12-05 22:00:02 BatchJobManager [INFO] Loading configuration from file.
+2011-12-05 22:00:02 BatchJobManager [INFO] Configuration loaded.
+defination.
+2011-12-05 22:00:02 JobConfigurator [INFO] Validate/Parse configuration file 
against schema rules.
+2011-12-05 22:00:02 JobConfigurator [INFO] Validate/Parsing completed.
+2011-12-05 22:00:02 JobExecutor [INFO] Instantiate JobExecutor with the 
specified configuration.
+2011-12-05 22:00:02 JobExecutor [INFO] Sorting list of user specified Jobs.
+2011-12-05 22:00:02 JobExecutor [INFO] Validate Job[MyJob2]
+2011-12-05 22:00:02 JobExecutor [INFO] Starting Job[2/MyJob2]
Index: BatchJobServer/logs/EMS_log.log.1
===================================================================
--- BatchJobServer/logs/EMS_log.log.1   (revision 0)
+++ BatchJobServer/logs/EMS_log.log.1   (revision 1)
@@ -0,0 +1,1593 @@
+2011-11-28 14:51:35 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 14:51:35 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 14:51:35 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 14:51:35 EMSJob [INFO] Verification successfull for JOB 
[2/MyJob2].
+2011-11-28 14:51:35 EMSJob [INFO] Job[2/MyJob2] successfully scheduled.
+2011-11-28 14:52:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 14:54:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 14:56:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 14:58:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:00:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:02:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:04:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:06:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:08:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:10:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:12:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:14:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:16:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:18:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:20:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:22:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:24:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:26:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:28:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:30:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:32:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:34:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e97ac03673c3eb84
+2011-11-28 15:35:54 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 15:35:54 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 15:35:54 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 15:35:54 EMSJob [INFO] Verification successfull for JOB 
[2/MyJob2].
+2011-11-28 15:35:54 EMSJob [INFO] Job[2/MyJob2] successfully scheduled.
+2011-11-28 15:36:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:38:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:40:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:42:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:44:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:46:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:48:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:50:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:52:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:54:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd30179c28500000133e9a350c5377f0659
+2011-11-28 15:57:47 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 15:57:47 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 15:57:47 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 15:57:47 EMSJob [INFO] Verification successfull for JOB 
[2/MyJob2].
+2011-11-28 15:57:47 EMSJob [INFO] Job[2/MyJob2] successfully scheduled.
+2011-11-28 15:58:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d00958bb80179c28500000133e9b75b0a47884a3f
+2011-11-28 16:18:39 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 16:18:39 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 16:18:39 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 16:18:40 EMSJob [INFO] Verification successfull for JOB 
[2/MyJob2].
+2011-11-28 16:18:40 EMSJob [INFO] Job[2/MyJob2] successfully scheduled.
+2011-11-28 16:20:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d00958bb80179c28500000133e9ca776329320f5f
+2011-11-28 16:22:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d00958bb80179c28500000133e9ca776329320f5f
+2011-11-28 16:26:09 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 16:26:09 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 16:26:09 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 16:26:09 EMSJob [INFO] Verification successfull for JOB 
[2/MyJob2].
+2011-11-28 16:26:09 EMSJob [INFO] Job[2/MyJob2] successfully scheduled.
+2011-11-28 16:28:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d00d42d080179c28500000133e9d1538947dc3f8a
+2011-11-28 16:29:51 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 16:29:51 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 16:29:51 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 16:29:51 EMSJob [INFO] Verification successfull for JOB 
[2/MyJob2].
+2011-11-28 16:29:51 EMSJob [INFO] Job[2/MyJob2] successfully scheduled.
+2011-11-28 16:30:00 EMSJob [INFO] I am in run. My ID is - 
ac9b3e5d01d86fd300d1e60400000133e9d4b5507d7cb7f8
+2011-11-28 21:11:21 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 21:11:21 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 21:11:22 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 21:11:24 EMSJob [ERROR] Database connectivity for Job[2/MyJob2] 
failed
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:11:24 EMSJob [ERROR] Could not start Job[2/MyJob2].
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:22:48 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 21:22:48 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 21:22:48 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 21:22:50 EMSJob [ERROR] Database connectivity for Job[2/MyJob2] 
failed
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:22:50 EMSJob [ERROR] Could not start Job[2/MyJob2].
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:27:17 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 21:27:17 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 21:27:17 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 21:27:19 EMSJob [ERROR] Database connectivity for Job[2/MyJob2] 
failed
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:27:19 EMSJob [ERROR] Could not start Job[2/MyJob2].
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:36:54 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 21:36:54 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 21:36:54 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 21:36:56 EMSJob [ERROR] Database connectivity for Job[2/MyJob2] 
failed
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:36:56 EMSJob [ERROR] Could not start Job[2/MyJob2].
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:39:16 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 21:39:16 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 21:39:16 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 21:39:19 EMSJob [ERROR] Database connectivity for Job[2/MyJob2] 
failed
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:39:19 EMSJob [ERROR] Could not start Job[2/MyJob2].
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:40:44 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 21:40:44 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 21:40:44 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 21:40:46 EMSJob [ERROR] Database connectivity for Job[2/MyJob2] 
failed
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:40:46 EMSJob [ERROR] Could not start Job[2/MyJob2].
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:42:47 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 21:42:47 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 21:42:47 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 21:42:49 EMSJob [ERROR] Database connectivity for Job[2/MyJob2] 
failed
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 21:42:49 EMSJob [ERROR] Could not start Job[2/MyJob2].
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:86)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 22:25:39 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 22:25:39 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 22:25:39 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 22:25:41 EMSJob [ERROR] Database connectivity for Job[2/MyJob2] 
failed
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:87)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:87)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 22:25:41 EMSJob [ERROR] Could not start Job[2/MyJob2].
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:87)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:87)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-28 22:31:01 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-28 22:31:01 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-28 22:31:01 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-28 22:31:01 EMSJob [INFO] Verification successfull for JOB 
[2/MyJob2].
+2011-11-28 22:31:01 EMSJob [INFO] Job[2/MyJob2] successfully scheduled.
+2011-11-28 22:32:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:34:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:36:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:38:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:40:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:42:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:44:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:46:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:48:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:50:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:52:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:54:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:56:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 22:58:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 23:00:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 23:02:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 23:04:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 23:06:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 23:08:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-28 23:10:00 EMSJob [INFO] I am in run. My ID is - 
825e28c001d86fd30179c28500000133eb1f5e5e139858c8
+2011-11-29 11:49:35 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-29 11:49:35 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-29 11:49:35 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-29 11:49:37 EMSJob [ERROR] Database connectivity for Job[2/MyJob2] 
failed
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:87)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:87)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-29 11:49:37 EMSJob [ERROR] Could not start Job[2/MyJob2].
+com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception: 
+
+** BEGIN NESTED EXCEPTION ** 
+
+java.net.SocketException
+MESSAGE: java.net.ConnectException: Connection refused: connect
+
+STACKTRACE:
+
+java.net.SocketException: java.net.ConnectException: Connection refused: 
connect
+       at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
+       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:87)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+
+
+** END NESTED EXCEPTION **
+
+
+       at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
+       at com.mysql.jdbc.Connection.<init>(Connection.java:405)
+       at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
+       at java.sql.DriverManager.getConnection(DriverManager.java:582)
+       at java.sql.DriverManager.getConnection(DriverManager.java:185)
+       at common.DatabaseManager.getConnection(DatabaseManager.java:37)
+       at common.JobContext.getConnection(JobContext.java:31)
+       at common.JobSchedular.schedule(JobSchedular.java:87)
+       at common.JobExecutor.start(JobExecutor.java:38)
+       at server.BatchJobManager.start(BatchJobManager.java:26)
+       at server.BatchJobManager.main(BatchJobManager.java:38)
+2011-11-29 11:51:02 EMSJob [INFO] Starting Job[2/MyJob2].
+2011-11-29 11:51:02 EMSJob [INFO] setup context for Job[2/MyJob2].
+2011-11-29 11:51:02 EMSJob [INFO] Verifying database connection for JOB 
[2/MyJob2].
+2011-11-29 11:51:02 EMSJob [INFO] Verification successfull for JOB 
[2/MyJob2].
+2011-11-29 11:51:02 EMSJob [INFO] Job[2/MyJob2] successfully scheduled.
+2011-11-29 11:51:02 EMSJob [INFO] Manipulate Jobs metadata for Job[2/MyJob2].
+2011-11-29 11:52:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 11:54:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 11:56:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 11:58:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:00:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:02:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:04:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:06:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:08:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:10:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:12:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:14:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:16:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:18:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:20:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:22:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 12:24:00 EMSJob [INFO] I am in run. My ID is - 
a838332000958bb80179c28500000133edfbcf4d752997c2
+2011-11-29 
[truncated due to length]



[ibatchprocess~ibatchprocess:1] added source code for Batch Job

prabir_kumar 12/06/2011
 
 
Close
loading
Please Confirm
Close