0

I am trying to create a Spring Batch POC with Java Configuration and PostGreSQL.

I have successfully created beans that would have otherwise been provided via the in memory DB using @EnableBatchProcessing and @EnableAutoConfiguration.

I am not able to get the beans (JobExplorer) to return a JobExecution list given a JobInstance bean created from the same JobExplorer bean.

The error I am getting is "Unable to deserialize the execution context" which seems to be coming from the method trying to deserialize the "SHORT_CONTEXT" field of the JOB_EXECUTION_CONTEXT table.

I have passed the created JobExplorer bean DefaultExecutionContextSerializer. Later passed a DefaultLobHandler with "wrapAsLob" set to True when I was still getting the error. 

@Bean
public JobRegistry jobRegistry() {
    JobRegistry jr = new MapJobRegistry();
    return jr;
}

@Bean
public JobRegistryBeanPostProcessor jobRegistryBeanPostProcessor() {
    JobRegistryBeanPostProcessor jrbpp = new JobRegistryBeanPostProcessor();
    jrbpp.setJobRegistry(jobRegistry());
    return jrbpp;
}

@Bean
public JobOperator jobOperator() {
    SimpleJobOperator sjo = new SimpleJobOperator();
    sjo.setJobExplorer(jobExplorer());
    sjo.setJobLauncher(jobLauncher());
    sjo.setJobRegistry(jobRegistry());
    sjo.setJobRepository(jobRepository());

    return sjo;
}

@Bean
public JobExplorer jobExplorer() {
    JobExplorerFactoryBean jefb = new JobExplorerFactoryBean();
    jefb.setDataSource(dataSource());
    jefb.setJdbcOperations(jdbcTemplate);
    jefb.setTablePrefix("batch_");  
    jefb.setSerializer(new DefaultExecutionContextSerializer());
    DefaultLobHandler lh = new DefaultLobHandler();
    lh.setWrapAsLob(true);
    jefb.setLobHandler(lh);
    JobExplorer je = null;
    try {
        je = jefb.getObject();
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return je;
}

@ConfigurationProperties(prefix = "spring.datasource")
@Bean
@Primary
public DataSource dataSource() {
    return DataSourceBuilder.create().build();
}

@Bean
public JobRepository jobRepository() {
    JobRepositoryFactoryBean jrfb = new JobRepositoryFactoryBean();
    jrfb.setDataSource(dataSource());
    jrfb.setDatabaseType("POSTGRES");
    jrfb.setTransactionManager(new ResourcelessTransactionManager());
    jrfb.setSerializer(new DefaultExecutionContextSerializer());
    jrfb.setTablePrefix("batch_");
    JobRepository jr = null;
    try {

        jr = (JobRepository)jrfb.getObject();
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return jr;
}

Below is the get method in my rest controller where I am trying handle generate a list of failed Job executions

@Autowired
JobLauncher jobLauncher;

@Autowired
JobRegistry jobRegistry;

@Autowired
JobOperator jobOperator;

@Autowired
JobExplorer jobExplorer;



@SuppressWarnings("unchecked")
@GetMapping("batch/failedJobs")
public Map<String, List<JobExecution>> getFailedJobs() {
    try {
        if (jobRegistry == null || jobOperator == null || jobExplorer == null) {
            System.out.println("job registry, operator or explorer is null");
        } else {
            Map<String, List<JobExecution>> allJobInstances = new HashMap<String, List<JobExecution>>();
            // Get all jobs
            jobRegistry.getJobNames().stream().forEach(jobName -> {
                jobExplorer.getJobInstances(jobName, 1, 1000).forEach(l -> {
                    System.out.println("jobName: " + jobName + " instance: " + l);
                });
                jobExplorer.getJobInstances(jobName, 1, 1000).stream().forEach(jobInstance -> {
                    List<JobExecution> execultionList = jobExplorer.getJobExecutions(jobInstance); //Failing here
                    if (execultionList != null) { 
                        System.out.println("" + execultionList);
                        execultionList.stream().forEach(l2 -> {
                            System.out.println("jobName: " + jobName + " instance: " + jobInstance
                                    + " jobExecution: " + l2);
                        });
                        if(allJobInstances.get(jobName) == null) {
                            allJobInstances.put(jobName, new ArrayList<JobExecution>());
                        }
                        allJobInstances.get(jobName).addAll((Collection<? extends JobExecution>) jobExplorer.getJobExecutions(jobInstance).stream().filter(e -> e.getStatus().equals(BatchStatus.FAILED)));
                    }else {
                        System.out.println("Could not get jobExecution for jobName " + jobName + " jobInstance: " + jobInstance);
                    }
                });
            });

            return allJobInstances;
        }

    }catch (Exception e) {
        System.out.println(e.getMessage());
        logger.info(e.getMessage());
    }
    return null;
}
Keshwan Ramlu
  • 1
  • 3

1 Answers1

0

I fixed a similar issue by changing to the Jackson2 serializer:

jefb.setSerializer(new Jackson2ExecutionContextStringSerializer());

You may try it.

Allan Yang
  • 1
  • 1