[jira] [Commented] (CAMEL-5355) camel-sql - Should support % sign in query

["Claus Ibsen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAMEL-5355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13292756#comment-13292756 ] 

Claus Ibsen commented on CAMEL-5355:
------------------------------------

CAMEL-4425 broke this, as it changed UnsafeUriCharactersEncoder to exclude the % sign. 

The % sign should be percent encoded, if you want to use it as is, eg % should be %25 to indicate the % sign itself.
http://en.wikipedia.org/wiki/Url_encode

The % sign is otherwise used to escape values, such as space, becomes %20.
                
> camel-sql - Should support % sign in query
> ------------------------------------------
>
>                 Key: CAMEL-5355
>                 URL: https://issues.apache.org/jira/browse/CAMEL-5355
>             Project: Camel
>          Issue Type: Bug
>          Components: camel-sql
>    Affects Versions: 2.8.5, 2.9.2
>            Reporter: Claus Ibsen
>            Assignee: Claus Ibsen
>            Priority: Minor
>             Fix For: 2.8.6, 2.9.3, 2.10.0
>
>
> See nabble
> We should look into supporting the % sign in the sql component.
> It should possible be less strict in uri validation as people can enter SQL queries. And to make it easy, they should just be able to dump in the SQL as is.
> We should also consider adding an option to refer to a SQL that is enlisted in the registry.
> Also people should be able to externalize their SQL in a .properties file and have Camel lookup that using the {{ }} notation

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira