Re: JDBC and processing large numbers of rows

Sean Shanny wrote:

> Make sure you do not end your SQL with a ; (semi colon) as that will
> cause the fetching part not to work.  Don't know why but it does. :-)

Technically, "SELECT foo;" is two statements, "SELECT foo" and "", as
JDBC doesn't require a statement terminator. The (simple-minded) JDBC
query parser doesn't do anything special to ignore trailing empty
statements. And you can't DECLARE a cursor that runs two statements.. so
the driver says "two statements, can't use a cursor!".

-O