Skip site navigation (1) Skip section navigation (2)

Re: Too much data received?

From: Steve Wampler <swampler(at)noao(dot)edu>
To: postgres-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Too much data received?
Date: 2001-07-09 17:27:28
Message-ID: 3B49E980.4396628B@noao.edu (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-jdbc
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(at)noao(dot)edu

In response to

Responses

pgsql-general by date

Next:From: Somazx InterestingDate: 2001-07-09 17:52:22
Subject: Re: orphaned RI constraints
Previous:From: Bruce MomjianDate: 2001-07-09 16:48:41
Subject: Re: ODBC 3.0 functions (UCASE, LCASE, etc.)

pgsql-interfaces by date

Next:From: Hiroshi InoueDate: 2001-07-09 23:03:57
Subject: Re: Getting info on "Max LongVarChar" under ODBC
Previous:From: markMLl.pgsql-interfacesDate: 2001-07-09 11:35:09
Subject: Re: Getting info on "Max LongVarChar" under ODBC

pgsql-jdbc by date

Next:From: jasonDate: 2001-07-09 17:44:57
Subject: Re: DatabaseMetaData.getCatalogs()
Previous:From: Peter EisentrautDate: 2001-07-09 16:03:28
Subject: Re: DatabaseMetaData.getCatalogs()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group