CODEWITHSUNDEEP
javaspringspring-batch
Shriram
Shriram

Reputation: 103

Spring Batch How to read multiple table (queries) as Reader and write it as flat file write

In my project I have read multiple tables with different queries and consolidate those results sets in flat files. How do I achieve that. I mean JdbcReader is directly taking 1 select query, how can I customize it.

Upvotes: 5

Views: 10142

Answers (1)

Serkan Arıkuşu
Serkan Arıkuşu

Reputation: 5619

If JdbcCursorItemReader does not suit your needs, you are always free to implement a custom reader by implementing the ItemReader interface.

public interface ItemReader<T> {
        T read() throws Exception, UnexpectedInputException, ParseException;
}

Just write a class that implements this interface and inject a jdbcTemplate to query multiple tables.

public Class MyCompositeJdbcReader implements ItemReader<ConsolidateResult>{
    private JdbcTemplate jdbcTemplate;

    public ConsolidateResult read() 
       throws Exception, UnexpectedInputException, ParseException{
    ConsolidateResult cr = new ConsolidateResult();     

    String name= this.jdbcTemplate.queryForObject(
        "select name from customer where id = ?",new Object[]{1}, String.class);
    String phoneNumber= this.jdbcTemplate.queryForObject(
        "select phone from customer_contact where custid = ?",
        new Object[]{1},String.class);

    cr.setName(name);
    cr.setPhone(phoneNumber);
    return cr;
 }

}

I did not compile the code but I hope it gives an idea.

Upvotes: 6

Related Questions