Camel - catch SQL exception and try 3 times

Question

Which exception is thrown when Camel route toF("sql:insert into ...") fails due to db connection issue?

I've try to capture like onException(CannotCreateTransactionException.class, ConnectionException.class) but it's not capturing. If i can capture it, i want to do up to 3 redeliveries and call other process something like below

.maximumRedeliveries(3)
.redeliveryDelay(10000)
.process("ConnectionExceptionProcess")
.end()

Thanks,

Answer 1

sql component can throw more than one error type. DataAccessException , IllegalArgumentException , SQLException, etc . You can solve this problem by performing only sql operations on the route you will create.You call this place from other routes

public class SqlOperationRoute extends RouteBuilder {

@Override
public void configure() {

    onException()
            .maximumRedeliveries(3)
            .process("myProcessor")
            .end();

    from("direct:insert")
            .to("sql:insert into table x .....");

    from("direct:get")
            .to("sql: select  from ....");
}

}