camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Claus Ibsen <claus.ib...@gmail.com>
Subject Re: Using % sign in spring route sql select fails
Date Sat, 09 Jun 2012 07:03:28 GMT
Ah you did that as %25 is the % sign itself.

What version of Camel are you using?


On Sat, Jun 9, 2012 at 9:01 AM, Claus Ibsen <claus.ibsen@gmail.com> wrote:

> Hi
>
> %20 means space.
> I assume there is a similar encoding number for just the % sign.
>
>
> On Fri, Jun 8, 2012 at 10:36 AM, Jesper Olsen <jol@dr.dk> wrote:
>
>> I have a route with a select containing %-signs like this:
>>
>> <route id="netwise-Route">
>>   <from uri="direct:start" />
>>   <to uri="sql:select telno, misc3 from main where misc3 IS NOT NULL and
>> misc3 NOT LIKE '%*%'?dataSourceRef=netwiseXADataSource"/>
>> </route>
>>
>> I get this error:
>> Malformed escape pair at index 106:
>>
>> sql:select%20telno,%20misc3%20from%20main%20where%20misc3%20IS%20NOT%20NULL%20and%20misc3%20NOT%20LIKE%20'%*%'?dataSourceRef=netwiseXADataSource
>>
>> I tried escaping the %-signs like this:
>>
>> <route id="netwise-Route">
>>   <from uri="direct:start" />
>>   <to uri="sql:select telno, misc3 from main where misc3 IS NOT NULL and
>> misc3 NOT LIKE '%25*%25'?dataSourceRef=netwiseXADataSource"/>
>> </route>
>>
>> But still receives an error:
>> Malformed escape pair at index 108:
>>
>> sql://select%20telno,%20misc3%20from%20main%20where%20misc3%20IS%20NOT%20NULL%20and%20misc3%20NOT%20LIKE%20'%*%'?dataSourceRef=netwiseXADataSource
>>
>> I also tried reading the sql statement from a properties-file, but still
>> have the problem.
>>
>> Any suggestions on how to use %-signs in a sql query?
>>
>> Regards Jesper
>>
>>
>> --
>> View this message in context:
>> http://camel.465427.n5.nabble.com/Using-sign-in-spring-route-sql-select-fails-tp5714171.html
>> Sent from the Camel - Users mailing list archive at Nabble.com.
>>
>
>
>
> --
> Claus Ibsen
> -----------------
> FuseSource
> Email: cibsen@fusesource.com
> Web: http://fusesource.com
> Twitter: davsclaus, fusenews
> Blog: http://davsclaus.com
> Author of Camel in Action: http://www.manning.com/ibsen
>



-- 
Claus Ibsen
-----------------
FuseSource
Email: cibsen@fusesource.com
Web: http://fusesource.com
Twitter: davsclaus, fusenews
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message