From: Barry Lind <barry@xythos.com>
To: Steve Wampler <swampler@noao.edu>
Cc: postgres-jdbc <pgsql-jdbc@postgresql.org>
Subject: Re: Too much data received?
Date: Mon, 09 Jul 2001 18:21:54 -0700
Message-ID: <3B4A58B2.2080303@xythos.com> (raw)
References: <3B45E785.6CAB7273@noao.edu>
<3B49E980.4396628B@noao.edu>
Steve,
In looking at the source code I couldn't explain why you would be
getting the error below. (All of the places that I see a max buffer
size specified, seem to be appropriate and shouldn't generate the error
you are seeing). Can you send a test case to the list for me to
investigate this further?
thanks,
--Barry
Steve Wampler wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
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: barry@xythos.com, swampler@noao.edu, pgsql-jdbc@postgresql.org
Subject: Re: Too much data received?
In-Reply-To: <3B4A58B2.2080303@xythos.com>
* 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