[Batchserver-cvs] batchserver/bin/dbscripts/oracle create_basic_job_controller.sql,NONE,1.1 create_job_config.sql,NONE,1.1 create_pool_job_controller.sql,NONE,1.1 insert_sample_jobs.sql,NONE,1.1

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

Update of /cvsroot/batchserver/batchserver/bin/dbscripts/oracle
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3900

Added Files:
	create_basic_job_controller.sql create_job_config.sql 
	create_pool_job_controller.sql insert_sample_jobs.sql 
Log Message:
no message

--- NEW FILE: create_pool_job_controller.sql ---
-- Create table pool job controller config
create table POOL_JOB_CONTROLLER_CONFIG
(
  JOB_NAME                      VARCHAR2(64) not null,
  POOL_JOB_LOADER_CLASS_NAME    VARCHAR2(256) not null,
  POOL_JOB_LOADER_PROPS         VARCHAR2(1024),
  POOL_JOB_PROCESSOR_CLASS_NAME VARCHAR2(256) not null,
  POOL_JOB_PROCESSOR_THREAD_CNT NUMBER not null,
  POOL_JOB_PROCESSOR_PROPS      VARCHAR2(1024),
  JOB_POOL_CLASS_NAME           VARCHAR2(256) not null,
  JOB_POOL_PROPS                VARCHAR2(1024)
);
-- Add comments to the columns 
comment on column POOL_JOB_CONTROLLER_CONFIG.JOB_NAME
  is 'Name of the job this controller configuration belongs to.';
comment on column POOL_JOB_CONTROLLER_CONFIG.POOL_JOB_LOADER_CLASS_NAME
  is 'Pool Job Loader class name.';
comment on column POOL_JOB_CONTROLLER_CONFIG.POOL_JOB_LOADER_PROPS
  is 'Column holds pool job loader configuration properties in the format name1=value1:name2=value2';
comment on column POOL_JOB_CONTROLLER_CONFIG.POOL_JOB_PROCESSOR_CLASS_NAME
  is 'Pool job processor class name.';
comment on column POOL_JOB_CONTROLLER_CONFIG.POOL_JOB_PROCESSOR_THREAD_CNT
  is 'Number of processor instances needs to be run.';  
comment on column POOL_JOB_CONTROLLER_CONFIG.POOL_JOB_PROCESSOR_PROPS
  is 'Column holds pool job processor configuration properties in the format name1=value1:name2=value2';
comment on column POOL_JOB_CONTROLLER_CONFIG.JOB_POOL_CLASS_NAME
  is 'Job pool class name.';
comment on column POOL_JOB_CONTROLLER_CONFIG.JOB_POOL_PROPS
  is 'Column holds job pool configuration properties in the format name1=value1:name2=value2';
-- Create/Recreate primary, unique and foreign key constraints 
alter table POOL_JOB_CONTROLLER_CONFIG
  add constraint FK_POOL_JC_CONFIG_JOB_CONFIG foreign key (JOB_NAME)
  references JOB_CONFIG (JOB_NAME) on delete cascade;
-- Create/Recreate check constraints 
alter table POOL_JOB_CONTROLLER_CONFIG
  add constraint CHK_POOL_PRCR_THREAD_COUNT
  check (POOL_JOB_PROCESSOR_THREAD_CNT >= 1);
--- NEW FILE: create_job_config.sql ---
-- Creating the table
create table JOB_CONFIG
(
  JOB_NAME   				VARCHAR2(64) not null,
  JOB_STATUS 				NUMBER default 1 not null,
  JOB_CONTROLLER_CLASS_NAME 		VARCHAR2(256) not null,
  JOB_CONTROLLER_PROPS      		VARCHAR2(1024)  
);
-- Add comments to the table 
comment on table JOB_CONFIG
  is 'Table holds the configuration of all the jobs.';
-- Add comments to the columns 
comment on column JOB_CONFIG.JOB_NAME
  is 'Column represents the job name.';
comment on column JOB_CONFIG.JOB_STATUS
  is 'Column states whether the job is active or inactive. 1 - active 0 - inactive';
comment on column JOB_CONFIG.JOB_CONTROLLER_CLASS_NAME
  is 'Column holds the controller class name.';
comment on column JOB_CONFIG.JOB_CONTROLLER_PROPS
  is 'Column holds job controller configuration properties in the format name1=value1:name2=value2';  
-- Create/Recreate primary, unique and foreign key constraints 
alter table JOB_CONFIG
  add constraint PK_JOB_CONFIG primary key (JOB_NAME);
-- Create/Recreate check constraints 
alter table JOB_CONFIG
  add constraint CHK_JOB_STATUS
  check (job_status in (0,1));

--- 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_basic_job_controller.sql ---
-- Create table basic_job_con
create table BASIC_JOB_CONTROLLER_CONFIG
(
  JOB_NAME                   		VARCHAR2(64) not null,
  BASIC_JOB_PROCESSOR_CLASS_NAME   	VARCHAR2(256) not null,
  BASIC_JOB_PROCESSOR_THREAD_CNT 	NUMBER not null,
  BASIC_JOB_PROCESSOR_PROPS 		VARCHAR2(1024)
);
-- Add comments to the table 
comment on table BASIC_JOB_CONTROLLER_CONFIG
  is 'Table holds the basic job controller configuration.';
-- Add comments to the columns 
comment on column BASIC_JOB_CONTROLLER_CONFIG.JOB_NAME
  is 'Name of the job this controller configuration belongs to.';
comment on column BASIC_JOB_CONTROLLER_CONFIG.BASIC_JOB_PROCESSOR_CLASS_NAME
  is 'Class name of the basic job processor.';
comment on column BASIC_JOB_CONTROLLER_CONFIG.BASIC_JOB_PROCESSOR_THREAD_CNT
  is 'Number of basic job processor instances to be run.';  
comment on column BASIC_JOB_CONTROLLER_CONFIG.BASIC_JOB_PROCESSOR_PROPS
  is 'Column holds basic job processor configuration properties in the format name1=value1:name2=value2';
-- Create/Recreate primary, unique and foreign key constraints 
alter table BASIC_JOB_CONTROLLER_CONFIG
  add constraint FK_JOB_CONFIG_JOB_NAME foreign key (JOB_NAME)
  references JOB_CONFIG (JOB_NAME) on delete cascade;
-- Create/Recreate check constraints 
alter table BASIC_JOB_CONTROLLER_CONFIG
  add constraint CHK_BASIC_PRCR_THREAD_COUNT
  check (BASIC_JOB_PROCESSOR_THREAD_CNT >= 1);