[Batchserver-cvs] batchserver/bin/dbscripts/mysql create_basic_job_controller_config.sql, NONE, 1.1 create_job_config.sql, NONE, 1.1 create_job_data_transfer.sql, NONE, 1.1 create_job_logging_config.sql, NONE, 1.1 create_job_mgmt_mntr_info.sql, NONE, 1.1 create_job_statistics.sql, NONE, 1.1 create_pool_job_controller_config.sql, NONE, 1.1 insert_sample_jobs.sql, NONE, 1.1

[Suresh <sur...@us...>]

Update of /cvsroot/batchserver/batchserver/bin/dbscripts/mysql
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv8326

Added Files:
	create_basic_job_controller_config.sql create_job_config.sql 
	create_job_data_transfer.sql create_job_logging_config.sql 
	create_job_mgmt_mntr_info.sql create_job_statistics.sql 
	create_pool_job_controller_config.sql insert_sample_jobs.sql 
Log Message:
no message

--- NEW FILE: create_job_statistics.sql ---
DROP TABLE IF EXISTS `batchserver`.`job_statistics`;
CREATE TABLE  `batchserver`.`job_statistics` (
  `JOB_NAME` varchar(64) NOT NULL default '' COMMENT 'Job Name',
  `JOB_START_TIME` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'Timestamp when job got started.',
  `JOB_END_TIME` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'Timestamp when job got finished.',
  `JOB_EXIT_CODE` decimal(10,0) NOT NULL default '0' COMMENT 'Job exit code.',
  `JOB_EXIT_REASON` varchar(1024) default NULL COMMENT 'Reason in case of job failure',
  `RECORDS_PRCOESSED` decimal(10,0) NOT NULL default '0' COMMENT 'Number of records processed.',
  `MEMORY_USAGE` decimal(10,0) NOT NULL default '0' COMMENT 'Memory used by the job.',
  KEY `NUIDX_JOB_NAME_STATS` (`JOB_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Holds the statistics of all the jobs.';
--- NEW FILE: create_job_config.sql ---
DROP TABLE IF EXISTS `batchserver`.`job_config`;
CREATE TABLE  `batchserver`.`job_config` (
  `JOB_NAME` varchar(64) NOT NULL default '' COMMENT 'Column represents the job name.',
  `JOB_STATUS` decimal(10,0) NOT NULL default '1' COMMENT 'Column states whether the job is active or inactive. 1 - active 0 - inactive',
  `JOB_CONTROLLER_CLASS_NAME` varchar(256) NOT NULL default '' COMMENT 'Column holds the controller class name.',
  `JOB_CONTROLLER_PROPS` varchar(1024) default NULL COMMENT 'Column holds job controller configuration properties in the format name1=value1:name2=value2',
  PRIMARY KEY  (`JOB_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table holds the configuration of all the jobs.';
--- NEW FILE: insert_sample_jobs.sql ---
insert into JOB_CONFIG (JOB_NAME, JOB_STATUS, JOB_CONTROLLER_CLASS_NAME, JOB_CONTROLLER_PROPS) values ('process_file_abc',1,'org.jmonks.batchserver.framework.controller.pool.PoolJobController','pool-job-controller-restart=false');

insert into JOB_CONFIG (JOB_NAME, JOB_STATUS, JOB_CONTROLLER_CLASS_NAME, JOB_CONTROLLER_PROPS) values ('process_file_xyz',1,'org.jmonks.batchserver.framework.controller.basic.BasicJobController','pool-job-controller-restart=false');

insert into POOL_JOB_CONTROLLER_CONFIG (JOB_NAME, POOL_JOB_LOADER_CLASS_NAME, POOL_JOB_LOADER_PROPS, POOL_JOB_PROCESSOR_CLASS_NAME, POOL_JOB_PROCESSOR_THREAD_CNT, POOL_JOB_PROCESSOR_PROPS, JOB_POOL_CLASS_NAME, JOB_POOL_PROPS) values ('process_file_abc','com.mycompany.batch.processfileabc.AbcJobLoader','pool-job-loader-key1=loader-value1','com.mycompany.batch.processfileabc.AbcJobProcessor',5,'pool-job-processor-key1=processor-value1','org.jmonks.batchserver.framework.controller.pool.DefaultJobPool','job-pool-size=5000');
	
insert into BASIC_JOB_CONTROLLER_CONFIG	(JOB_NAME, BASIC_JOB_PROCESSOR_CLASS_NAME, BASIC_JOB_PROCESSOR_THREAD_CNT, BASIC_JOB_PROCESSOR_PROPS) values ('process_file_xyz', 'com.mycompany.batch.processfilexyz.XyzProcessor', 1, 'basic-job-processor-key1=processor-value1');
--- NEW FILE: create_job_data_transfer.sql ---
DROP TABLE IF EXISTS `batchserver`.`job_data_transfer`;
CREATE TABLE  `batchserver`.`job_data_transfer` (
  `SOURCE_JOB_NAME` varchar(64) NOT NULL default '' COMMENT 'Source job Name.',
  `DESTINATION_JOB_NAME` varchar(64) NOT NULL default '' COMMENT 'Destination Job Name',
  `JOB_DATA_IDENTIFIER` varchar(256) NOT NULL default '' COMMENT 'Identifier used to recognize the data.',
  `JOB_DATA` blob NOT NULL COMMENT 'Data to be transferred from source job to destination job.',
  PRIMARY KEY  (`DESTINATION_JOB_NAME`,`source_job_name`,`JOB_DATA_IDENTIFIER`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Tables holds all the data being transferred between the jobs';
--- NEW FILE: create_pool_job_controller_config.sql ---
DROP TABLE IF EXISTS `batchserver`.`pool_job_controller_config`;
CREATE TABLE  `batchserver`.`pool_job_controller_config` (
  `JOB_NAME` varchar(64) NOT NULL default '' COMMENT 'Name of the job this controller configuration belongs to.',
  `POOL_JOB_LOADER_CLASS_NAME` varchar(256) NOT NULL default '' COMMENT 'Pool Job Loader class name.',
  `POOL_JOB_LOADER_PROPS` varchar(1024) default NULL COMMENT 'Column holds pool job loader configuration properties in the format name1=value1:name2=value2',
  `POOL_JOB_PROCESSOR_CLASS_NAME` varchar(256) NOT NULL default '' COMMENT 'Pool job processor class name.',
  `POOL_JOB_PROCESSOR_PROPS` varchar(1024) default NULL COMMENT 'Column holds pool job processor configuration properties in the format name1=value1:name2=value2',
  `POOL_JOB_PROCESSOR_THREAD_CNT` decimal(10,0) NOT NULL default '0' COMMENT 'Number of processor instances needs to be run.',
  `JOB_POOL_CLASS_NAME` varchar(256) NOT NULL default '' COMMENT 'Job pool class name.',
  `JOB_POOL_PROPS` varchar(1024) default NULL COMMENT 'Column holds job pool configuration properties in the format name1=value1:name2=value2',
  PRIMARY KEY  (`JOB_NAME`),
  CONSTRAINT `FK_POOL_JC_CONFIG_JOB_CONFIG` FOREIGN KEY (`JOB_NAME`) REFERENCES `job_config` (`JOB_NAME`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table holds the pool job controller configuration.; InnoDB f';
--- NEW FILE: create_job_logging_config.sql ---
DROP TABLE IF EXISTS `batchserver`.`job_logging_config`;
CREATE TABLE  `batchserver`.`job_logging_config` (
  `JOB_NAME` varchar(64) NOT NULL default '' COMMENT 'Column represents the job name.',
  `JOB_LOGGER_NAME` varchar(256) NOT NULL default '' COMMENT 'Column holds the logger name.',
  `JOB_LOGGER_LEVEL` varchar(32) NOT NULL default '' COMMENT 'Column holds the logger level.',
  PRIMARY KEY  (`JOB_NAME`,`JOB_LOGGER_NAME`),
  CONSTRAINT `FK_JOB_LOGGING_CONFIG` FOREIGN KEY (`JOB_NAME`) REFERENCES `job_config` (`JOB_NAME`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table holds the logging configuration of the job.';
--- NEW FILE: create_job_mgmt_mntr_info.sql ---
DROP TABLE IF EXISTS `batchserver`.`job_mgmt_mntr_info`;
CREATE TABLE  `batchserver`.`job_mgmt_mntr_info` (
  `JOB_NAME` varchar(64) NOT NULL default '' COMMENT 'Job Name.',
  `JOB_INFO` blob NOT NULL COMMENT 'Management and monitor information',
  PRIMARY KEY  (`JOB_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Holds the jobs management and monitoring info.';
--- NEW FILE: create_basic_job_controller_config.sql ---
DROP TABLE IF EXISTS `batchserver`.`basic_job_controller_config`;
CREATE TABLE  `batchserver`.`basic_job_controller_config` (
  `JOB_NAME` varchar(64) NOT NULL default '' COMMENT 'Name of the job this controller configuration belongs to.',
  `BASIC_JOB_PROCESSOR_CLASS_NAME` varchar(256) NOT NULL default '' COMMENT 'Class name of the basic job processor.',
  `BASIC_JOB_PROCESSOR_THREAD_CNT` decimal(10,0) NOT NULL default '0' COMMENT 'Number of basic job processor instances to be run.',
  `BASIC_JOB_PROCESSOR_PROPS` varchar(1024) default NULL COMMENT 'Column holds basic job processor configuration properties in the format name1=value1:name2=value2',
  PRIMARY KEY  (`JOB_NAME`),
  CONSTRAINT `FK_JOB_CONFIG_JOB_NAME` FOREIGN KEY (`JOB_NAME`) REFERENCES `job_config` (`JOB_NAME`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table holds the basic job controller configuration.';