Re: JDBC driver inserting into a table with Bytea type gets

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: "Sailer, Denis (YBUSA-CDR)" <Denis(dot)Sailer(at)Yellowbook(dot)com>
Cc: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC driver inserting into a table with Bytea type gets
Date: 2004-06-21 16:55:53
Message-ID: 1087836952.6053.17.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Denis,

You will get better search results using google

just append site:postgresql.org to your search terms

Dave
On Mon, 2004-06-21 at 12:44, Sailer, Denis (YBUSA-CDR) wrote:
> There was a posting in the mailing list archives that I can't find
> anymore. The web site right now is presenting a list of items from a
> search in a reasonable amount of time, but takes 5-10 minutes to
> retrieve the detail for each one as they are clicked. Rather
> frustrating.
>
>
>
> This person was getting out of memory conditions inserting rows when
> the data in the bytea field was larger than approx. 1400 Kb. This
> person had posted a fix to the group that seemed to work for him. The
> inserts were coming from a java application using the JDBC driver.
>
>
>
> I just tried the latest JDBC driver and the problem still exists. We
> have no plans to convert to using the large object interface. This
> ties our code to PostgreSQL and would go against our need to keep the
> code generic enough to work against many different databases.
>
>
>
> Is this issue acknowledged as a bug?
>
> If yes, when is this issue going to be implemented in the code base?
>
> If it is already fixed, what are the steps to implement the changes to
> my 7.4.2 installation? Build my own JDBC driver?
>
>
>
>
> !DSPAM:40d71228141141400527835!
--
Dave Cramer
519 939 0336
ICQ # 14675561

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-06-21 19:02:09 Re: JDBC driver inserting into a table with Bytea type gets
Previous Message Sailer, Denis (YBUSA-CDR) 2004-06-21 16:44:51 JDBC driver inserting into a table with Bytea type gets out of me mory error.