How to stop encoding of query params value when we have some special characters in Apache Camel toD uri

2023-05-14 Thread Himanshi Jain
Hi, We have "/" in a query param as a value which has to be passed on to a rest API. But as soon as we add it in the header to be used with REST dsl it gets encoded %252F in the actual url. url=rest:get:/api/v1/some functionality --> this is saved in application.properties paramet

Re: MicrometerEventNotifierService Query

2022-08-04 Thread Claus Ibsen
tication where the username and password is in the uri, the > > password > > > is not being masked, is that correct? > > > not sure if is same like issue in > > > > > > > > > https://stackoverflow.com/questions/66262107/disable-camel-debezium-mysql-

Re: MicrometerEventNotifierService Query

2022-08-04 Thread Chio Chuan Ooi
> authentication where the username and password is in the uri, the > password > > is not being masked, is that correct? > > not sure if is same like issue in > > > > > https://stackoverflow.com/questions/66262107/disable-camel-debezium-mysql-endpoint-uri-in-camel-metrics

Re: MicrometerEventNotifierService Query

2022-07-28 Thread Claus Ibsen
ium-mysql-endpoint-uri-in-camel-metrics > > Where are the username and password, is it in the authority part or as query parameters? eg is it like http:foo:secret@myserver/mypath or like http:myserver/mypath?username=xxx&password= > > I am currently using camel version 3.1

MicrometerEventNotifierService Query

2022-07-21 Thread Chio Chuan Ooi
Hi All, I am exploring MicrometerEventNotifierService and need help on a few queries. 1. Is it possible to only capture a certain event? by having a filter, e.g only track endpoint with http(s) 2. I notice that when the endpoint is http endpoint that has basic authentication where the username an

Re: Re: Re: Square brackets in query param

2022-01-21 Thread Claus Ibsen
I have to upgrade then which version from > maven repo should I use ? > > Thanks, > > > > On 2022/01/20 19:04:26 Claus Ibsen wrote: > > Hi > > > > You can use a header with name CamelHttpQuery where you put the query > > parameters > > and then call the

RE: Re: Re: Square brackets in query param

2022-01-20 Thread Yebba, Nicholas
ery where you put the query > parameters > and then call the http endpoint as a static name (without the query) > then the square brackets should work > > > On Thu, Jan 20, 2022 at 10:35 AM Pasquale Congiusti > mailto:pa...@gmail.com>> wrote: > > > > Yeah,

Re: Re: Square brackets in query param

2022-01-20 Thread Claus Ibsen
Hi You can use a header with name CamelHttpQuery where you put the query parameters and then call the http endpoint as a static name (without the query) then the square brackets should work On Thu, Jan 20, 2022 at 10:35 AM Pasquale Congiusti wrote: > > Yeah, it seems RAW() only works

Re: Re: Square brackets in query param

2022-01-20 Thread Pasquale Congiusti
Yeah, it seems RAW() only works on the query parameter value. I've run some experiments and reported an issue here: https://issues.apache.org/jira/browse/CAMEL-17520 - likely it's a bug and we'll work on its resolution. Feel free to watch it on Jira or add any comments over

RE: Re: Square brackets in query param

2022-01-19 Thread Yebba, Nicholas
gards, > Pasquale. > > On Tue, Jan 18, 2022 at 8:47 PM Yebba, Nicholas > mailto:ny...@massmutual.com.invalid>> wrote: > > > Hi, I’ve run into an issue with Camel when using square brackets in query > > params. For example the following endpoint produces an error. > >

Re: Square brackets in query param

2022-01-19 Thread Pasquale Congiusti
sue with Camel when using square brackets in query > params. For example the following endpoint produces an error. > > https://api.degreed.com/api/v2/content?filter[end_date]=”2022-01-01” > > The error I receive is: > > Caused by: java.lang.IllegalArgumentException: Canno

Square brackets in query param

2022-01-18 Thread Yebba, Nicholas
Hi, I’ve run into an issue with Camel when using square brackets in query params. For example the following endpoint produces an error. https://api.degreed.com/api/v2/content?filter[end_date]=”2022-01-01” The error I receive is: Caused by: java.lang.IllegalArgumentException: Cannot set

