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
