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 alias the table :
.setHeader("ExternalRef
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
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 = l.SIT
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 ended up needing to use the parametersCount option. It is
described at http://camel.apache.org/sql-component.html
Regards,
-John
Ronny A
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 follow
