Examples of HsqlPagingQueryProvider

Examples of org.springframework.batch.item.database.support.HsqlPagingQueryProvider

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
    @Override
  protected ItemReader<Foo> createItemReader() throws Exception {

    JdbcPagingItemReader<Foo> inputSource = new JdbcPagingItemReader<Foo>();
    inputSource.setDataSource(dataSource);
    HsqlPagingQueryProvider queryProvider = new HsqlPagingQueryProvider();
    queryProvider.setSelectClause("select ID, NAME, VALUE");
    queryProvider.setFromClause("from T_FOOS");
    Map<String, Order> sortKeys = new LinkedHashMap<String, Order>();
    sortKeys.put("ID", Order.ASCENDING);
    queryProvider.setSortKeys(sortKeys);
    inputSource.setQueryProvider(queryProvider);
    inputSource.setRowMapper(
        new ParameterizedRowMapper<Foo>() {
                    @Override
          public Foo mapRow(ResultSet rs, int i) throws SQLException {
View Full Code Here

Examples of org.springframework.batch.item.database.support.HsqlPagingQueryProvider

53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
        }
        super.doJumpToPage(itemIndex);
      }
    };
    reader.setDataSource(dataSource);
    HsqlPagingQueryProvider queryProvider = new HsqlPagingQueryProvider();
    queryProvider.setSelectClause("select ID, NAME, VALUE");
    queryProvider.setFromClause("from T_FOOS");
    queryProvider.setWhereClause("where VALUE >= ?");
    Map<String, Order> sortKeys = new LinkedHashMap<String, Order>();
    sortKeys.put("ID", Order.ASCENDING);
    queryProvider.setSortKeys(sortKeys);
    reader.setParameterValues(Collections.<String, Object>singletonMap("limit", 2));
    reader.setQueryProvider(queryProvider);
    reader.setRowMapper(
        new ParameterizedRowMapper<Foo>() {
                    @Override
View Full Code Here

Examples of org.springframework.batch.item.database.support.HsqlPagingQueryProvider

52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
        }
        super.doJumpToPage(itemIndex);
      }
    };
    reader.setDataSource(dataSource);
    HsqlPagingQueryProvider queryProvider = new HsqlPagingQueryProvider();
    queryProvider.setSelectClause("select ID, NAME, VALUE");
    queryProvider.setFromClause("from T_FOOS");
    queryProvider.setWhereClause("where VALUE >= :limit");
    Map<String, Order> sortKeys = new LinkedHashMap<String, Order>();
    sortKeys.put("ID", Order.ASCENDING);
    queryProvider.setSortKeys(sortKeys);
    reader.setParameterValues(Collections.<String, Object>singletonMap("limit", 2));
    reader.setQueryProvider(queryProvider);
    reader.setRowMapper(
        new ParameterizedRowMapper<Foo>() {
                    @Override
View Full Code Here

Examples of org.springframework.batch.item.database.support.HsqlPagingQueryProvider

153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
  protected ItemReader<Foo> getItemReader() throws Exception {

    JdbcPagingItemReader<Foo> reader = new JdbcPagingItemReader<Foo>();
    reader.setDataSource(dataSource);
    HsqlPagingQueryProvider queryProvider = new HsqlPagingQueryProvider();
    queryProvider.setSelectClause("select ID, NAME, VALUE");
    queryProvider.setFromClause("from T_FOOS");
    Map<String, Order> sortKeys = new LinkedHashMap<String, Order>();
    sortKeys.put("ID", Order.ASCENDING);
    queryProvider.setSortKeys(sortKeys);
    reader.setQueryProvider(queryProvider);
    reader.setRowMapper(new ParameterizedRowMapper<Foo>() {
            @Override
      public Foo mapRow(ResultSet rs, int i) throws SQLException {
        Foo foo = new Foo();
View Full Code Here

Examples of org.springframework.batch.item.database.support.HsqlPagingQueryProvider

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
    @Override
  protected ItemReader<Foo> createItemReader() throws Exception {

    JdbcPagingItemReader<Foo> inputSource = new JdbcPagingItemReader<Foo>();
    inputSource.setDataSource(dataSource);
    HsqlPagingQueryProvider queryProvider = new HsqlPagingQueryProvider();
    queryProvider.setSelectClause("select ID, NAME, VALUE");
    queryProvider.setFromClause("from T_FOOS");
    Map<String, Order> sortKeys = new LinkedHashMap<String, Order>();
    sortKeys.put("VALUE", Order.ASCENDING);
    sortKeys.put("NAME", Order.DESCENDING);
    queryProvider.setSortKeys(sortKeys);
    inputSource.setQueryProvider(queryProvider);
    inputSource.setRowMapper(
        new ParameterizedRowMapper<Foo>() {
                    @Override
          public Foo mapRow(ResultSet rs, int i) throws SQLException {
View Full Code Here

Examples of org.springframework.batch.item.database.support.HsqlPagingQueryProvider

48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
    @Override
  protected ItemReader<Foo> getItemReader() throws Exception {

    JdbcPagingItemReader<Foo> reader = new JdbcPagingItemReader<Foo>();
    reader.setDataSource(dataSource);
    HsqlPagingQueryProvider queryProvider = new HsqlPagingQueryProvider();
    queryProvider.setSelectClause("select ID, NAME, VALUE");
    queryProvider.setFromClause("from T_FOOS");
    Map<String, Order> sortKeys = new LinkedHashMap<String, Order>();
    sortKeys.put("ID", Order.ASCENDING);
    queryProvider.setSortKeys(sortKeys);
    reader.setQueryProvider(queryProvider);
    reader.setRowMapper(
        new ParameterizedRowMapper<Foo>() {
                    @Override
          public Foo mapRow(ResultSet rs, int i) throws SQLException {
View Full Code Here

Examples of org.springframework.batch.item.database.support.HsqlPagingQueryProvider

79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
    @Override
  protected void pointToEmptyInput(ItemReader<Foo> tested) throws Exception {
    JdbcPagingItemReader<Foo> reader = (JdbcPagingItemReader<Foo>) tested;
    reader.close();
    reader.setDataSource(dataSource);
    HsqlPagingQueryProvider queryProvider = new HsqlPagingQueryProvider();
    queryProvider.setSelectClause("select ID, NAME, VALUE");
    queryProvider.setFromClause("from T_FOOS");
    queryProvider.setWhereClause("where ID = -1");
    Map<String, Order> sortKeys = new LinkedHashMap<String, Order>();
    sortKeys.put("ID", Order.ASCENDING);
    queryProvider.setSortKeys(sortKeys);
    reader.setQueryProvider(queryProvider);
    reader.setPageSize(3);
    reader.afterPropertiesSet();
    reader.open(new ExecutionContext());
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.