Announcement Announcement Module
Collapse
No announcement yet.
schema-oracle10g.sql - Does not have complete script Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • schema-oracle10g.sql - Does not have complete script

    Hello All,

    I had downloaded 1.0 final release of Spring-Batch and when I looked at schema-oracle10g.sql, it does not have the script for all the tables (while mysql script has all).

    I found only create statements for following tables:
    BATCH_JOB_INSTANCE
    BATCH_JOB_EXECUTION
    BATCH_JOB_PARAMS
    BATCH_STEP_EXECUTION
    BATCH_STEP_EXECUTION_CONTEXT and the sequences

    Dont I need to have for following too?
    BATCH_STATGING_SEQ
    BATCH_STATING

    Can I get the complete script for Oracle?

    thanks!
    Last edited by hailspring; Apr 18th, 2008, 10:55 AM.

  • #2
    It looks complete to me, this is what I'm showing in the latest build:

    Code:
    -- Autogenerated: do not edit this file
    DROP TABLE  BATCH_STEP_EXECUTION_CONTEXT ;
    DROP TABLE  BATCH_STEP_EXECUTION ;
    DROP TABLE  BATCH_JOB_EXECUTION ;
    DROP TABLE  BATCH_JOB_PARAMS ;
    DROP TABLE  BATCH_JOB_INSTANCE ;
    
    DROP SEQUENCE  BATCH_STEP_EXECUTION_SEQ ;
    DROP SEQUENCE  BATCH_JOB_EXECUTION_SEQ ;
    DROP SEQUENCE  BATCH_JOB_SEQ ;
    
    -- Autogenerated: do not edit this file
    CREATE TABLE BATCH_JOB_INSTANCE  (
    	JOB_INSTANCE_ID NUMBER(38)  PRIMARY KEY ,  
    	VERSION NUMBER(38),  
    	JOB_NAME VARCHAR2(100) NOT NULL , 
    	JOB_KEY VARCHAR2(2500)
    ) ;
    
    CREATE TABLE BATCH_JOB_EXECUTION  (
    	JOB_EXECUTION_ID NUMBER(38)  PRIMARY KEY ,
    	VERSION NUMBER(38),  
    	JOB_INSTANCE_ID NUMBER(38) NOT NULL,
    	START_TIME TIMESTAMP DEFAULT NULL, 
    	END_TIME TIMESTAMP DEFAULT NULL,
    	STATUS VARCHAR2(10),
    	CONTINUABLE CHAR(1),
    	EXIT_CODE VARCHAR2(20),
    	EXIT_MESSAGE VARCHAR2(2500),
    	constraint JOB_INSTANCE_EXECUTION_FK foreign key (JOB_INSTANCE_ID)
    	references BATCH_JOB_INSTANCE(JOB_INSTANCE_ID)
    ) ;
    	
    CREATE TABLE BATCH_JOB_PARAMS  (
    	JOB_INSTANCE_ID NUMBER(38) NOT NULL ,
        TYPE_CD VARCHAR2(6) NOT NULL ,
    	KEY_NAME VARCHAR2(100) NOT NULL , 
    	STRING_VAL VARCHAR2(250) , 
    	DATE_VAL TIMESTAMP DEFAULT NULL,
    	LONG_VAL NUMBER(38) ,
    	DOUBLE_VAL NUMBER,
    	constraint JOB_INSTANCE_PARAMS_FK foreign key (JOB_INSTANCE_ID)
    	references BATCH_JOB_INSTANCE(JOB_INSTANCE_ID)
    ) ;
    	
    CREATE TABLE BATCH_STEP_EXECUTION  (
    	STEP_EXECUTION_ID NUMBER(38)  PRIMARY KEY ,
    	VERSION NUMBER(38) NOT NULL,  
    	STEP_NAME VARCHAR2(100) NOT NULL,
    	JOB_EXECUTION_ID NUMBER(38) NOT NULL,
    	START_TIME TIMESTAMP NOT NULL , 
    	END_TIME TIMESTAMP DEFAULT NULL,  
    	STATUS VARCHAR2(10),
    	COMMIT_COUNT NUMBER(38) , 
    	ITEM_COUNT NUMBER(38) , 
    	CONTINUABLE CHAR(1),
    	EXIT_CODE VARCHAR2(20),
    	EXIT_MESSAGE VARCHAR2(2500),
    	constraint JOB_EXECUTION_STEP_FK foreign key (JOB_EXECUTION_ID)
    	references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)
    ) ;
    	
    CREATE TABLE BATCH_STEP_EXECUTION_CONTEXT  (
    	STEP_EXECUTION_ID NUMBER(38) NOT NULL ,
        TYPE_CD VARCHAR2(6) NOT NULL ,
    	KEY_NAME VARCHAR2(1000) NOT NULL , 
    	STRING_VAL VARCHAR2(1000) , 
    	DATE_VAL TIMESTAMP DEFAULT NULL ,
    	LONG_VAL VARCHAR2(10) ,
    	DOUBLE_VAL NUMBER ,
        OBJECT_VAL BLOB,
    	constraint STEP_EXECUTION_CONTEXT_FK foreign key (STEP_EXECUTION_ID)
    	references BATCH_STEP_EXECUTION(STEP_EXECUTION_ID)
    ) ;
    
    CREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ;
    CREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ;
    CREATE SEQUENCE BATCH_JOB_SEQ;

    Comment


    • #3
      BATCH_STAGING and BATCH_STAGING_SEQ are not part of this script?

      Thanks!

      Comment


      • #4
        Now it looks like you're talking about the business-schema that's part of the samples project, which is a completely separate file.

        Comment


        • #5
          Hmm.. thats interesting!! I thought BATCH_STAGING and BATCH_STAGING_SEQ is part of core tables and are used for parallel job processing?

          So I do not need these two tables in order to run spring-batch (paralle job processing)?

          Thanks!

          Comment


          • #6
            Those two tables are part of an example of how one could do parrallel processing. The sample job is 'parallelJob'. However, it is just one way of doing it and certainly not core to the framework.

            Comment

            Working...
            X