Questions tagged [camel-sql]
82 questions
0
votes
0 answers
Can I pass Single Quote as Camel Query Parameter?
I'm trying to do a query like this:
SELECT * from Employee where First_Name between 'AA' and 'AK'
I'm using the camel sql component and passing a parameter through the header like this:
Query: SELECT * from Employee where First_Name between…

mariob
- 1
- 3
0
votes
1 answer
output is getting repeated , should be printed only once
It is a simple select statement from mysql server and showing output on console. Somehow the result is getting printed in loop though I haven’t used any timer as such.

Payal Bansal
- 725
- 5
- 17
0
votes
1 answer
In camel how i can update a result set coloumn to a value
My select query is
sql.selectOrder=select STID,CLLTR from GSI_DEVL.POLLUX_DATA WHERE PROCESSED='FALSE'
My Route is

Bibin Mathew
- 1
- 2
- 3
0
votes
1 answer
Camel SQL Component with Simple Expression
I am trying to implement a function like a HTTP proxy with Apache Camel.
In my proxy, I want to insert a header value in DB, and I used Simple Expression in SQL.
Here is my camel route.

NES
- 3
- 2
0
votes
2 answers
How to add resultset to csv file in camel
My xml is given below

Bibin Mathew
- 1
- 2
- 3
0
votes
2 answers
Apache camel how to insert map value to data base using sql component
Apache camel how to insert map value to data base using SQL component
My Class file:
public class PolluxDataController {
List stationsMasterList=new ArrayList();
List stationProccessedList=new…

Bibin Mathew
- 1
- 2
- 3
0
votes
0 answers
camel sql insert bean
I am trying to insert into sql using a bean in Camel. I must be missing a detail somehow, since the sql is null when reaching the camel sql components inner classes. Should it not be enough to return the map in the insertBean?
My route is defined…

MRK187
- 1,545
- 2
- 13
- 20