Package org.springframework.batch.item.database

Examples of org.springframework.batch.item.database.PagingQueryProvider

90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
    factory.setSelectClause(selectClause);
   
    factory.setWhereClause(whereClause);
    factory.setSortKey(sortClause);
   
    PagingQueryProvider queryProvider = null;
    try {
      queryProvider = (PagingQueryProvider)factory.getObject();
    } catch (Exception e) {
      logger.error(e.getMessage(),e);
      return null;
    }
   
    String query = queryProvider.generateFirstPageQuery(maxResult);
   
   
    //this.getJdbcTemplate().setQueryTimeout(1000); 
   
   
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
    }
    else {
      whereClause = whereClause + " AND STEP_NAME = ?";
    }

    PagingQueryProvider queryProvider = getPagingQueryProvider(whereClause);

    List<StepExecution> stepExecutions;
    if (start <= 0) {
      stepExecutions = getJdbcTemplate().query(queryProvider.generateFirstPageQuery(count),
          new StepExecutionRowMapper(), jobName, stepName);
    }
    else {
      try {
        Long startAfterValue = getJdbcTemplate().queryForObject(
            queryProvider.generateJumpToItemQuery(start, count), Long.class, jobName, stepName);
        stepExecutions = getJdbcTemplate().query(queryProvider.generateRemainingPagesQuery(count),
            new StepExecutionRowMapper(), jobName, stepName, startAfterValue);
      }
      catch (IncorrectResultSizeDataAccessException e) {
        return Collections.emptyList();
      }
View Full Code Here
50
51
52
53
54
55
56
57
    factory.setDataSource(dataSource);
  }

  @Test
  public void testFactory() throws Exception {
    PagingQueryProvider provider = factory.getObject();
    assertNotNull(provider);
  }
View Full Code Here
67
68
69
70
71
72
73
74
  }

  @Test(expected=IllegalArgumentException.class)
  public void testNoDataSource() throws Exception {
    factory.setDataSource(null);
    PagingQueryProvider provider = factory.getObject();
    assertNotNull(provider);
  }
View Full Code Here
74
75
76
77
78
79
80
81
  }

  @Test(expected=IllegalArgumentException.class)
  public void testNoSortKey() throws Exception {
    factory.setSortKeys(null);
    PagingQueryProvider provider = factory.getObject();
    assertNotNull(provider);
  }
View Full Code Here
81
82
83
84
85
86
87
88
89
  }

  @Test
  public void testWhereClause() throws Exception {
    factory.setWhereClause("x=y");
    PagingQueryProvider provider = factory.getObject();
    String query = provider.generateFirstPageQuery(100);
    assertTrue("Wrong query: "+query, query.contains("x=y"));
  }
View Full Code Here
88
89
90
91
92
93
94
95
96
    assertTrue("Wrong query: "+query, query.contains("x=y"));
  }

  @Test
  public void testAscending() throws Exception {
    PagingQueryProvider provider = factory.getObject();
    String query = provider.generateFirstPageQuery(100);
    assertTrue("Wrong query: "+query, query.contains("ASC"));
  }
View Full Code Here
96
97
98
99
100
101
102
103
  }

  @Test(expected=IllegalArgumentException.class)
  public void testWrongDatabaseType() throws Exception {
    factory.setDatabaseType("NoSuchDb");
    PagingQueryProvider provider = factory.getObject();
    assertNotNull(provider);
  }
View Full Code Here
103
104
105
106
107
108
109
110
  }

  @Test(expected=IllegalArgumentException.class)
  public void testMissingMetaData() throws Exception {
    factory.setDataSource(DatabaseTypeTestUtils.getMockDataSource(new MetaDataAccessException("foo")));
    PagingQueryProvider provider = factory.getObject();
    assertNotNull(provider);
  }
View Full Code Here
111
112
113
114
115
116
117
118
119
  @Test
  public void testAllDatabaseTypes() throws Exception {
    for (DatabaseType type : DatabaseType.values()) {
      factory.setDatabaseType(type.name());
      PagingQueryProvider provider = factory.getObject();
      assertNotNull(provider);     
    }
  }
View Full Code Here
TOP

Related Classes of org.springframework.batch.item.database.PagingQueryProvider

  • de.scoopgmbh.copper.spring.audit.AuditTrailQueryEngine
  • org.springframework.batch.admin.service.JdbcSearchableStepExecutionDao
  • org.springframework.batch.item.database.support.SqlPagingQueryProviderFactoryBeanTests
    • Copyright © 2018 www.massapicom. 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.