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.
