Thank you very much for clearing that up for me. Learn something
everyday on the postgres lists...
Oliver Jowett wrote:
> 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!".
In response to
pgsql-jdbc by date
|Next:||From: Dave Cramer||Date: 2004-05-12 02:33:30|
|Subject: Re: Retrieve the postgres transaction id|
|Previous:||From: Oliver Jowett||Date: 2004-05-12 01:15:18|
|Subject: Re: JDBC and processing large numbers of rows|