Questions tagged [camel-sql]
82 questions
1
vote
2 answers
camel sql-stored ends in "java.sql.SQLException: Non supported SQL92 token at position" with Oracle datasource
When I run the following simple route with a stored-procdure, it results in an exception: "java.sql.SQLException: Non supported SQL92 token at position"
The same route with embedded Derby datasources works as expected.
Question
Any ideas? Is…
Sebastian
- 11
- 1
1
vote
0 answers
Springboot & camel, datasource already closed on graceful shutdown
I created a small application that fetches log files, extract relevant data and push them in a database, all using camel components.
It works pretty well unless when I stop it (gracefull shutdown).
When I do so, spring closes the datasource I…
Ghurdyl
- 1,077
- 1
- 12
- 18
1
vote
0 answers
Camel Split/RecipientList Threads & Transaction Boundaries
In Apache Camel 2.20.2, I created a route with a split() and recipientlist(). I would like the entire route and recipients of each Exchange to occur in the same transaction. I am confused about when Camel will use a separate thread and transaction…
Vince Iglehart
- 11
- 2
1
vote
0 answers
Camel JPA component route is not executing fully
I have created a simple route using JPA component
`fromF("jpa:%s?consumer.namedQuery=step1&delay=5s&consumeDelete=false&consumeLockEntity=false", Event.class.getName())
.log("Query Fired")
.process(exchange ->…
Rohit Patil
- 51
- 7
1
vote
1 answer
IN clause in Apache Camel 2.18
I am trying to execute a sql deletion statement within the route. The query contains an IN clause and I want to pass a Set of values to the IN clause. I am using camel-core & camel-jdbc 2.18.1 and camel-sql…
Ronald James
- 647
- 1
- 5
- 13
1
vote
0 answers
Bug: camel-sql - Could not resolve placeholder 'property.' in string value "sql query"
In Camel 2.17.0, camel sql component is not able to resolve property value using simple expression when externalized.
1234
…
Jayashankar
- 33
- 8
1
vote
1 answer
How to start transaction in Camel sql consumer and use it further
I am using Camel for integrating Spring Boot application with other domains.
I have a simple route configured using SQL Component for polling and updating DB:
from("sql:"+selectSQL+"?consumer.delay=20000&onConsume="+updateSQL)
.log("---select sql…
aleksei
- 315
- 4
- 14
1
vote
2 answers
Camel enrich SQL syntax issue
I'm tasked with creating a Camel route using Camel version 2.20.0 that takes a line in from a CSV file uses a value from that line in the SQL statement where clause and merges the results and outputs them again. If I hardcode the identifier in the…
user2501326
- 103
- 7
1
vote
1 answer
stored procedure invokation through camel sql-stored component
I am new to camel sql-stored component. Currently I am using Camel 2.17.5. And I am trying to invoke oracle stored procedure from camel route. This is my route:
John
…
Maciavelli
- 101
- 1
- 14
1
vote
2 answers
How to set autocommit false in apache camel sql batch insertion?
I am using apache-camel sql-batch insertion.
My route for sql batch insertion is as follows:
…
KayV
- 12,987
- 11
- 98
- 148
1
vote
1 answer
How to update only consumed sql rows with Apache Camel SQL Component?
I'm new in Camel and i try to process SQL data. If the SQL consume (select) is done, i try to update the consumed rows, but i just get a "bad SQL grammar" exception.
I use the Apache Camel SQL-Component, where the starting endpoint is a sql select…
Zeussi
- 571
- 1
- 9
- 22
1
vote
1 answer
Camel-SQL Component useIterator not working as expected
I am trying to use camel-sql component with the option of useIterator=true but the result still gets loaded in one single big list. I have 2 million records to be processed and getting the resultset in one list is not an option. Below is the route…
Ravish Patel
- 11
- 2
1
vote
0 answers
How to pass Report Parameter value to SSRS Report(CAMEL Based) Calling Sharepoint asmx
I am not able to pass report parameter. Parameter value is not getting replaced by actual value passed. I checked the fiddler. actual value is not getting replaced.
I have tried =Parameters!XXX.Value in replace of parameter did not work
…
Khurram Shakoor
- 35
- 1
- 3
- 8
1
vote
2 answers
Read file locations from table and copy to specific folder using pollEnrich()
I am trying to write a camel route that reads a database table to get the list of absolute file paths and then copy those files to another folder. However only the file path is created as content instead of the original content.
…
zikzakjack
- 972
- 2
- 9
- 20
1
vote
1 answer
How to insert blob using camel SQL component with Oracle Database
I am trying to insert an input stream using camel SQL component (http://camel.apache.org/sql-component.html).
I have the following table in Oracle Database:
table EMPLOYEE(NAME varchar(32) ,SURNAME varchar(32) , PIC BLOB );
and the following…
arius81
- 21
- 5