From: Steve Wampler <swampler@noao.edu>
To: postgres-jdbc <pgsql-jdbc@postgresql.org>
Subject: Re: Too much data received?
Date: Mon, 09 Jul 2001 10:27:28 -0700
Message-ID: <3B49E980.4396628B@noao.edu> (raw)
References: <3B45E785.6CAB7273@noao.edu>
Steve Wampler wrote:
>
...
> Too much data was received.
> at org.postgresql.PG_Stream.ReceiveString(PG_Stream.java:306)
> at org.postgresql.Connection.ExecSQL(Connection.java:532)
> at org.postgresql.jdbc2.Statement.execute(Statement.java:294)
> at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:78)
> at OCS.database.DbServer.execute(DbServer.java:271)
>
> I seem to remember discussion on a limit in the jdbc driver that might
> be causing this, but couldn't find it in the psql-jdbc mail archives.
>
> Am I likely correct in this being the problem? Is there a fix in the
> works?
I took a look at the code for the jdbc driver and see how to increase the
size of the receive string buffer. (I think that there is no limit on
the size of a query/command, just on results - is that correct?)
Is any one looking at removing the limit entirely? I can (and have)
bumped the limit up, but wonder if it might not be better to just avoid
the problem entirely (if the back end can handle sending an absurdly
long result, why shouldn't the front end accept it?). Since the
data is coming from the backend (presumably a comparitively slow
operation), it doesn't seem that any performance hit would be
particularly noticable (if well designed) and could likely be restricted
to those cases where the results are absurdly long...
----
Steve Wampler- SOLIS Project, National Solar Observatory
swampler@noao.edu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: swampler@noao.edu, pgsql-jdbc@postgresql.org
Subject: Re: Too much data received?
In-Reply-To: <3B49E980.4396628B@noao.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox