Hi,
I have a memory issue with the splitter.
I have a big table with millions of records in a sql server database 2008.
What I'm trying to do is :
<setBody>
<simple>select * from
myBigTable</simple>
</setBody>
<to uri="jdbc:myDataSource />
<split streaming="true" stopOnException="true">
<simple>${body}</simple>
<log message="Split line :
${body}" />
</split>
I'm getting an out of memory issue.
I tried to use the property
statement.fetchSize=10&statement.fetchDirection=1000 in the DataSource
Bean configuration. However it's still not working. It seems that the fetchsize
is not set by the apache jdbc component.
Best Wishest!
Cyrille Eloundou
Barclays-Global Technology
Java Solution architect
work:201 499 2921
cell: 646 522 1567
cell private: 347 978 5022
_______________________________________________
This message is for information purposes only, it is not a recommendation,
advice, offer or solicitation to buy or sell a product or service nor an
official confirmation of any transaction. It is directed at persons who are
professionals and is not intended for retail customer use. Intended for
recipient only. This message is subject to the terms at:
www.barclays.com/emaildisclaimer.
For important disclosures, please see:
www.barclays.com/salesandtradingdisclaimer regarding market commentary from
Barclays Sales and/or Trading, who are active market participants; and in
respect of Barclays Research, including disclosures relating to specific
issuers, please see http://publicresearch.barclays.com.
_______________________________________________
