camel sql insert bean

Asked Dec 04 '15 at 12:35

Active Dec 04 '15 at 18:46

Viewed 668 times

I am trying to insert into sql using a bean in Camel. I must be missing a detail somehow, since the sql is null when reaching the camel sql components inner classes. Should it not be enough to return the map in the insertBean?

My route is defined like this.

transform().method(InsertFxBean.class).toF("sql:%s",insertQuery);

My insertBean only generates a string, object map and return it.

 class InsertBean {

    public Map<String, Object> generateInsert(final Exchange exchange) throws Exception {

       Map<String, Object> map = exchange.getIn().getBody(Map.class);
       map.put("username", value);
       //add more stuff, using 
       //namedParameters here
       return map;

I have followed the camel apache sql example

I also have tried setting different option parameters on the sql component, like useMessageBodyForSql, and batch, with no different outcome.

stackTrace shows sql is emtpy:

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

Thanks in advance

edited Dec 04 '15 at 18:46

asked Dec 04 '15 at 12:35

MRK187

1,545
2
13
20

What is your question / problem? – Claus Ibsen Dec 04 '15 at 13:08
Sorry forgot that part will update question – MRK187 Dec 04 '15 at 14:04
Are there additional methods in your InsertBean? – Fritz Duchardt Dec 04 '15 at 16:06
Hi, no is only one method I can edit question so that it contains that information – MRK187 Dec 04 '15 at 16:15
@MRK187 have you defined sequence? – Bilal Shah Dec 04 '15 at 19:00
@BilalShah yes it is, – MRK187 Dec 04 '15 at 19:07
Well your SQL is invalid says the Oracle database. Try grabbing the generated SQL and put in a SQL client to see what is the problem. – Claus Ibsen Dec 05 '15 at 07:15

camel sql insert bean

0 Answers0