我面临的问题是,我从查询和分页配置中返回了记录,但我给出了错误的记录编号。分页配置不正确。分页返回较少的记录。
select * from SOME_TABLE where CLIENT_FILE_NM= 'process_abc.20150617024850' AND TXN_ID IS NOT NULL AND SOME_DATA IS NOT NULL order by CREATE_DT ASC;
<bean id="postItemReader"
class="org.springframework.batch.item.database.JdbcPagingItemReader"
scope="step">
<property name="dataSource" ref="dataSource" />
<property name="queryProvider">
<bean
class="org.springframework.batch.item.database.support.SqlPagingQueryProviderFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="selectClause" value="select *" />
<property name="fromClause" value="from SOME_TABLE" />
<property name="whereClause"
value="CLIENT_FILE_NM= :fileName AND TXN_ID IS NOT NULL AND SOME_DATA IS NOT NULL" />
<property name="sortKey" value="CREATE_DT" />
<!-- CARD_SETTL_STG_ID_PK ASC -->
</bean>
</property>
<property name="parameterValues">
<map>
<entry key="fileName" value="#
{jobParameters['fileName']}" />
</map>
</property>
<property name="pageSize" value="10" />
<property name="rowMapper">
<bean class="com.wdpr.payment.batch.mapper.OutputVOMapper" />
</property>
<property name="saveState" value="false"/>
</bean>
解决了问题,因为sortKey必须是唯一键。Spring以以下格式创建查询:SELECT * FROM (SELECT * FROM CRD_SETTL WHERE CLIENT_FILE_NM= :fileName AND TXN_ID IS NOT NULL AND SETTL_DATA IS NOT NULL ORDER BY CREATE_DT ASC) WHERE ROWNUM <= 10 AND ((CREATE_DT > :_CREATE_DT))
并且记录将丢失。
<property name="sortKey" value="CREATE_DT" />
//这不是唯一的...
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句