Versions Compared

Old Version 2

changes.mady.by.user Claus Ibsen

Saved on

compared with

New Version 3

changes.mady.by.user Claus Ibsen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The elsql: component is an extension to the existing SQL Component that uses ElSql to define the SQL queries. 

...

Code Block
languagejava
   from("direct:projects")
     .setHeader("lic", constant("ASF"))
     .setHeader("min", constant(123))
     .to("elsql:projects:com/foo/orders.elsql")

And the elsql mapping file

Code Block
@NAME(projects)
  SELECT *
  FROM projects
  WHERE license = :lic AND id > :min
  ORDER BY id

...