Re: SQL Component : Error while Inserting record in db table

2010-06-10 Thread Roman Kalukiewicz
2010/6/10 mevikasg : > > Hi Roman, > > Thanks for the reply. > > I have already tried it but no luck. > > Infact, tried following too: > >   errorHandler(deadLetterChannel("mock:error")) >  from("imaps://imap.gmail.com?username=testm...@gmail.com&password=" > >  +"&deleteProcessedMessages=false

Re: SQL Component : Error while Inserting record in db table

2010-06-10 Thread Roman Kalukiewicz
Hello, In camel-sql component you should use # sign instead of ? as question marks has its own meaning in URL notation. Unfortunately it looks that you cannot really use # sign itself, as it will be converted to questionmark (so your '#' will become '?'). I'll create a a bug for this # sign prob

Re: request reply with sql query

2009-10-19 Thread Roman Kalukiewicz
This is DEBUG level. If you set DEBUG you somehow agree to see a lot of junk ;) Just raise log4j log level for this logger (or simply for org.springframework). BTW this is perfectly valid behavior - Spring-JMS just logs those things on DEBUG level. Roman 2009/10/19 linuca > > But I want Active

Re: sql throwing oracle 17004 ORA-17004 error

2009-10-19 Thread Roman Kalukiewicz
I believe before you send your message to jms endpoint you should clear your message body. SQL componet assumes your body is used as query parameters. If you don't have any parameters in your query, but you send some body, there could be an exception thrown. Roman 2009/10/19 SoaMattH > > > If

Re: Route Camel : Pass variables in a SQL query

2009-09-27 Thread Roman Kalukiewicz
You set the body to constant value, so you have constant value. Use EL expression instead of constant one if you want it to be evaluated. In simple words put where you have ;) Roman 2009/9/27 titexe : > > Hello, > > I'm trying to develop a route camel who can: > > Retrieve a value from the hea

Re: config datasource sql server

2009-09-23 Thread Roman Kalukiewicz
Hey! Looks like you should do what exception tells you to do: please check your classpath contains the needed jar camel component. that is camel-jdbc.jar. If you have it on your classpath, then we will look into different reasons. Roman 2009/9/23 titexe : > > Hello, > > I'm just a beginner, I

Re: dynamic sql request

2009-08-07 Thread Roman Kalukiewicz
You can also use SQL component this way: from("jms:q_in") .transform(XPathBuilder.xpath("/Listes/Liste/id").stringResult()) .to("sql:SELECT * FROM v_test WHERE indv=#") .to("somewhere else"); Roman 2009/8/7 Claus Ibsen : > On Thu, Aug 6, 2009 at 7:09 PM, abdes wrote: >> >> Hi, >> i have diffficu

Re: Camel 2.0-snapshot deployed on SMKNL4 - There are 2 parameters that couldn't be set on the endpoint

2009-08-03 Thread Roman Kalukiewicz
When you use & in XML document it has to be written as & as single & starts escape sequences in XML. The same goes to '<' that is written as < and to other special symbols. Roman 2009/8/3 SoaMattH : > > The #{} is my custom place holder configurer. > > > uri="file://#{omsws.incident.file.landing

Re: Load Balancing Questions

2009-07-29 Thread Roman Kalukiewicz
Hello Carlo! You can try StickyLoadBalancer instead of regular one and have an expression that returns the current thread like from("direct:start").loadBalance(). sticky(new Expression() { public evaluate(Exchange e, Thread.class){return Thread.currentThread();}}).to("mock:x", "moc

Re: How to avoid a org.apache.camel.component.bean.AmbiguousMethodCallException when calling methods of a Bean component

2009-07-14 Thread Roman Kalukiewicz
You can always send BeanInvocation instance as your body. Then you can choose whatever method you want in your payload. Roman 2009/7/14 Charles Moulliard : > Hi, > > Is there any other workaround except renaming the method "updatStatus" to > avoid to have an error : AmbiguousMethodCallException.

Re: XML Validation throws NoXmlBodyValidationException

2009-06-23 Thread Roman Kalukiewicz
2009/6/23 Claus Ibsen : > Hi > I think the ValidatingProcessor was created like this using DOMSource and > DOMResult. > > I wonder if it can use SaxSource and SaxResult instead, in case its faster > and uses less CPU resources. I guess it could be, but according to [1] it has to be either DOMSourc

Re: end() method in a route

2009-06-10 Thread Roman Kalukiewicz
BTW The message in the Exception could be more clear. It is not obvious what "Root node with no active block" is ;) Roman 2009/6/10 Claus Ibsen : > On Wed, Jun 10, 2009 at 1:09 PM, Peter Maas wrote: >> Hi, >> >> I wondered what the purpose of the 'end' method in a route is. I sort of >> expected

Re: How long do the camel headers live in routes?

2009-05-06 Thread Roman Kalukiewicz
2009/5/6 Matteo Redaelli : > > Thanks Claus for you answer, I'll look at the XSD for any future issue. > > But sorry for the silly question: now that I can set a property, how can I > retrieve it in spring xml? > do I have to set a header with the value of my new property to use it in a > velocity

Re: How long do the camel headers live in routes?

2009-05-04 Thread Roman Kalukiewicz
2009/5/4 Matteo Redaelli : > > Thanks for your quick answer. > > Is it possibile to use SetProperty in Spring XML routes? Sure it is. Take a look at camel schema for XML routes: http://camel.apache.org/schema/spring/camel-spring.xsd there is setProperty element defined and you can use it the sam

Re: How long do the camel headers live in routes?

2009-05-04 Thread Roman Kalukiewicz
Ciao Matteo! You can use exchange properties for this. You do it using setProperty() instead of setHeader() and they live as long as the flow. Headers can be lost at endpoints basically as they usually represent some component specific things (request headers in http protocol are different than r

Re: Error handling Questions

2009-05-04 Thread Roman Kalukiewicz
In Camel 1.x there is AsyncProcessor interface (it extends Processor) that allows you to handle things asynchronously. While it is rather hard to use it, you have a chance to process your request asynchronously. In fact Camel doesn't specify if error handling will happen in some thread or not - it

Re: Asynchronous Jetty

2009-04-27 Thread Roman Kalukiewicz
2009/4/24 Aaron Mulder : > I have a situation where a request comes in to Jetty, and goes through > two other routes and queues before a response is generated that allows > the HTTP response to be sent to the caller.  I'd like to be able to > force Jetty into using continuations so it doesn't park

Re: Camel Content Filter

2009-04-27 Thread Roman Kalukiewicz
You can save the body in some header first, do the validation and then reset the body using the header like .setHeader("old", body()) .transform(xquery()) .to("validate:mySchema.xsl") .transform(header("old")) Roman 2009/4/22 ychawla : > > Hello All, > I have a question about the usage of the co

Re: programatically rewire routes

2009-04-27 Thread Roman Kalukiewicz
Another thing you can do is to substitute some endpoints in the context like this (assuming you use ContextTestSupport): protected CamelContext createCamelContext() throws Exception { CamelContext camelContext = super.createCamelContext(); camelContext.addEndpoint("jms:in.queue

Re: thoughts on the method names for the requestBody and requestBodyAndHeader etc

2009-04-20 Thread Roman Kalukiewicz
in method names. Roman 2009/4/20 Claus Ibsen : > On Sun, Apr 19, 2009 at 8:44 PM, Roman Kalukiewicz > wrote: >> Hello Claus, >> >> You asked for thoughts, so here they are ;) > Great the more the better. This is now you have the chance to > influence the API befor

Re: Composed Message Processor

2009-04-19 Thread Roman Kalukiewicz
2009/4/19 Frank Schwarz : > > Hi, > > I am trying to realize a composed message processor - without luck so far. > > The messages get perfectly split, but I am not sure, how to realize the > aggregation later on. > > Is there any built-in correlation criteria for the aggregation? > > The documentat

Re: Payload Gets Nulled Out

2009-04-19 Thread Roman Kalukiewicz
2009/4/18 Claus Ibsen : > We could add boolean hasOut() as a method on the Exchange. > Then you can test whether an OUT has been set or not. > > even though getOut(false) does exactly that. Returning null if no OUT exists. This is not my point, that there is no clear way of verifying if there is o

Re: thoughts on the method names for the requestBody and requestBodyAndHeader etc

2009-04-19 Thread Roman Kalukiewicz
Hello Claus, You asked for thoughts, so here they are ;) What about totally different approach, that would be a pattern parameter instead of a method name. Especially that those methods differ only in pattern set on the exchange. In fact I believe the best approach would be to have sendMessage()

Re: Payload Gets Nulled Out

2009-04-18 Thread Roman Kalukiewicz
Hello, Just a quick note here. People usually get confused by what happens in getOut() method. Sometimes people just want to check if out message simply exists and they call getOut(). What happens is out message being created that is not what usually happens with methods that conform to JavaBeans

Re: Camel transactions with in-out JMS

2009-04-08 Thread Roman Kalukiewicz
ion requests are not transactional, so you can have duplicates if original request is rolled back and redelivered. Roman 2009/4/8 Claus Ibsen > Hi > > Just a quick reply. > > There is a trasactedInOut URI option for the JMS component. Have you > looked at it? > > > On Tue, Apr

Camel transactions with in-out JMS

2009-04-07 Thread Roman Kalukiewicz
t then we don't have a way to listen only for our responses and to receive all responses in the same transaction. Maybe some of you have any thoughts on this problem? Cheers Roman Kalukiewicz

Re: Combination of filters

2009-02-25 Thread Roman Kalukiewicz
2009/2/25 david_geary : > > Hi, > > I'm using an xpath filter in the xml configuration eg > > > //cs:case/@queue="13" > > > > What's the easiest way to combine filters eg I want to accept it if its on > queue 13 OR 14 (or if on queue 13 AND some other attribute is a particular > value?) > > I kn

Re: understanding SEDA and Thread processor

2009-02-04 Thread Roman Kalukiewicz
2009/2/3 huntc : > > I think that what you're looking for is something akin to the > "concurrentConsumers" parameter for a JMS endpoint. > My recommendation is to raise a JIRA request for an enhancement so that the > SEDA endpoint can receive a concurrentConsumers parameter. After all seems > to m

Re: sql component with no parameters

2009-01-21 Thread Roman Kalukiewicz
Thanks for pointing it out! I created a JIRA for this problem already and I'm going to have it fixed ASAP. https://issues.apache.org/activemq/browse/CAMEL-1283 Roman 2009/1/21 nojonojo > > From observing behavior and looking at the code of SqlProducer, it doesn't > seem like it's possible to