Re: JDBC execute statement with Brackets - NullPointerException

Hi. I now believe that your problem isn't clearly a bug, and I am glad to hear
that the setEscapeProcessing(false) solves it for you. The issue is whether
the driver's JDBC SQL extension parser should throw an exception or pass
the '{...}' substring unaltered to the DBMS when the '{...}' substring is not a
JDBC SQL extension. However, I found a more egregious example of the driver's parser being broken:

s.executeQuery("select 1 from dual -- SQL comment with [?} in it");

This fails because the driver should stop parsing from the '--' till the end-of-line,
but doesn't. I have entered an SR for this.

Joe Weinstein at BEA Systems Received on Tue Jan 23 2007 - 14:52:17 CST