db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject JDBC escape syntax -- how to escape "ordinary" braces?
Date Thu, 24 May 2007 23:25:45 GMT
When using JDBC escape syntax, as described in
http://db.apache.org/derby/docs/10.2/ref/rrefjdbc1020262.html
how do I encode "ordinary" braces so that they are ignored?

That is, if I want to do something like:

   {call myProc('arg1', 'arg2')}

but my arg1 value is {myval}, I can't seem to send

   {call myProc('{myval}', 'otherval')}

because I get an error about the '{' character in myval.

I tried escaping it with a '\' character, as in:

   {call myProc('\{myval\}', 'otherval')}

but that didn't seem to work either.

Is there a way to escape these ordinary braces?

thanks,

bryan


Mime
View raw message