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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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