Announcement Announcement Module
Collapse
No announcement yet.
Sybase jobrepository job id generation. Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sybase jobrepository job id generation.

    Hi,

    I am using the spring batch 2.1.9. The jobRepository is setup using the sybase database. Everything is running fine. But while creation of job-ids the job ids are not in sequential manner. Every day the sequence is prefixes with different number and generating the job ids from one. I want the behaviour to start the sequenece number from 1 and continues by incrementing by 1 for every new job.

    Is any setting at xml level or database level needs to change ?

    The job repository is defined as
    Code:
    	<bean id="jobRepository" init-method=""
    		class="org.springframework.batch.core.repository.support.JobRepositoryFactoryBean">
    		<property name="dataSource" ref="dataSource" />
    		<property name="transactionManager" ref="transactionManager" />
    		<property name="isolationLevelForCreate" value="ISOLATION_DEFAULT" />
    		<property name="databaseType" value="sybase" />
    		<property name="tablePrefix" value="BATCH_" />
    		<property name="lobHandler" ref="lobHandler" />
    	</bean>
    and the sequence table definition from jar is

    Code:
    CREATE TABLE BATCH_STEP_EXECUTION_SEQ (ID BIGINT IDENTITY);
    CREATE TABLE BATCH_JOB_EXECUTION_SEQ (ID BIGINT IDENTITY);
    CREATE TABLE BATCH_JOB_SEQ (ID BIGINT IDENTITY);
    Thanks
    Narendra Dhande

  • #2
    I want to generate end of day report about the data loaded into these tables.

    Comment

    Working...
    X