RE: Memory issue while using the spliter EIP

2013-11-18 Thread cyrille.eloundou
] Sent: Monday, November 18, 2013 11:38 AM To: users@camel.apache.org Subject: Re: Memory issue while using the spliter EIP Hi I am not sure but maybe the fetchXXX options is only hints to the JDBC driver. As it may return the full data instead. So if you have millions of rows in the database table

Re: Memory issue while using the spliter EIP

2013-11-18 Thread Claus Ibsen
Hi I am not sure but maybe the fetchXXX options is only hints to the JDBC driver. As it may return the full data instead. So if you have millions of rows in the database table you get them all. You may write some SQL that is SQL server specific to tell it to only return first X rows. Each RDBMS

Memory issue while using the spliter EIP

2013-11-18 Thread cyrille.eloundou
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 : select * from myBigTable