Thanks,
I switched to the Large Object Interface and now it works fine.
Clemens
-----Ursprüngliche Nachricht-----
Von: Paul Thomas [mailto:paul@tmsl.demon.co.uk]
Gesendet: Mittwoch, 17. März 2004 19:08
An: Fuchs Clemens
Cc: pgsql-jdbc @ postgresql . org
Betreff: Re: [JDBC] BYTEA with large files leads to OutOfMemory
On 17/03/2004 15:19 Fuchs Clemens wrote:
> Hi,
>
> I'm working on a project, which has to deal with files being uploaded to
> the
> DB. I created a table using the BYTEA datataype and uploading small files
> works great. But with larger files - I tested with 2.5 MB file - the
> memory
> consumption raises incredibly and leads to a OutOfMemory exception.
>
> I noticed several discussions about this topic, but found no solution.
>
> Can someone help me?
I think you've got 2 options:
1) increase the amount of memory for the JVM
2) use the Large Object interface instead of bytea.
HTH
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+