Re: Question: camel-sql out of memory error

I fixed this at the database level by limiting how many rows can come back using SQL. Is there a reason camel does not allow the limiting of how many rows are pulled from the result set? Thanks! --Matt Payne On Fri, Aug 8, 2014 at 3:34 PM, Matt Payne wrote: > I am getting

Question: camel-sql out of memory error

e result set, rs, is going to be read regardless of how large it is. When stepping through via eclipse's debugger this is what I see happening. It's unclear how to ask camel sql component to only take X rows at a time. Is there a way to do this please? Thanks! --Matt Payne [1]

Re: Self-termination of a Camel program

I have this working using org.apache.camel.main.Main I can send an example after work. My guess is that someone will send an example before that. --Matt Payne On Thu, May 29, 2014 at 12:12 PM, Camel Guy wrote: > Hello again fellow riders, > > I would like to my camel program to

Re: Question: Processing exchange with until done?

e processor and the source code for this living within the processor. Perhaps using the routing slip EIP is the way to go with this? Any suggestions would be great appreciated please. Thanks! --Matt Payne // Use hopCount to index this... String preDeterminedRoute[] = { "direct:redWorker&

Question: Processing exchange with until done?

ed and the exchange does not need to be routed through the other processors. My question are: Is this a reasonable way to perform the work? Does this technique have an EIP pattern name please? Thanks! --Matt Payne

Re: sql component and delay

ble to combine things URL style. e.g. ?consumer.onConsume={{sql.oracle.markPart}} &consumer.delay=5000 I think this works and I have it working somewhere in my learning project[1]. I hope this helps --Matt Payne [1] https://github.com/payne/CamelSqlDemo/tree/master/CamelSqlDemo1 [2] http

Re: Question: generated keys and SQL component

ning generated keys in camel-sql. Feel >> free to log a JIRA ticket >> >> >> On Tue, Mar 18, 2014 at 10:00 PM, Matt Payne wrote: >>> Greetings! Would you please help me find an example of using the SQL[1] >>> component and inserting into a table where the pr

Question: generated keys and SQL component

I am using SQL[1] component rather than JDBC[2] component because the SQL component works with transactions. Would you please help me find an example of using the SQL[1] component and inserting into a table where the primary key is automatically generated? Thanks! --Matt Payne [1] http://came

Re: Help with SQL component please?

Sound have checked JIRA[1] before posting. Turns out the example[2] works fine with Derby instead of HSQL. Thanks! --Matt Payne [1] https://issues.apache.org/jira/browse/CAMEL-7251?jql=issuetype%20%3D%20Bug%20AND%20text%20~%20%22SqlProducer%22 [2] https://github.com/payne/CamelSqlDemo/tree

Help with SQL component please?

if (outputType == SqlOutputType.SelectList) { List> data = getEndpoint().queryForList(ps.getResultSet()); Thanks! --Matt Payne; cell: (402) 208 8787 [1] https://github.com/payne/CamelSqlDemo/tree/master/SqlRouteTestDemo [2] from("direct:inser