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 ---
|
