[CAMEL-7983] Using named query parameters doesn't work

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: 2.14.0
• Fix Version/s: 2.15.0
• Component/s: camel-sql

Environment

Windows7, ActiveMq 5.10, Camel 2.14, MySQL Server 5.6

• Estimated Complexity: Unknown
• Assignee: Claus Ibsen
• Reporter: Josef Awad
• Created: 29/Oct/14 13:13
• Updated: 02/Nov/14 08:31
• Resolved: 02/Nov/14 08:31

Description

Reference: http://camel.465427.n5.nabble.com/Using-named-query-parameters-td5758002.html

Excerpt:

Under http://camel.apache.org/sql-example.html at the very bottom it says:

Notice in the SQL queries below we use named parameters which must start with prefix ':#' and then the name, eg :#amount. Then Camel will bind that parameter with the given name, from the
message body (if its a java.util.Map) or from a message header with the name. If none parameter could be found, Camel throws an exception.

If I set a wrong parameter in the sql.properties I don't get any exception:

sql.insertPosition=insert into mydb.test (col1) values (':#DoesNotExist')