Apache Camel: How do I achive a transactional route in Camel if I have a DB access in a route and then an FTP...
up vote
0
down vote
favorite
My route:
from(jms:queue:xxx)
...
.process(_db_access__here_will_be_written_in_db)
...
.to(ftp:yyy)
The problem is, after the message will be read from a queue, the data will be written in the Database, but if the ftp endpoint producer failed to write a file in the directory, I get an error in the route but the changes in the DB will not be rollbacked.
I want to commit the changes to DB only when the file will be
successfully written to ftp directory. How can I do that in my route?
java ftp apache-camel rollback transactional
asked Nov 10 at 16:12
Oli
7610
add a comment |
up vote
0
down vote
favorite
My route:
from(jms:queue:xxx)
...
.process(_db_access__here_will_be_written_in_db)
...
.to(ftp:yyy)
The problem is, after the message will be read from a queue, the data will be written in the Database, but if the ftp endpoint producer failed to write a file in the directory, I get an error in the route but the changes in the DB will not be rollbacked.
I want to commit the changes to DB only when the file will be
successfully written to ftp directory. How can I do that in my route?
java ftp apache-camel rollback transactional
asked Nov 10 at 16:12
Oli
7610
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
My route:
from(jms:queue:xxx)
...
.process(_db_access__here_will_be_written_in_db)
...
.to(ftp:yyy)
The problem is, after the message will be read from a queue, the data will be written in the Database, but if the ftp endpoint producer failed to write a file in the directory, I get an error in the route but the changes in the DB will not be rollbacked.
I want to commit the changes to DB only when the file will be
successfully written to ftp directory. How can I do that in my route?
java ftp apache-camel rollback transactional
asked Nov 10 at 16:12
Oli
7610
My route:
from(jms:queue:xxx)
...
.process(_db_access__here_will_be_written_in_db)
...
.to(ftp:yyy)
The problem is, after the message will be read from a queue, the data will be written in the Database, but if the ftp endpoint producer failed to write a file in the directory, I get an error in the route but the changes in the DB will not be rollbacked.
I want to commit the changes to DB only when the file will be
successfully written to ftp directory. How can I do that in my route?
java ftp apache-camel rollback transactional
java ftp apache-camel rollback transactional
asked Nov 10 at 16:12
Oli
7610
asked Nov 10 at 16:12
Oli
7610
asked Nov 10 at 16:12
Oli
7610
asked Nov 10 at 16:12
Oli
7610
asked Nov 10 at 16:12
Oli
7610
7610
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
you are looking at transacted client.
you also may add transacted if you are using camel-sql
sql:insert into tables value (id=:#myId)?transacted=true
answered 2 days ago
chiochuan
11
New contributor
chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
– Oli
yesterday
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
you are looking at transacted client.
you also may add transacted if you are using camel-sql
sql:insert into tables value (id=:#myId)?transacted=true
answered 2 days ago
chiochuan
11
New contributor
chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
– Oli
yesterday
add a comment |
up vote
0
down vote
you are looking at transacted client.
you also may add transacted if you are using camel-sql
sql:insert into tables value (id=:#myId)?transacted=true
answered 2 days ago
chiochuan
11
New contributor
chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
– Oli
yesterday
add a comment |
up vote
0
down vote
up vote
0
down vote
you are looking at transacted client.
you also may add transacted if you are using camel-sql
sql:insert into tables value (id=:#myId)?transacted=true
answered 2 days ago
chiochuan
11
New contributor
chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
you are looking at transacted client.
you also may add transacted if you are using camel-sql
sql:insert into tables value (id=:#myId)?transacted=true
answered 2 days ago
chiochuan
11
New contributor
chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 2 days ago
chiochuan
11
New contributor
chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 2 days ago
chiochuan
11
answered 2 days ago
chiochuan
11
11
New contributor
chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
– Oli
yesterday
add a comment |
Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
– Oli
yesterday
Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
– Oli
yesterday
Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
– Oli
yesterday
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53240846%2fapache-camel-how-do-i-achive-a-transactional-route-in-camel-if-i-have-a-db-acce%23new-answer', 'question_page');
}
);
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
