Spring Batch: Passing runtime parameters to query in ItemReader

Question

I have a spring batch program which reads from one database and writes to a file.

It has item reader as below:

<beans:bean id="myItemReader" class="org.springframework.batch.item.database.JdbcCursorItemReader">
    <beans:property name="dataSource" ref="jobRepository-dataSource" />
    <beans:property name="sql" value="${dbTofileDataReadSQL}"/>
    <beans:property name="rowMapper">
        <beans:bean class="com.mypackage.MyRowMapper" />
    </beans:property>
</beans:bean>

The sql is something like:

select one, two, three, four from myTable where business_date='12/12/11'

This line will go into my properties file:

dbTofileDataReadSQL = select one, two, three, four from myTable where business_date='12/12/11'

How to pass this business date at run time in the item reader so that it gets added in item reader.

Thanks for reading!!

dma_k · Accepted Answer · 2011-12-09 20:29:36Z

3

you can use late-binding with step scope or a simple PropertyPlaceholderConfigurer

<bean id="placeholderProperties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="location" value="path to your properties file, either classpath: ... or c:/... " />
</bean>

and if you need multi-line entries in your properties file, go like this

# sql, multiline property with \
sql=\
SELECT \
ID, \
NAME \
FROM TEST \
ORDER BY ID

Or starting from Spring 3, you can use SpEL:

<util:properties id="myProperties" location="..." />
...
<beans:bean ...
   <beans:property name="sql" value="#{myProperties.sql}"/>
</beans:bean>

edited Dec 9, 2011 at 20:29

dma_k

10.7k17 gold badges81 silver badges130 bronze badges

answered Dec 5, 2011 at 11:58

Michael Pralow

6,6302 gold badges32 silver badges48 bronze badges

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

1 Comment

Vicky Over a year ago

Thanks Michael.. I reached at this solution.. However, I had the updated date available in some other table. So used inner query. Can you please check my other question about skipping Item Writer in a step.

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

Have a placeholder in your property


dbTofileDataReadSQL = select one, two, three, four from myTable where business_date={0}

And check this answer that shows how to resolve it at runtime using MessageFormat class

Update:

With Spring, if you have that property file added to your resource bundle, you could retrieve the resolved value using ApplicationContext#getMessage


String getMessage(String code,
                  Object[] args,
                  Locale locale)
                  throws NoSuchMessageException

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Dec 5, 2011 at 7:25

stratwine

3,6992 gold badges28 silver badges32 bronze badges

Collectives™ on Stack Overflow

Spring Batch: Passing runtime parameters to query in ItemReader

2 Answers 2

1 Comment

Update:

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Update:

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related