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

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

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

Added Files:
	create_basic_job_controller_config.sql 
	create_pool_job_controller_config.sql 
Removed Files:
	create_basic_job_controller.sql create_pool_job_controller.sql 
Log Message:
no message

--- create_pool_job_controller.sql DELETED ---

--- NEW FILE: create_basic_job_controller_config.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);

--- NEW FILE: create_pool_job_controller_config.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);
--- create_basic_job_controller.sql DELETED ---