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
1 2 3 4 5
6