Questions tagged [camel-sql]
66 questions
9
votes
1 answer
Apache Camel SQL Batch insertion taking long time
I am using Apache Camel SQL batch insertion process.
My application is reading tickets from the Active MQ which contains around 2000 tickets.
I have updated the batch as 100.
The query which i am firing is as follows:
sql.subs.insertCdr=
insert…
KayV
- 9,560
- 8
- 68
- 111
4
votes
0 answers
Camel-SQL Why using StreamList seems to load all ResultSet?
Hi,
What am I trying to do ?
I am currently working on an ESB project (apache-camel + spring boot 2) where i read a MySQL table with more than 100 000 000 rows.
I empty this table 1 row at a time, transform the row and send it to another…
Benjamin Coquard
- 41
- 3
4
votes
1 answer
Unable to map postgresql timestamp with timezone in camel jdbc
I have following route which get data from postgresql but date object is coming null. it's unable to map that value
My route if following
user1047873
- 331
- 2
- 8
- 24
3
votes
1 answer
Apache Camel How do I access the Header values from an sql component
I am trying to print the number of rows selected by an sql component using the property header.CamelSqlRowCount. However the value is coming empty.
I added trace as mentioned in another post to check the header values and only breadcrumbId is…
Sarun
- 71
- 7
2
votes
0 answers
Apache Camel JdbcAggregationRepository demands unproportionate TABLESPACE in Oracle 12C
I have a simple camel route. It polls a directory, reads a text file and splits the content of file line by line. Then it transforms each line (now having lesser no. of characters than original line) and aggregates the transformed lines (messages)…
Sanjeev Saha
- 2,532
- 1
- 8
- 18
2
votes
1 answer
Apache Camel - JPAEndpoint - Catch exception on commit e.g. PersistenceException
I have a route which basically transfers the data from one database table to the other. Producer and consumers are JPA endpoints. Simplified:
from(producer)
.process(new StagingEventTransformer())
.to(consumer);
What I'm currently want to catch is…
user984200
- 301
- 1
- 5
- 15
2
votes
2 answers
Camel-Spring Boot: Route doesn't stop after execution
I am using Spring Boot + Camel with below config.
Main Class
@SpringBootApplication
public class Application extends RouteBuilder {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
…
user1637487
- 181
- 2
- 15
1
vote
1 answer
Why does camel move file with only partial data?
Below is my code:
from("quartz2:report?cron=" + cronExpression)
.routeId("jms:queue:test")
.setHeader("CURRENT_TIME", simple("${date:now:MM-dd-yyyy HH:mm:ss.S}"))
//Writing column names for report to the file
.setBody()
…
Kiran Cyrus Ken
- 187
- 11
1
vote
1 answer
camel csv display column name
I have two questions.
The first question: i use camel sql and camel csv to export database in csv.
I would like to display column names however the options of camel csv doesn't work for me while i am on camel 2.16.5 version.
ex)
Katy
- 39
- 4
1
vote
1 answer
Apache Camel: How to transform hierarchical data from database into pojo
I am new to stackoverflow and also to Apache Camel. I try to write a understandable description of my problems.
My goal is to read hierarchical data from database (mysql) which is composed by 1 entry in a parent table and several rows in a child…
blumenkoehlchen
- 13
- 2
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
- 877
- 12
- 17
1
vote
1 answer
SimpleParserException: Unknown function: property.fileName
I'm using Apache Camel 3.0 and I'm getting this error when parsing the file:
from("file:" + filePath)
.routeId("create-ticket")
.unmarshal(ticketCsv)
.to("jpa:Ticket")
.log("Created new ticket with…
uzx79024
- 11
- 1
1
vote
1 answer
Accessing OUT parameters with Apache Camel SQL Stored Procedure Component
I'm calling an Oracle Stored Procedure using Apache Camel's SQL Stored Procedure Component.
The Stored Procedure that I'm calling has several OUT parameters which are all returned in the BODY as a String, for example:
{param1=0, param2=-,…
Unai
- 141
- 10
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
- 41
- 6