From: | "Sailer, Denis (YBUSA-CDR)" <Denis(dot)Sailer(at)Yellowbook(dot)com> |
---|---|
To: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | JDBC driver inserting into a table with Bytea type gets out of me mory error. |
Date: | 2004-06-21 16:44:51 |
Message-ID: | 58D6EF5727036048BC9E08ECB711A42092F46E@crmsmail.corp.ybusa.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2004-06-21 16:55:53 | Re: JDBC driver inserting into a table with Bytea type gets |
Previous Message | Jie Liang | 2004-06-21 16:28:38 | Re: Prepare Statement |