Stack Overflow
Stack Overflow

Questions tagged [camel-sql]

82 questions
0
votes
0 answers

Handle IN clause limit 1000 in Camel Sql

I am using the camel sql(version 2.20.1) and running an sql query using the template SELECT column1,column2 FROM my_table WHERE column2 IN (:#in:ids). Everything here is working fine, but my doubt is like how does it handle the case: if the count…
Girish007
  • 442
  • 6
  • 26
0
votes
1 answer

Can not get a connection to a mariaDB with the camel SQL component

I always get the following exception when trying to connect to a mariDB database and i cannot figure out how to properly define the dataSource. No bean could be found in the registry for: myDataSource of type: javax.sql.DataSource My code is fairly…
user9338894
  • 69
  • 7
0
votes
0 answers

unable to insert data in table using camel sql & sqlite Error

I am using Jboss Fuse with blueprint as DSL. I wrote a simple camel route using sql component which inserts data in SQlite.
Beena Rautela
  • 53
  • 6
0
votes
1 answer

Using In clause in apache Camel

I am using camel 2.17.0 and have to execute an update query using SQL IN clause. Query is update MY_TABLE set STATUS = :#status where ID in (:#in:ids) AND TYPE = :#type I have set all the parameters to camel header, the parameter ids is a…
praveenps
  • 77
  • 1
  • 9
0
votes
1 answer

Testing camel-sql route with in-memory database not fetching results

I have written the code using camel-sql which is working fine. Now I have to write test cases for the same. I have used in-memory database H2. I have initialized the database and assigned the datasource to sqlComponent. // Setup code @Override …
rishi
  • 1,792
  • 5
  • 31
  • 63
0
votes
1 answer

apache camel sql component ORA-00947: not enough values

This is my Java DSL route: from("seda:singlePersonChannel") .log(LoggingLevel.INFO, "Person bean: ${body}") .process(new Processor() { @Override public void process(Exchange exchange) throws Exception { …
suitej
  • 99
  • 1
  • 11
0
votes
1 answer

Apache Camel How convert DB response to XML

I use ServiceMix (Apache Camel) and I did not find a similar theme on StackOverFlow. I describe the sequence: For work with data I need convert SQL resultset to XML.
Mikro Koder
  • 1,056
  • 10
  • 13
0
votes
2 answers

Parsing csv data format in apache Camel

I followed an example from a book Camel in action. how to marshal and unmarshal csv data format. However, I want to unmarshal a csv file with (comma seperated delimiter) and split body. Then, I will use content based .choice to distribute messages…
Chayma Sakouhi
  • 79
  • 2
  • 10
0
votes
1 answer

Camel Blueprint specify parameter for prepared sql statement

I have a poll enrich which enriches a POJO with the result of an SQL query (from a MySQL database). It currently gets the brand from the POJO and then gets the name from the order matching the brand. I had to add quotes around the ${body.getBrand},…
ThunderM
  • 41
  • 1
  • 7
0
votes
1 answer

How to unit test sql-stored steps in a camel route

I recently joined a project in which lots of autosys jobs are replaced with camel routes. most of the processing flows follow the same pattern: Read a file from a certain folder Apply some deserialization of some sort into a java structure Invoke a…
Julian
  • 3,678
  • 7
  • 40
  • 72
0
votes
1 answer

camel sql-stored component. How to pass INOUT oracle parameter?

I am using camel 2.18 camel-sql component for calling stored procedures. Is it possible to call oracle stored procedure which has an INOUT parameter?
Maciavelli
  • 101
  • 1
  • 14
0
votes
1 answer

Unable to do a deep mapping for JDBC using outPutClass in apache camel

I have a requirement where I have to read from two different sources, one from a file and the other from a DB, perform some operations in the aggregator and then write the output to a file. I am able to read the file but after reading the file from…
Sandy
  • 29
  • 3
0
votes
1 answer

Is it possible to make JMS selector case insensitive?

I know that the JMS headers properties are case sensitive. But I am working on one requirement where I have to make JMS selctor to not case sensitive. Is it possible to do so? I am using camel and below is the way I am defining my selector in…
bvyas
  • 384
  • 3
  • 10
0
votes
1 answer

Idempotent consumer with JDBC repository Apache Camel

i am working on springboot with Apache Camel so my question is how can i write code to use Idempotentconsumer with JDBC repository using apache camel.
Rajeev
  • 103
  • 1
  • 2
  • 14
0
votes
1 answer

How to get table metadata from camel-sql component

I'm looking for a way to get all the column meta data for the given table name using camel-sql component. Though it uses spring-jdbc behind the scenes i do not see a way to get the ResultSetMetaData.
Venkat
  • 314
  • 3
  • 10
1 2 3 4
5
6