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 I
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 - Users mail
Hi
I logged a ticket and are working on a fix
https://issues.apache.org/jira/browse/CAMEL-10151
On Fri, Jul 15, 2016 at 5:45 PM, Claus Ibsen wrote:
> Hi
>
> Yeah that is a bug in the parser when you have dynamic body and IN
> together. You are welcome to log a JIRA and submit a PR with an unit
>
Hi
Yeah that is a bug in the parser when you have dynamic body and IN
together. You are welcome to log a JIRA and submit a PR with an unit
test (create a new unit test so the existing test can be as-is)
On Wed, Jul 13, 2016 at 7:11 PM, juliaaano wrote:
> Yes. Unfortunately I still have the same
Yes. Unfortunately I still have the same problem for an endpoint such as:
.toD("sql:UPDATE orders SET customer = :#Customer WHERE orderId IN
(:#in:orders)")
I don't see how this could have solved the problem since I have failing unit
tests at the sql component level. Should I make this tests avai
Did you try with a dinamica endpoint toD?
Il mer, 13 lug, 2016 alle 12:13, juliaaano ha scritto:
Hello,
I don't think this is related to the driver. I've extended the existing
camel test case to reproduce the aforementioned scenario. Check it out at
https://github.com/juliaaano/camel/tree
Hello,
I don't think this is related to the driver. I've extended the existing
camel test case to reproduce the aforementioned scenario. Check it out at
https://github.com/juliaaano/camel/tree/sql-in-multiple-params
There is not Oracle JBDC driver involved in the unit test as well as with
the se
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 Oracle JDBC drive
