You wrote:
> Here's the offending loop. BTW, I messed up with the
> total number of rows, it's ~6,000,000, not 600,000.
[...]
> while(dbResult.next())
Unfortunately, PostgreSQL clients always retrieve the entire
resultset from the server before it is processed by the .next()
loop.
In your case
Could you please tell me if the Postgres JDBC driver supports JDBC 2.0,
and if so at what version it was introduced?
Thank you in anticipation
Roger
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.or
This is a follow-up to my post a few days ago about the JDBC driver
chopping of strings at non-ASCII characters. First a brief summary of
the problem:
1. I create a database specifying the encoding as UNICODE.
2. I invoke psql in a standard xterm (ISO-8859-1) and insert a few
values.
3. I c
it was a typo
everything works now, problem was my actual query/update code
lacked a space after table name and the where, i.e.
"SELECT a FROM " + table_name +
"WHERE ... etc."
because of the way I had laid out my code the missing space
didn't jump out at me and the sql exception message wasn't