Re: Passing exchange header into JPA component query

2021-08-25 Thread Calle Andersson
Ämne: Re: Passing exchange header into JPA component query Hi You can try test this with 3.11.x as there has been a number of improvements and bug fixes in the endpoint-dsl and whatnot since this release. On Tue, Aug 24, 2021 at 6:39 PM Calle Andersson wrote: > > Hi, > > I use Camel 3.

Re: Passing exchange header into JPA component query

2021-08-24 Thread Claus Ibsen
t; > I have the following query: > SELECT c FROM " + MyEntity.class.getName() + " c WHERE c.dummy = :myParam > > I have been trying to get the following configuration to work (using Endpoint > DSL): > .toD(jpa(MyEntity.class.getName()).query("SELECT c FROM &qu

Passing exchange header into JPA component query

2021-08-24 Thread Calle Andersson
Hi, I use Camel 3.4 and have a question regarding the JPA component. I have the following query: SELECT c FROM " + MyEntity.class.getName() + " c WHERE c.dummy = :myParam I have been trying to get the following configuration to work (using Endpoint DSL): .toD(jpa(MyEntity.cla

Re: Query on Camel JDBC Adapter use

2021-02-10 Thread Andrea Cosentino
Hello, Please don't re-post the same question multiple times. Here is an example of jdbc component usage: https://github.com/apache/camel-examples/tree/master/examples/camel-example-jdbc Il giorno gio 11 feb 2021 alle ore 08:30 Sandeep3 Singh ha scritto: > Hi Camel Team, > > I am planning

Query on Camel JDBC Adapter use

2021-02-10 Thread Sandeep3 Singh
Hi Camel Team, I am planning to use Camel JDBC adapter to connect SAP-HANA with Snowflake database. SAP vendor has recommended to use this adapter and hence we want to check if it works. I have the below queries about this adapter What all Apache softwares are required to make Camel JDBC a

Query on Camel JDBC Adapter for Snowflake database access

2021-02-08 Thread Sandeep3 Singh
Hi Camel Team, I am planning to use Camel JDBC adapter to connect SAP-HANA with Snowflake database. SAP vendor has recommended to use this adapter and hence we want to check if it works. I have the below queries about this adapter What all Apache softwares are required to make Camel JDBC a

Camel new bee query

2020-10-14 Thread Kamal
Hi Team, We use camel + spring boot in our application. I came across the new requirement and was looking for ideas to solve it . What the ask is : 1. i should be able to start a route manually via rest 2. Is there an option to stop the route automatically when no message is in queue ? if

Query regarding Camel EHCACHE BASED IDEMPOTENT REPOSITORY

2020-09-03 Thread Pooja V R
Hi Team, I have a requirement where I need to read the messages from a queue filter out the duplicates and send to out queue. For filtering out the duplicates based on MessageId I'm using Ehcache based Idempotent repository . It is working fine as long as the camel application is up. When camel go

Re: Camel Rest Endpoint DSL prefix the string "null" to query parameters key

2020-08-12 Thread Claus Ibsen
s://github.com/apache/camel/blob/camel-3.4.2/core/camel-endpointdsl/src/generated/java/org/apache/camel/builder/endpoint/dsl/RestEndpointBuilderFactory.java#L486 > > > I do not know how to use the queryParameters in the URI format either, my > current work around is to simply add it as a regula

Camel Rest Endpoint DSL prefix the string "null" to query parameters key

2020-08-12 Thread Wai Keung Yiu Man Lung
rrent work around is to simply add it as a regular query parameter to the camel URI in the "to" route. For.e.g, "rest:get:{baseUrl}?queryParam1={queryParam1}&queryParam2={queryParam2}" ... It will be great to have some feedback on how to use the endpoint dsl / how to use the r

Re: Rest DSL Query Params not copied to Exchange Header

2020-02-07 Thread Alex Soto
Thanks Zoran for getting back to me. I will take a look at HttpBinding, but certainly this is very confusing. From what I have seen, both the Query and Path parameters are being put in message headers (good), but then the filter is removing the query parameters (bad) and not the path

Re: Rest DSL Query Params not copied to Exchange Header

2020-02-07 Thread Zoran Regvart
query Hi Alex, perhaps I can shed some light on this, the header in header filter strategy refers to Camel message headers and external (say HTTP) headers. I think (haven't looked at the code) that the query parameters are put in the message headers and it seems that the path parameters are n

Re: Rest DSL Query Params not copied to Exchange Header

2020-02-07 Thread Alex Soto
The other inconsistence is that path parameters defined in the Rest DSL are copied to Exchange headers without any issue, i.e., unaffected by the header filter strategy. So we end up with: Path parameters unaffected by header filter. Query parameters affected by header filter. I would think

Re: Rest DSL Query Params not copied to Exchange Header

2020-02-06 Thread Alex Soto
Look like it is caused by my: Which is very strange, since the ones that have default value are not being filtered. However my intention (when using the header filter strategy) is to filter incoming HTTP request headers, not to the headers that are copied from the query

Rest DSL Query Params not copied to Exchange Header

2020-02-06 Thread Alex Soto
Hello: Running Camel 3.0.1. I have a Rest DSL, where Query Params are not being copied to the Exchange

RE: [EXTERNAL] Re: query timeout not working in JDBC or SQL component

2020-01-20 Thread Gv, Shivakumar
ABCD.T5700_AST_PUR_HST Thanks, Shiva -Original Message- From: Claus Ibsen Sent: Tuesday, January 14, 2020 9:02 PM To: users@camel.apache.org Subject: Re: [EXTERNAL] Re: query timeout not working in JDBC or SQL component *EXTERNAL SENDER* Hi Debug the code and see if the queryTimeout is set

Re: [EXTERNAL] Re: query timeout not working in JDBC or SQL component

2020-01-14 Thread Claus Ibsen
t.maxRows=0 > > for sql: I tried passing timeout value a sql:quey?template.queryTimeout=1 > > Thanks, > Shiva > > -Original Message- > From: Claus Ibsen > Sent: Tuesday, January 14, 2020 8:49 PM > To: users@camel.apache.org > Subject: [EXTERNAL] Re: query ti

RE: [EXTERNAL] Re: query timeout not working in JDBC or SQL component

2020-01-14 Thread Gv, Shivakumar
out=1&statement.maxRows=0 > for sql: I tried passing timeout value a sql:quey?template.queryTimeout=1 Thanks, Shiva -Original Message- From: Claus Ibsen Sent: Tuesday, January 14, 2020 8:49 PM To: users@camel.apache.org Subject: [EXTERNAL] Re: query timeout not working in J

Re: query timeout not working in JDBC or SQL component

2020-01-14 Thread Claus Ibsen
Hi A socket timeout and a query timeout are likely not the same. Socket is network level. Query is likely on the database level. On Tue, Jan 14, 2020 at 4:00 PM Gv, Shivakumar wrote: > > Hi Team, > > I am using camel version: 2.23.1 > > Query timeout not working in both JDB

query timeout not working in JDBC or SQL component

2020-01-14 Thread Gv, Shivakumar
Hi Team, I am using camel version: 2.23.1 Query timeout not working in both JDBC or SQL component. for jdbc: i tried passing timeout value a jdbc:dataSource?statement.queryTimeout=1&statement.maxRows=0 for sql: i tried passing timeout value a sql:quey?template.queryTimeout=1 but

Query on Date Field Mongo

2019-07-24 Thread Bikash Kaushik
Hello, I want to query on a Date field in Mongo DB in blueprint only. I do not want to use java to get the date object. Is this possible? -- *Regards,* *Bikash Kaushik,*

Re: Query on unit test

2019-01-21 Thread Claus Ibsen
Hi So your bean for testing vs production is different? You can use advice with in your unit test to replace the node in the route that calls the bean, where you can do something else. On Mon, Jan 21, 2019 at 10:42 AM Rahotman P wrote: > > Hi, > > While starting a unit test for a route, its loo

Query on unit test

2019-01-21 Thread Rahotman P
Hi, While starting a unit test for a route, its looking for static method of a bean, but there is no static method available. But at run time, its working fine with non-static method. Can you provide me some solution, on this kind of behaviour. -- Regards Rahotman 9487939018

Re: query limit of 200 records in camel-salesforce

2018-09-24 Thread Dicken George
t; > > > In the rest api salesforce documentation, the standard query function is > > done so > > /vXX.X/query/?q=*SOQL query* > > > > According to the salesforce documentation, when there are larger queries > > with more than 200 records the query function allows us to que

Re: query limit of 200 records in camel-salesforce

2018-09-21 Thread Zoran Regvart
he standard query function is > done so > /vXX.X/query/?q=*SOQL query* > > According to the salesforce documentation, when there are larger queries > with more than 200 records the query function allows us to query the next > set of 200 records by querying so. > /vXX.X/query/*qu

Re: Using properties as query named params?

2018-07-14 Thread bukaj_s
in camel-sql 2018-07-01 15:38 GMT+02:00 bukaj_s : > Hello. > Is it possible to use properties same as headers in named queries? > If not, why? > Thanks > Best regards > Bukaj >

Using properties as query named params?

2018-07-01 Thread bukaj_s
Hello. Is it possible to use properties same as headers in named queries? If not, why? Thanks Best regards Bukaj

query limit of 200 records in camel-salesforce

2018-06-18 Thread Dicken George
In the rest api salesforce documentation, the standard query function is done so /vXX.X/query/?q=*SOQL query* According to the salesforce documentation, when there are larger queries with more than 200 records the query function allows us to query the next set of 200 records by querying so

Re: Need Example, use result from SQL-Query as input into Second Database/Table

2017-11-14 Thread Christian Stark
class MyTransformer implements Processor { > > > > public void process(Exchange exchange) throws Exception { > > Map row = exchange.getIn().getBody(Map.class); > > System.out.println("Processing " + row); > > Article article = new Article(); > > > > article.

Re: Need Example, use result from SQL-Query as input into Second Database/Table

2017-11-14 Thread Claus Ibsen
cle = new Article(); > > article.setAuthor((String) row.get("email_id")); > > > *exchange.getOut().setBody(article);* > > } > > > > > > > 2017-11-13 13:48 GMT+01:00 Claus Ibsen : > >> Hi >> >> If the 1st quer

Re: Need Example, use result from SQL-Query as input into Second Database/Table

2017-11-14 Thread Christian Stark
;)); *exchange.getOut().setBody(article);* } 2017-11-13 13:48 GMT+01:00 Claus Ibsen : > Hi > > If the 1st query return only 1 row, then you can set outputType=SelectOne > > Then the returned value is a Map > Then you can use the column names as-is in the 2

Re: Query regarding zip consumption using apache camel

2017-11-13 Thread Claus Ibsen
Hi Either tweak the read lock change options to have higher threshold - see the docs. Or when you copy the file to that computer, then copy it to some other directory / or use some other kind of name. And then afterwards move / rename the file - as this would then do it on the same computer/file-s

RE: Query regarding zip consumption using apache camel

2017-11-13 Thread Shashank Gupta
. Regards Shashank Gupta -Original Message- From: Siano, Stephan [mailto:stephan.si...@sap.com] Sent: 14 November 2017 13:14 To: users@camel.apache.org Cc: Onder SEZGIN Subject: RE: Query regarding zip consumption using apache camel Hi, You likely want to set some readLock parameter to

RE: Query regarding zip consumption using apache camel

2017-11-13 Thread Siano, Stephan
you should probably read the documentation for the file endpoint. Best regards Stephan -Original Message- From: Shashank Gupta [mailto:shashank.gu...@talentica.com] Sent: Montag, 13. November 2017 21:07 To: users@camel.apache.org Cc: Onder SEZGIN Subject: RE: Query regarding zip

RE: Query regarding zip consumption using apache camel

2017-11-13 Thread Shashank Gupta
.split(new ZipSplitter()).streaming() .to("file://{{rootOutputDirectory}}/incoming");' Queue 2 is :- -Original Message- From: Onder SEZGIN [mailto:ondersez...@gmail.com] Sent: Tuesday, November 14, 2017 12:39 AM To: users@camel.apache.org Subje

Re: Query regarding zip consumption using apache camel

2017-11-13 Thread Onder SEZGIN
I think your situation is a bit hard to guess unless you share your routing details. In case, you directly consume files by trying to unmarshall them even if your file transfer is complete. If you use file component, you may need to look into exclude option to avoid consuming incomplete transferr

Re: Need Example, use result from SQL-Query as input into Second Database/Table

2017-11-13 Thread Claus Ibsen
Hi If the 1st query return only 1 row, then you can set outputType=SelectOne Then the returned value is a Map Then you can use the column names as-is in the 2nd query See the docs at https://github.com/apache/camel/blob/master/components/camel-sql/src/main/docs/sql-component.adoc On Mon, Nov

Need Example, use result from SQL-Query as input into Second Database/Table

2017-11-13 Thread Christian Stark
Hello, Assuming the following example: I'd like to know how to control/manipulate the variables to insert the input from the first query from table/database1 into the second table/database2. What is the best option to manipulate $input1,$input2,$input3 Do we need a transformer or a conv

Query regarding zip consumption using apache camel

2017-11-13 Thread Shashank Gupta
Hi, We am trying to unzip the zip and then reading the pdf and txt files inside that. We are using Camel Apache with Java in our project. The problem is occurring when we are trying to copy the zip over remote desktop in windows, we are copying the zip directly into the hot folder(which camel is

Re: Camel sql Component should retrieve data when the particular column is null using select query

2017-05-26 Thread darwinanirudh
Thank you for response. regards Darwin -- View this message in context: http://camel.465427.n5.nabble.com/Camel-sql-Component-should-retrieve-data-when-the-particular-column-is-null-using-select-query-tp5799613p5800760.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel sql Component should retrieve data when the particular column is null using select query

2017-05-18 Thread darwinanirudh
: org.apache.camel.language.simple.types.SimpleIllegalSyntaxException: expected symbol whiteSpace but was nullValue at location 19 ${bodyAs(String)}!=null Can any one help -- View this message in context: http://camel.465427.n5.nabble.com/Camel-sql-Component-should-retrieve-data-when-the-particular-column-is-null-using-select-query-tp5799613p5799769

Re: Camel sql Component should retrieve data when the particular column is null using select query

2017-05-18 Thread raja
Change from: ${body[CDR_JSON_FORM]}!= null Change TO: ${body[CDR_JSON_FORM]} != null -- View this message in context: http://camel.465427.n5.nabble.com/Camel-sql-Component-should-retrieve-data-when-the-particular-column-is-null-using-select-query-tp5799613p5799771.html Sent from the

Camel sql Component should retrieve data when the particular column is null using select query

2017-05-16 Thread darwinanirudh
-retrieve-data-when-the-particular-column-is-null-using-select-query-tp5799613.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: How to send Query Parameters in POST request along with body?

2017-05-14 Thread Claus Ibsen
What Camel version do you use? And try with latest release and also with camel-http4 instead. On Sun, May 14, 2017 at 6:02 PM, Sivaraman wrote: > Hi, > > I'm new to camel and I have to make HTTP POST request with body. Along with > that, I need to pass url query parameters t

How to send Query Parameters in POST request along with body?

2017-05-14 Thread Sivaraman
Hi, I'm new to camel and I have to make HTTP POST request with body. Along with that, I need to pass url query parameters too POST https://api.company.com/profile/123?*minorversion=11* <> (As body) I tried setting HTTP_QUERY/HTTP_METHOD in header, but the moment I set HTTP_Q

Re: mongodb distinct query

2017-05-10 Thread Mark
Claus, I created a ticket in JIRA and submitted a patch. Let me know if there's anything more I can do to support this functionality. https://issues.apache.org/jira/browse/CAMEL-11259 Cheers, Mark On Tue, May 9, 2017 at 7:15 AM, Mark wrote: > Thanks Claus, I'm going to try and put together

Re: mongodb distinct query

2017-05-09 Thread Mark
Thanks Claus, I'm going to try and put together a patch and submit it. On Fri, May 5, 2017 at 3:45 PM, Claus Ibsen wrote: > I frankly do not know if its supported or not. But if you have looked > in the docs and source code then its likely not. > > We love contributions so you are welcome to see

Re: mongodb distinct query

2017-05-05 Thread Claus Ibsen
I frankly do not know if its supported or not. But if you have looked in the docs and source code then its likely not. We love contributions so you are welcome to see what it takes to add support for that. http://camel.apache.org/contributing On Thu, May 4, 2017 at 7:14 AM, Mark wrote: > I'm try

mongodb distinct query

2017-05-04 Thread Mark
I'm trying to figure out if Camel supports distinct queries with the mongodb component. I've looked through the docs and source code and cannot see where that is supported. Is this functionality supported in the camel-mongodb component and I just don't see it? Cheers, Mark

custom query support for JPA producer Re: Camel JPA Name Query with Parameters

2017-03-14 Thread Tomohisa Igarashi
sumer', it's a consumer option. Right now JPA producer doesn't support named query yet. I'll work on that enhancement soon. https://issues.apache.org/jira/browse/CAMEL-10265 Thanks, Tomo On 03/11/2017 08:24 AM, urwithsumit wrote: Hi, I have been going through different post

Re: Camel JPA Name Query with Parameters

2017-03-10 Thread Tomohisa Igarashi
Hi, As you can see the parameter name starts with 'consumer', it's a consumer option. Right now JPA producer doesn't support named query yet. I'll work on that enhancement soon. https://issues.apache.org/jira/browse/CAMEL-10265 Thanks, Tomo On 03/11/2017 08:24 AM, u

Camel JPA Name Query with Parameters

2017-03-10 Thread urwithsumit
Hi, I have been going through different post to see how i can use JPA component to invole named query with parameter. I know from documentation that we need to add it to the registry. Right now i am stuck and not able tot find a way to get the parameter to the registry. Below is the route i have

RE: Not seeing query params on REST DSL

2017-02-10 Thread Steve Huston
ring req[] = url.getQuery().split("="); assertEquals("id query param is present", "id", req[0]); assertEquals("id query value mismatch", "5678", req[1]); > -Original Message- > From: vikson [mailto:vikram

Re: Not seeing query params on REST DSL

2017-02-09 Thread vikson
Hi Steve, Were you able to find a solution for your query. I'm facing the exact same issue; not able to read query params from the URL in case of the RESTLET component. I was earlier using the SERVLET component and I was able to read the query params as well as the header values from the inc

Camel-json Dataformat query

2016-12-19 Thread urwithsumit
working. Regards Sumit -- View this message in context: http://camel.465427.n5.nabble.com/Camel-json-Dataformat-query-tp5791726.html Sent from the Camel - Users mailing list archive at Nabble.com.

camel-salesforce component unable to unmarshall nested query results

2016-12-13 Thread Doug Douglass
I'm new to Salesforce and was really hoping to make use of the camel-salesforce component to jump start an integration project. Unfortunately, I've hit a wall and need to confirm whether the component should support unmarshalling results of query API call with a query containing a sub-s

Re: R: Re: camel-sql IN query number of parameters mismatch(2.18.0)

2016-11-19 Thread imranrazakhan
Hi Julian, One observation regarding camel-sql(2.18.0) IN query , if we have one dynamic IN it works fine but if we have two dynamic IN it throws error, if i replace msisdn with static value it works fine, i tested with 2.18.0 select * from subscriber s where status NOTIN(7,8) AND s.msisdn

Re: Camel Transactions query

2016-10-25 Thread fabryprog
Hello, to manage sql transaction's query you must use 1. camel sql component (http://camel.apache.org/sql-component.html) 2. transactional client (http://camel.apache.org/transactional-client.html) 3. mark your route "" N.B. if you invoke more nested routes without right transact

Camel Transactions query

2016-10-21 Thread ravi21588
Hi all, I have a query in implementing transactions. If there is any exception in route the transaction will not be committed and rollbacked. I had mentioned redelivery for 3 times in hornetq address setting configuration. Is there any way in camel,i can frame the error message with error

Camel Spring-WS Endpoint with URL Query Parameters

2016-10-19 Thread Arthanarisamy Annamalai
. spring-ws://https://something.com:4443/Webservices/service.swe?Cmd=Execute&Source=WebService&WSSOAP=1 How do i pass query parameters using Camel Spring-ws? Thanks, Arthanarisamy -- View this message in context: http://camel.465427.n5.nabble.com/Camel-Spring-WS-Endpoint-with-URL-Query-Pa

Camel event notifier query

2016-09-22 Thread mayur_bm
and I can intercept exchange centrally and retrieve it! How do I achieve it? Is camel event notifier serve my purpose? Regards, Mayur -- View this message in context: http://camel.465427.n5.nabble.com/Camel-event-notifier-query-tp5787943.html Sent from the Camel - Users mailing list archive at

RE: camel sql joined query with parameters won't run on sql server

2016-07-20 Thread Karts
I have the same issue with sql server, but it seems to be related to alias + named param rather than a joined query. The following works fine: .setHeader("ExternalRef", simple("1234")) .to("sql:select event from events where id= :#ExternalRef") But if I

Re: R: Re: camel-sql IN query number of parameters mismatch

2016-07-16 Thread juliaaano
Thanks, Claus. I was about to start on doing that now. I you haven't gone too far, I still volunteer to work on it. Cheers. -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785175.html Sent from the Camel -

Re: R: Re: camel-sql IN query number of parameters mismatch

2016-07-16 Thread Claus Ibsen
I have already >> done? >> >> Thanks! >> >> >> >> -- >> View this message in context: >> http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785088.html >> Sent from the Camel - Users mailing list ar

Re: R: Re: camel-sql IN query number of parameters mismatch

2016-07-15 Thread Claus Ibsen
tests available in a > different way other than by publishing through a branch like I have already > done? > > Thanks! > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785088.htm

Re: R: Re: camel-sql IN query number of parameters mismatch

2016-07-13 Thread juliaaano
make this tests available in a different way other than by publishing through a branch like I have already done? Thanks! -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785088.html Sent from the Camel - Users mailing

R: Re: camel-sql IN query number of parameters mismatch

2016-07-13 Thread Andrea Cosentino
y found the source of the problem in that class highlighted in my previous post. Again, If you guys find this is a bug I'd be happy to report and fix it. Thanks. -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p57

Re: camel-sql IN query number of parameters mismatch

2016-07-13 Thread juliaaano
find this is a bug I'd be happy to report and fix it. Thanks. -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785067.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel-sql IN query number of parameters mismatch

2016-07-12 Thread Tadayoshi Sato
Hi, Looks like the same issue was discussed in this ML a month ago :-) http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-td5783264.html Isn't it the same as yours? For convenience, Claus suggested the following solution in that thread: > I wonder if its the Ora

camel-sql IN query number of parameters mismatch

2016-07-12 Thread juliaaano
I'm running Camel 2.17.2. I've been experiencing a problem when using IN query in a SQL statement where there is more than one parameter, besides the one declared within the IN clause. For example: .to("SELECT * FROM projects WHERE license = :#${body} AND project IN (:#in:name

RE: camel sql joined query with parameters won't run on sql server

2016-06-26 Thread Ronny Aerts
Sent: zaterdag 25 juni 2016 23:04 To: users@camel.apache.org Subject: Re: camel sql joined query with parameters won't run on sql server Hi Ronny, I had the same kind of problem recently and it turned out to be something to do with the driver not correctly returning the number of parameters. I

Re: camel sql joined query with parameters won't run on sql server

2016-06-26 Thread arno noordover
This seems to be a Microsoft sql server database problem. Have you tried to run this query directly against your database. If you get the same error, you should solve this first. I know that Microsoft sql server support the ansi join syntax: eg: FROM VGMSITE s JOIN VGMLOCATION l ON s.SITENO

Re: camel sql joined query with parameters won't run on sql server

2016-06-25 Thread John Taylor
Aerts writes: > Hello camel user community, > > I have strange problem with a Microsoft sql server database joined query > where I would like to have some advice. > > I have 2 spring dsl steps in a route: > > > > The siteno and locationno are in a header. > B

camel sql joined query with parameters won't run on sql server

2016-06-25 Thread Ronny Aerts
Hello camel user community, I have strange problem with a Microsoft sql server database joined query where I would like to have some advice. I have 2 spring dsl steps in a route: The siteno and locationno are in a header. Both steps run perfectly good in a firebird database and produce

Re: Throttle Camel Requests based on query param

2016-06-19 Thread Debraj Manna
sor) .endChoice() .otherwise() .process(processor); On Sun, Jun 19, 2016 at 1:47 PM, owain wrote: > All you need to do is to test for the presence of the query parameter or > the > Header being set. > > Have a look at http://camel.apache.org/predicate.html > > So all you d

Re: Throttle Camel Requests based on query param

2016-06-19 Thread owain
All you need to do is to test for the presence of the query parameter or the Header being set. Have a look at http://camel.apache.org/predicate.html So all you do is amend the route or parameters to the component after that. O. -- View this message in context: http://camel.465427.n5

Re: Throttle Camel Requests based on query param

2016-06-18 Thread Debraj Manna
ebugFlag header is present. Then only I want to throttle the request to some constant value 5 requests / sec. I can not rely on the caller to send me the throttle rate on a separate header. There is no hard requirement that debugFlag has to be header it can be query param as well if that

Re: Throttle Camel Requests based on query param

2016-06-16 Thread yogu13
check Dynamically changing maximum requests per period @ http://camel.apache.org/throttler.html you can set the query param to exchange header and throller can pick this value from header. Regards, -Yogesh -- View this message in context: http://camel.465427.n5.nabble.com/Throttle-Camel

Re: Throttle Camel Requests based on query param

2016-06-16 Thread Taariq Levack
Hi, You can use the query param itself and throttle by header, or the choice EIP to decide based on your query param, what to set the header to. throttleValue Cheers On Thu, Jun 16, 2016 at 8:43 PM, Debraj Manna wrote: > Hi, > > I have a camel route like below:- > > f

Throttle Camel Requests based on query param

2016-06-16 Thread Debraj Manna
.org/throttler.html> pattern. But is there a way I get rate limit / throttle based on a query param(e.g if debug=1 is set in request then we want to throttle requests to 10 req/sec).

query param

2016-06-08 Thread miri eyni
hi i try to routing url with query param but i got the 400 server code . http://{{fromUrl}}/billing/{paymentMethod}/{product}/{frequency}?matchOnUriPrefix=true"/> http://{{toUrl}}/metadata/billing/{paymentMethod}/

Re: camel-sql - SQL IN Query issue (2.17.1)

2016-06-01 Thread imranrazakhan
HI Claus, thanks our suggestions worked perfect, i am currently using ojdbc6 version 12.1.0.2, will verify if its fixed in any other driver. Regards, -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783350.html Sent from the

Re: camel-sql - SQL IN Query issue (2.17.1)

2016-06-01 Thread Claus Ibsen
sted exception is >> java.sql.SQLException: Number of parameters mismatch. Expected: 1, was: 5 >> >> >> Regards >> >> ------ >> If you reply to this email, your message will be added to the discussion >> below: >> >> http://camel.

Re: camel-sql - SQL IN Query issue (2.17.1)

2016-05-31 Thread yogu13
gt; -- > If you reply to this email, your message will be added to the discussion > below: > > http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783319.html > To unsubscribe from camel-sql - SQL IN Query issue (2.17.1),

Re: camel-sql - SQL IN Query issue (2.17.1)

2016-05-31 Thread imranrazakhan
Regards -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783319.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel-sql - SQL IN Query issue (2.17.1)

2016-05-31 Thread yogu13
: java.lang.IllegalArgumentException: DataSource must be >> configured >> >> >> -- >> If you reply to this email, your message will be added to the discussion >> below: >> >> http://camel.465427.n5.nabble.com/camel-sql-S

Re: camel-sql - SQL IN Query issue (2.17.1)

2016-05-31 Thread yogu13
> -- > If you reply to this email, your message will be added to the discussion > below: > > http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783303.html > To unsubscribe from camel-sql - SQL IN Query issue (2.17.1), cl

Re: camel-sql - SQL IN Query issue (2.17.1)

2016-05-31 Thread imranrazakhan
gured -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783303.html Sent from the Camel - Users mailing list archive at Nabble.com.

  1   2   3   4   5   >