Sybase jobrepository job id generation.

[ndhande]

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

	<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

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

[Alex001]

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