Spring Batch: JOIN Query in SqlPagingQueryProviderFactoryBean not working -
i using 2.2.7.release
version of spring batch in project. have batch using jdbcpagingitemreader
read records db2. in have join on 2 tables , have conditions. @ last providing column want sort records. because using table aliases, giving me error. when skipping alias name, give problem while fetching next set of result. searched , found issue got resolved in 2.1.9 release couldn't find fix in later releases. has idea issue , solution too.
you can find code snippet of query configuration below.
<bean id="releasesqlpagingqueryprovider" class="org.springframework.batch.item.database.support.sqlpagingqueryproviderfactorybean"> <property name="datasource" ref="datasource" /> <property name="selectclause" value="select m.* " /> <property name="fromclause" value="from master m join release r on m.employee_id = r.employee_id " /> <property name="whereclause" > <value> <![cdata[ r.column_1 = ? ]]> </value> </property> <property name="sortkey" value="employee_id" />
Comments
Post a Comment