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