How to add sql queries in Itemreader class

Question

I want to use sql static queries in my reader class. But queries are quite big hence not adding to xml file. Then how to write multiple queries in reader class ?

Thanks in advance

Liviu Stirb · Accepted Answer · 2014-01-13 15:46:48Z

2

quick and dirty; just extend JdbcCursorItemReader and set the sql from there:

public class StaticSqlJdbcCursorItemReader extends JdbcCursorItemReader {
    //extend your reader
  public static final STATIC_SQL = "select * from ..." 

  public StaticSqlJdbcCursorItemReader() {
        setSql(STATIC_SQL);
    }

}

edited Jan 13, 2014 at 15:46

answered Feb 21, 2013 at 15:56

Liviu Stirb

6,0953 gold badges39 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add sql queries in Itemreader class

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related