Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
/*
* Copyright 2013 International Business Machines Corp.
*
* See the NOTICE file distributed with this work for additional information
* regarding copyright ownership. Licensed under the Apache License,
* Version 2.0 (the "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.ibm.jbatch.container.services.impl;
interface JDBCPersistenceManagerSQLConstants {
final String JOBSTATUS_TABLE = "JOBSTATUS";
final String STEPSTATUS_TABLE = "STEPSTATUS";
final String CHECKPOINTDATA_TABLE = "CHECKPOINTDATA";
final String JOBINSTANCEDATA_TABLE = "JOBINSTANCEDATA";
final String EXECUTIONINSTANCEDATA_TABLE = "EXECUTIONINSTANCEDATA";
final String STEPEXECUTIONINSTANCEDATA_TABLE = "STEPEXECUTIONINSTANCEDATA";
final String CREATE_TAB_JOBSTATUS = "CREATE TABLE JOBSTATUS("
+ "id BIGINT CONSTRAINT JOBSTATUS_PK PRIMARY KEY,"
+ "obj BLOB,"
+ "CONSTRAINT JOBSTATUS_JOBINST_FK FOREIGN KEY (id) REFERENCES JOBINSTANCEDATA (jobinstanceid) ON DELETE CASCADE)";
final String CREATE_TAB_STEPSTATUS = "CREATE TABLE STEPSTATUS("
+ "id BIGINT CONSTRAINT STEPSTATUS_PK PRIMARY KEY,"
+ "obj BLOB,"
+ "CONSTRAINT STEPSTATUS_STEPEXEC_FK FOREIGN KEY (id) REFERENCES STEPEXECUTIONINSTANCEDATA (stepexecid) ON DELETE CASCADE)";
final String CREATE_TAB_CHECKPOINTDATA = "CREATE TABLE CHECKPOINTDATA("
+ "id VARCHAR(512),obj BLOB)";
final String CREATE_TAB_JOBINSTANCEDATA = "CREATE TABLE JOBINSTANCEDATA("
+ "jobinstanceid BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) CONSTRAINT JOBINSTANCE_PK PRIMARY KEY,"
+ "name VARCHAR(512),"
+ "apptag VARCHAR(512))";
final String CREATE_TAB_EXECUTIONINSTANCEDATA = "CREATE TABLE EXECUTIONINSTANCEDATA("
+ "jobexecid BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) CONSTRAINT JOBEXECUTION_PK PRIMARY KEY,"
+ "jobinstanceid BIGINT,"
+ "createtime TIMESTAMP,"
+ "starttime TIMESTAMP,"
+ "endtime TIMESTAMP,"
+ "updatetime TIMESTAMP,"
+ "parameters BLOB,"
+ "batchstatus VARCHAR(512),"
+ "exitstatus VARCHAR(512),"
+ "CONSTRAINT JOBINST_JOBEXEC_FK FOREIGN KEY (jobinstanceid) REFERENCES JOBINSTANCEDATA (jobinstanceid) ON DELETE CASCADE)";
final String CREATE_TAB_STEPEXECUTIONINSTANCEDATA = "CREATE TABLE STEPEXECUTIONINSTANCEDATA("
+ "stepexecid BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) CONSTRAINT STEPEXECUTION_PK PRIMARY KEY,"
+ "jobexecid BIGINT,"
+ "batchstatus VARCHAR(512),"
+ "exitstatus VARCHAR(512),"
+ "stepname VARCHAR(512),"
+ "readcount INTEGER,"
+ "writecount INTEGER,"
+ "commitcount INTEGER,"
+ "rollbackcount INTEGER,"
+ "readskipcount INTEGER,"
+ "processskipcount INTEGER,"
+ "filtercount INTEGER,"
+ "writeskipcount INTEGER,"
+ "startTime TIMESTAMP,"
+ "endTime TIMESTAMP,"
+ "persistentData BLOB,"
+ "CONSTRAINT JOBEXEC_STEPEXEC_FK FOREIGN KEY (jobexecid) REFERENCES EXECUTIONINSTANCEDATA (jobexecid) ON DELETE CASCADE)";
final String INSERT_JOBSTATUS = "insert into jobstatus values(?, ?)";
final String UPDATE_JOBSTATUS = "update jobstatus set obj = ? where id = ?";
final String SELECT_JOBSTATUS = "select id, obj from jobstatus where id = ?";
final String DELETE_JOBSTATUS = "delete from jobstatus where id = ?";
final String INSERT_STEPSTATUS = "insert into stepstatus values(?, ?)";
final String UPDATE_STEPSTATUS = "update stepstatus set obj = ? where id = ?";
final String SELECT_STEPSTATUS = "select id, obj from stepstatus where id = ?";
final String DELETE_STEPSTATUS = "delete from stepstatus where id = ?";
final String INSERT_CHECKPOINTDATA = "insert into checkpointdata values(?, ?)";
final String UPDATE_CHECKPOINTDATA = "update checkpointdata set obj = ? where id = ?";
final String SELECT_CHECKPOINTDATA = "select id, obj from checkpointdata where id = ?";
final String CREATE_CHECKPOINTDATA_INDEX = "create index chk_index on checkpointdata(id)";
final String DELETE_CHECKPOINTDATA = "delete from checkpointdata where id = ?";
// JOB OPERATOR QUERIES
final String INSERT_JOBINSTANCEDATA = "insert into jobinstancedata (name, apptag) values(?, ?)";
final String INSERT_EXECUTIONDATA = "insert into executionInstanceData (jobinstanceid, parameters) values(?, ?)";
final String SELECT_JOBINSTANCEDATA_COUNT = "select count(jobinstanceid) as jobinstancecount from jobinstancedata where name = ?";
final String SELECT_JOBINSTANCEDATA_IDS = "select jobinstanceid from jobinstancedata where name = ? order by jobinstanceid desc";
final String SELECT_JOBINSTANCEDATA_NAMES = "select name from jobinstancedata where apptag = ?";
final String SELECT_JOBINSTANCEDATA_APPTAG = "select apptag from jobinstancedata where jobinstanceid = ?";
final String START_TIME = "starttime";
final String CREATE_TIME = "createtime";
final String END_TIME = "endtime";
final String UPDATE_TIME = "updatetime";
final String BATCH_STATUS = "batchstatus";
final String EXIT_STATUS = "exitstatus";
final String INSTANCE_ID = "instanceId";
final String JOBEXEC_ID = "jobexecid";
final String STEPEXEC_ID = "stepexecid";
final String STEPCONTEXT = "stepcontext";
final String APPTAG = "apptag";
}
