Re: JDBC and processing large numbers of rows - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBC and processing large numbers of rows
Date
Msg-id 40A17AA6.5070209@opencloud.com
Whole thread Raw
In response to Re: JDBC and processing large numbers of rows  (Sean Shanny <shannyconsulting@earthlink.net>)
Responses Re: JDBC and processing large numbers of rows
Re: JDBC and processing large numbers of rows
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: JDBC and processing large numbers of rows
Next
From: Sean Shanny
Date:
Subject: Re: JDBC and processing large numbers of rows