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.ib...@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 <j...@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: cib...@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: cib...@fusesource.com Web: http://fusesource.com Twitter: davsclaus, fusenews Blog: http://davsclaus.com Author of Camel in Action: http://www.manning.com/ibsen
